Outlook exiting box hangs forever
Running Outlook 2000 on exchange 2000.
If the outlook is open for couple days and when i close it, exiting box
But, if I open and close outlook right away or within couple hours, it exits
Do you have it set to synch offline folders? If yes, and you have received a
lot of mail and only have it set to sync on shutdown, it will, of course,
take more time after a couple of days worth of items need to be synched.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the SWEN virus, all mail sent to...Change Value on Combo Box upon event
Is there a way that I can change the value on a Combo Box to the last record
in its record source?
I have a combo box that displays Fiscal Years, from 2000 to Current fiscal
year 2007. Users can select any year they wish to pull data from based on
the year selected. However, I want the combo Box to change its value to the
current Fiscal year (which is the last record presented to them when they
select the drop down) based on a specific event.
Anybody have any ideas?
Me.CourseID = Me.CourseID.ItemData(Me.CourseID.ListCount - 1)
"Angel_G" ...Problem with "Search box" in Help window
We are using Excel 2003 on XP. This problem is occuring for all users.
When you click Help-Microsoft Excel Help, and try to type in the Search for:
box under Assistance, the text is inserted into the spreadsheet instead.
The only way you can manage to enter any text into this box is to copy it,
then right-click paste it into that box (Edit-Paste and Ctrl+V do not work)
I can't find anything in the kbase (except for the tip about pasting).
What is up with this?
...Can I determine which cells on a sheet are locked and which are not?
Is there any kind of report, etc. I could look at that
would tell me what cels are unlocked or vice versa on a
I have 8 worksheetsin a workbook, with each sheet
comprised of more than 550 rows and 14 columns. I could
tab from cell to cell to determine if I have all the
desired cells locked, but with nearly 60,000 cells, that
is not at all feasible.
Does anybody have any ideas? Basically all I'm wanting to
do is to be sure that all of my cells that need to be are
locked, so that when I share this workbook I need not
worry about others getting into areas they...Selecting a large range of cells?
I'm not too strong with Excel so this might be an easy question.
I have a large workbook with about 50K rows and about 100 columns. I need to
sort this large range of data by different columns from time to time. I know
how to sort it by just holding down the left mouse button and dragging the
highlighted area to include the range. Then I go to "data" / "Sort". This
just takes way too long to do each time for a range this size.
I hope there is a better way to include this large range without having to
"grab" it all manually.
Type ...Outlook Coding
I have code to send emails progamtically from a module in Excel 2000 using OUtlook 2000, but now I need to have the code select 1 of 5 different email addresses and potentially a different mail server. Any ideas?
Set NewMail = CreateObject("Outlook.Application")
Set objmail = NewMail.CreateItem(olMailItem)
.To = Email
.Subject = "Quotes for " & Name
.Body = emailtext
Set NewMail = Nothing
Set objmail = Nothing
Submitted...The form required to view this message cannot be displayed. Contact your help ad
I'm trying to open email that contains forwarded
email's. I'm using Outlook 2002 w/SP-2 and XP Pro on
clean installs. I can save the attachments but would
like to just display them if possible.
...Have Outlook Today display certain calendar categories
Anyone know how I could (with or without add-ins) have outlook display
only certain calendar categories?
I want to exclude some day-to-day calendar items from showing up and
cluttering the space :)
create a custom view?
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/
<email@example.com> wrote in message
news:1158197...Cell referencing 12-14-09
I have a sales\stock level related problem. Each row on the worksheet
represents a sales day. Column A contains the previous days sales figure, a
list of numbers in the range 1 to 20. Column B is the daily stock level
which starts at 100 (cell B1) and decreases each day by the previous days
sales figure ( the adjacent A cell). Column C is a list of the number of days
it takes to deliver the items when they are re-ordered and will be in the
range 1 to 4 (days). If the stock level (column B) goes below 11 then a
re-order (which is 100 items) is placed and arrives in x number of d...Remove blank entries from a list box either using VBA or basic formula #3
Havent thought about using dynamic ranges before.....I am a bit of
I shall look into this as you suggest.
Celtic_Avenger's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1410
View this thread: http://www.excelforum.com/showthread.php?threadid=27183
...Insert PDF into Excel Cell?
I would like to do a MS Word mail merge using excel as the data source
for a fax blast. However, I need to send a specific page to a
specific fax number. I was thinking of setting up an excel document
with [name, fax number, document] columns as the data source, and then
merge with my word document. My concern is that each recipient get
the correct (individualized) page, along with the cover sheet.
Is is possible to embed a file (pdf or word) into an excel cell? That
way, i could use the excel file to set up the merge (Name1, Fax
Number1, Document 1; Name2, Fax Number,2 Document 2; Name3,...outlook 2003 amend display as on all contacts
I would like to change the Display As entry for All Contacts .
currently it shows the name and then the email address in brackets, but
would prefer it to show the Name or the File As name
Is there any way I can change the lot without having to manually do that??
...Cell contents as Chart Title
Is there a way of using the contents of a cell on a worksheet as th
title for a chart on that same worksheet? Please bear in mind that I a
using Excel 97, although I would be interested to hear if it wa
possible in later versions of Excel as it may give me ammunition for a
Stephen Pain's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1526
View this thread: http://www.excelforum.com/showthread.php?threadid=27624
You can link the chart title to a ce...Selecting Multiple Shapes and Lines
In Excel 2003, lines and shapes could easily be selected by clicking on the
arrow in the drawings menu and drawings a box around the objects. I am now
using Excel 2007, but have not found anywhere to change the coursor from the
standard cross to a pointer. Is this one of the features that did not get
transfered over, or have I just not found it yet? Thanks for the help.
If I understood your question - try this:
In the Ribbon - Click 'Home' > at the far end 'Edit' section > click on
'Search & Choose' > in the sub-menu click 'choose object..."Check Marking" a cell
Can I format (via Macro???) a cell so that if the user left clicks on the
cell a check mark appears without using the Control Toolbox. The cells with
such format will only need to then be the totaled (via =counta(x:x).
There's no left click you can tie into. You could base it on selection (either
the mouse or the keyboard), but you could use rightclick for this:
If that's ok, rightclick on the worksheet tab that should have this behavior.
Select view code and paste this into that code window:
Private Sub Worksheet_BeforeRightClick(ByVal Target As Range, Cancel...Shared Calendars not Displaying User Name
Outlook 2003 / Exchange 2003, both fully patched and running on XP Pro SP2.
Shared calendars added under "Open a shared calendar". Header of calendars
only displays "Calendar", not the username of the shared calendar owner.
How can I get Outlook to display the username, please. At the moment I have
multiple calendars open and they all are headed "Calendar". Not very
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for W...Cell formating and summing imperial weights
Does anybody know how to format cells for using imperial weight
(pounds, ounces and drams) and how do I then summ these values to als
give the result in pounds, ounces and drams
Woody's Profile: http://www.msusenet.com/member.php?userid=575
View this thread: http://www.msusenet.com/t-187117693
On Wed, 9 Nov 2005 03:39:09 -0600, Woody <Woody.firstname.lastname@example.org>
>Does anybody know how to format cells for using imperial weights
>(pounds, ounces and dram...Print Range Doesn't Display
I have a multi worksheet file which Vie used without incident for five
years. Today, I inserted a page break and also selected a print area. I
found that, although the area and page break shows correctly in Print
Preview, neither the page break nor the print area outline box appear on the
The tools | Options | General shows "Display All"..
Even more curious, if I do the same on one of the other worksheets in the
file, the area displays correctly.
>>The tools | Options | General shows "Display All"..
But more on point, is Tools, Options...change display font to actual selected font
My excel worksheet is using the font comic sans ms although in the Normal
page layout, the font used is Arial. In the format toolbar, comic sans ms is
selected and when the sheet is printed, it appears correctly.
What's your zoom level?
If you change the zoom factor to 100% does it look ok?
If yes, then maybe this post by Debra Dalgleish will help:
You can change a registry setting to prevent this from happening (make a
backup copy of the registry first):
1. From the Start button, choose Run
2. Type regedit then click OK
3. Click the + sign to the left of HKEY_CURRENT_USER
4. Open ...can you capture info from a cell without retyping in another cell
I'd like to be able to update the salutation in a letter with the person's
name in the address without having to retype it. I am using Microsoft Office
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
> I'd like to be able to update the salutation in a letter with the
> person's name in the address without having to retype it. I am using
> Microsoft Offi...Cutting first 4 digits from a cell and pasting it into an adjacent column
Using 2007 on Vista
I've got some data I want to import from excel into my crm software
For type of business here in the UK we use 'SIC' codes
However, the data I have purchased has the SIC code followed by it's
I want to seperate the first 4 digits which is for the SIC code and
leave the description behind as per the following
3320: Manufacture Of Instruments & Appliances For Measuring, Checking,
Testing, Navigating & Other
Which I want to seperate into
SIC code 3320
SIC description Manufacture Of Instruments & Appliances For
how do you display a shortcut menu with the mouse?
Just click on the right mouse button in lieu of your regular left mouse
button. This works in any Microsoft application & is very helpful.
> how do you display a shortcut menu with the mouse?
...multiple cascading combo boxes* not the usual.
I am having a problem with multiple cascading combo boxes... yet this isn't
the usual situation thoroughly covered by many posts. I wasn't able to find
What I have is a category combo box than changes the products combo box-
this part is working fine. However what I want is a category combo box that
when updated, updates the three product combo boxes below.
What I am aiming at getting is to have the user select a major category and
up to three products within that category which will be stored into a table.
Is this the best option or is there a way to use a ...Combo Box Lookup 07-14-07
How Do I Create a Combo Box Lookup, which only shows me related
drawings to which project ive selected in my enquiry, Query? the
drawings are in a related table to a project table?
Assuming you have a Form with a field to select the Project and the ComboBox
lookup field. In the AfterUpdate event of the Project field set the Combo
Box's row source to a query which filters records in your drawings tables
with the related record in your Projects table. The SQL statement (to query
the records) would look something like this:
"SELECT tblDrawings.somefield1, tblDrawings.somef...Can't add a 0 (zero) to the beginning of a number in a cell
I am trying to put a serial number in a cell but it starts with a zero.
After I type in 09867453 and move to the next cell the 0 disappears.
You can format the cell to be text and it will then allow a 0 to be
added to the front of a number however this may cause problems if you
are using that number in inequalities.
> I am trying to put a serial number in a cell but it starts with a zero.
> After I type in 09867453 and move to the next cell the 0 disappears.
The first answer is correct however it may be alot easier if you add an