Outlook Object Model - Mail Merge

[Guest]

Please see my original question & then the response from Mr. Robbins. I've
followed the link, however, because I have no experience with Visual Basic,
can anyone help me with a step by step how to?

Thanks a bunch!!
Vera



You cannot do that with mail merge "out-of-the-box"

It would be possible to do it using the Outlook Object Model (probably not
for beginners) an example of the use of which can be seen in the article
"Mail Merge to E-mail with Attachments" at

http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm

Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP


Help, I'm very new to mail merge. I need to email a standard letter to more
than one recipient at a company. Example, Joe, Bob & Tom all work for XYZ
Co. and Jill, Jane & Tina work for ABC Co. I have an excel spreadsheet that
lists their email address & the company they work for. I need to send one
email to everyone at XYZ and one email to everyone at ABC. Everyone at ABC
needs to know who else received the email at ABC but can not know that we
sent it to XYZ Co.

Any help is appreciated.

 

[Michael Bauer [MVP - Outlook]]

After you have created the catalogue (data source for addresses) you need to
copy the code into that document, therefore open the VBA editor (ALT+F11)
and select the document. Then you can run the code, probably by ALT+F8, from
the document, or from the VBA editor by setting the cursor into the code and
pressing F5.

--
Viele Gruesse / Best regards
Michael Bauer - MVP Outlook
-- www.VBOffice.net --



Am Thu, 19 Oct 2006 10:47:01 -0700 schrieb Vera Lemon: