Hi - when I select members (using categories) for a distribution list (and our co's can be large), BOTH the e-mail address and business fax get pulled into the list; we then have to go in and manually select the e-mail recipients. Is there any way to have Outlook pull in only the e-mail address? Thanks
You need to clarify what you are trying to do.
The standard behavior for the Outlook Address book is to display all
electronic addresses (both fax and e-mail). That behavior cannot be changed.
The only way to prevent the display of fax numbers is to store them in a
different field or to d...formatting cells
Operating System: Mac OS X 10.6 (Snow Leopard)
I want to make an address list with 3 lines in one cell in each row...How???
Well, I'd strongly suggest that you reconsider doing so. Jamming multiple
data items into a single cell seriously restricts how you can use/access the
data & may even prevent you from doing what "should be" simple point 'n'
click functionality... And once entered improperly trying to untangle it
after the fact is a real hassle. Have a look at Step 1 under the Excel Help
Topic: Create and print mailing labels. It sounds like what y...How do I back up autocorrects to CD?
Operating system is Windows Vista. Microsoft Word is 2003. How can I back
up my autocorrects onto a CD?
Download the template from
http://www.word.mvps.org/FAQs/Customization/ExportAutocorrect.htm. Use the
backup utility it contains to write your AutoCorrect entries to a document,
which you should save to your hard drive first, and then burn that file to
the CD. (Don't try to save the document directly to CD, bacause that could
corrupt the document.)
If you need to restore the entries, run the utility again and point the
Restore function at the CD file.
Regards...Where Do Messages Go??
If there isn't a kink in my program and it's behaving as it should, I hope
someone can answer my questions.
Messages disappear. Example: I e-mailed a friend, who e-mailed me back. When
I answered that response, I could find no trace of it in "sent mail" or
anywhere else, and the item in my inbox maintained its appearance as unread
mail. If I click "mark read" it disappears altogether. I've lost several
messages this way.
Also I seem to be unable to drag a message from one folder to another. It
gets lost in the transporter, never to be seen agai...Write-Back Cache
Is anyone ot there using write-back cache on there ARRAY controllers.? Right
now I have an Exchange system using a HP MSA 1000 SAN to house Exchange
Databases, stores, etc.
I have read in some books and some blogs that you should put write-back
cache at 100% on the array controller and there is a great perfromance gain?
Does anybody have anything to add? i.e. good idea, how much perfromance
Write-back cache should only be enabled if the array controller is battery-backed. It should be a decent performance gain. As I understand it, enabling write-back cach...How can i dived a cell in excel
I have a very large spreadsheet to work on and i have to have 2 colums one
with a number and one with a name how can i move all the other names into a
colum without having to do each one individually????
maybe try 'Data - text to <columns'
"LauraCrosssan" <LauraCrosssan @discussions.microsoft.com> schrieb im
> I have a very large spreadsheet to work on and i have to have 2
> with a number and one with a name how can i move all the ...User Defined Cells counting
Im tryin to find out how could I count a user defined cells (6 rows)
containing a string (ex. 2435 Smith Dr) using a formula. Currently, I'm
entering the count manually and I know there's a solution how to automate the
counting. If the cell is empty the value to be returned for that cell must
be 0 and if it contain the string, its value is = 1..This is how I'm
approacing it but it doesn't work using the IF function....Thanks
I'm not sure what you are trying to do, but you might look at the
Office Graphics - Visio
Microsoft Co...Backing up and restoring
I am using the built in ntbackup.exe to do backups of our exchange server.
When this was setup I used the "online" backup because I was told it was
more reliable. This is the one where you simply check the exchange server
to backup from ntbackup and it does the rest. Does the online backup also
backup everyone's email/calendars or is it only backing up the account
> I am using the built in ntbackup.exe to do backups of our exchange
> server. When this was setup I used the "online" backup because I was
> tol...Formatt cell
In Excel 2007 I am trying to select an entire column to do the same thing
for each line.
Column c is hours worked, column d is pay per hour and I want to have column
e be the total $ for that day.
I don't want to add the formula =product(c3:d3) and so on each time to
How do I make column do this atomically each line?
Thanks in advance. Bob.
I'll answer this for 2003.
Enter your formula.
Select the cell. There should be a little box in the lower RH corner. Drag
it down to the remainder of the cells you want to populate.
"bob b...CRM Navigation Bar Error Returning Back to Home
I am using CRM 1.2 and and having problems using the web interface.
I got an "error on page" error when I press the Home button in the
navigation bar at the bottom.
This normally happens when you are using XP SP2 and
do not have installed the MSCRM patches for XP SP2.
Your company for MS-CRM ADD-ONS!
GroupCalendar for MSCRM
Related Documents for MSCRM
"Abdullah SEN" <firstname.lastname@example.org> schrieb im Newsbeitrag
news:O0ShlXv9EHA.3624@TK2MSFTNGP10.ph...Where do the Archives Go?
I cannot find the information Outlook claims to have archived for me. Yes I
know how to display the archived calendar, but it's blank. Any ideas? Thanks!
I use XP, and Office 2007.
"6Sigma 5s No Clue" <6Sigma5sNoClue@discussions.microsoft.com> wrote in
>I cannot find the information Outlook claims to have archived for me. Yes I
> know how to display the archived calendar, but it's blank. Any ideas?
> I use XP, and Office 2007.
Why do you think Outook is arch...Giving dialog box control back to user during processing?
I've developed a basic dialog program using the MFC foundation wizard.
Upon pushing one of the buttons, a time consuming processing is invoked,
during which the user cannot access the 'Cancel' pushbutton, nor can the
processing in question update any fields in the dialog box. It can update
the progress bar however.
In order to release the window during this time consuming processing to
allow the user to cancel the processing, do I have to create a separate
thread? Will OnIdol() be a feasible option? Are there any simpler options
that I'm overlooking?
On ...How to hide a cell if a formula returns no value?
HI again all,
what I'm after this time is a way to hide a cell by using a formula.
This is pretty much solely for formatting reasons so that the sheet can
be cut and paste into word from excel without empty cells coming up.
I need something like this;
cell a1 contains "whatever is entered into cell a1"
in cell a2 =IF(a1="",Hide cell a2,a1)
not an overly useful example I know, but hopefully you guys get the
jist of what I mean,
----------------------------------------------------------------------...Price/cost fields need to be able to go beyond 5 decimals.
When we receive product it comes in $ per metric ton, which we convert to $
We sometimes receive product in millions of lbs. in one line item, when we
convert from $/MT to lb./MT the limit of 5 decimal places in a currency field
causes pretty lare rounding errors to occur in our extended cost.
This causes our posted cost in GP to be different than what we actually pay
The ability to extend beyond 5 decimals in the currency field would solve
the problem, but for now it is not possible in GP.
This post is a suggestion for Microsoft, and Microsof...Multiple calendars, how to choose which one meetings go into
I have 3 calendars setup in outlook XP , when someone sends me a meeting
request how can i change which calendar the meeting goes into, at the moment
they all go into what i guess is the default calendar which i want to change
to a different one
You really can't change it. Outlook treats certain folders special.
"Chris S" <email@example.com> wrote in message
> I have 3 calendars setup in outlook XP , when someone sends me a meeting
> request how can i change which calend...selecting more than one option button
I have set up a worksheet in Excel with numerous option buttons. My problem
is now it will only let me select 1 option button. How can I select multiple
You may not want option buttons. You can only have one option button in any
given grouping selected. You might want to use Check boxes instead.
> I have set up a worksheet in Excel with numerous option buttons. My problem
> is now it will only let me select 1 option button. How can I select multiple
> option buttons?
If you ha...Go to page
I have a long document and need to go the certain pages without having
to scroll down. How do I go to a particular page?
This is a multi-part message in MIME format.
Press Ctrl+G to open the GoTo dialog, and enter the page number.
Microsoft Word MVP FAQ: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.
"richard" <rmk@wo...Cell contents as the 'lookup value' parameter in HLOOKUP function
To anyone that could help me, I have the following question which I would
appreciate any answer in advance.
How can I use the contents of a cell (which I will change constantly) as the
'lookup value' parameter in an HLOOKUP function?
Cell A1 contains the value 'FY06DRN74DZ' (this are budget names I use to
HLOOKUP ('lookup_value' = makes a reference to contents of cell A1.....
and changes as I change the value of A1.
Have you looked in the HELP index for LOOKUP, vLOOKUP,hLOOKUP
...How to turn off NDRs that are being bounced back to the Internet
We are running into a major issue where spammers are
dumping ten's of thousands of messages into are Exchange
system daily which are to recipients who do not exist in
the global address list. The IMS/bridgehead server
attempts to bounce these messages back to their
originating point, but, as is typical with this type of
junk, the mail hosts are either fictitious or
unwilling/unable to accept the bounced messages. Rather
than wasting time, effort, network resources, etc. on
these messages, is there a way to configure the
IMS/bridgehead server to just delete these messages and
not...How do I get my toolbar back ?
The toolbar for my current project has disappeared from the ResourceView
(VS6), when I open the tree for 'ToolBars' it has IDR_MAINFRAME but all
that is shown is the icons available (res\Toolbar.bmp).
Any idea where's it gone to and how I get it back ? :)
Did you accidentally delete it?
If so you will have to put it in all over again.
Check your .rc file to see if any part of this is still in there
IDR_TOOLBAR1 BITMAP "res\\toolbar.bmp"
IDR_TOOLBAR1 TOOLBAR 16, 15
BUTTON ID_for first button
BUTTON ID_...How Excel converts % sign in a cell and use in formula
I am trying to figure out a formula in Excel that I know is simple, but it's
I understand about the order of operations and what has to happen first and
the absolute cell reference. I'm confused about what the 1 is in the
(1+$F$9)...the info in cell F9 is sales tax and is written as 8.25%.
Thanks in advance for the help.
Peggy Duncan, Author
Conquer Email Overload with Outlook
> I am trying to figure out a formula in Excel that I know is simple, but it's
> been years....
> ...Here we go again
Well, once again CashEdge is not connecting/syncing with Money and MSN
Money. I guess I won't run right out to buy Money 2007. Even if the software
were an improvement over M06, it cannot be any better than the weakest link
in the sync chain.
A known problem, David -- and not unique to the version of Money. Look at
"David Haynes" <firstname.lastname@example.org> wrote in message
> Well, once again CashEdge is not connecting/syncing with Money and MSN ...advice on reverting back to office 2004
Operating System: Mac OS X 10.5 (Leopard)
Because of the way that Word, Excel, and PP handle pasted graphics (converting them into pictures) I needed to revert back to Office 2004 which does not strip imbedded codes from the pictures. This is a very irritating feature, but that is another topic.
To solve this problem I removed Word 2008, and installed from the original disk Word 2004. I was using it seamlessly with the rest of Office 2008 until a day or two ago when the most recent Office 2008 update came along. Now whenever I start Word 2004 it tells me that t...If Public Folders are going away..
What would be the best/simplest solution for a user requesting a group
calendar to be used within Outlook. Ordinarily i would advise them to
create a calendar within the Public Folders hierarchy and then assign access
rights to anyone who needs it. I understand though that Public Folders will
be history with the next release of Exchange. The only thing i can think of
is to create a new mailbox, share the calendar, and then walk users through
adding it to their Outlook folder list. I suspect this isn't the best way
though. Any recommendations out there?
All clients are running ...Forced new line in a cell: Excel
I wanted to start a forced new line after typing down the texts which
wraps down automatically in a given excel cell. Pressing [Enter] just
like any other Microsoft Office documents would take me to the next
cell as selected!
Googling some online help provided a [Alt]+[Enter] keystroke would
serve the purpose. But, that's not happening, is that a bug for excel?
But, it works in my coworker's pc!
So, it's not an Excel bug - more likely to be something to do with
your PC. Try swapping the keyboard with your co-worker to check that.