Karen Stephen,
1. Open Word FILE New Document Select Email Message Select the Excel
file as your source Select the recipients Construct the message with
message and all the Mergefields that you need. Do not insert the
email_address field, into the message body.
2. On the MailMerge toolbar Select Merge to Email You will have to option
to send to the email address mergefield, this will put a recipient's email
address in the TO Line: for each message, you will not need to use the CC:
or BCC: Line Also add you subject line manually that you want to use
Select OK.
3. You will get a warning that some program is trying to access the Outlook
Address book Select Yes each time to send each message there is a third
party program called ClickYes that has been recommended to avoid this. I
personally have not used it, so I have no opinion on its merits.
ClickYes Download:
http://www.snapfiles.com/get/clickyes.html
--
Add MS to your News Reader:
news://msnews.microsoft.com
Rich/rerat
(RRR News) message rule
Previous Text Snipped to Save Bandwidth When Appropriate
"Karen Stephen" Karen
wrote in message
...
I am trying to do a mail merge in Outlook. I have all of the e-mail
addresses
in an Excel file. I can't figure out how to get the e-mail addresses in to
the To:, CC: or BCC: fields. The e-mail addresses keep ending up in the body
of my message next to the greeting line, even if I put the cursor elsewhere.
Everything works fine until we get to the e-mail address part of the mail
merge. Is there some trick I am missing?