Breaking up an Excel Doc and Sending to Multiple Users

[jcwilliams9]

I am looking for the code to take a list of contacts (similar to a mail merge file) and email a separate attachment to each contact, i.e. Contact A gets ‘File A’, contact B gets ‘File B’, etc with the same body of text in each email. Ideally, the macro would loop through the list of contacts, email each contact their unique attachment, and include a standardized body of text.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Is this possible without an add-in?<o></o>

 

[lizzycole_photos]

I have been able to this through the mail merge function in Word 07 by adding code to add the appropriate attachment before sending to each recipient.

Here is the link that I used to help me through mine. I hope this helps you too!!

See the article "Mail Merge to E-mail with Attachments" at

[URL]http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm[/url]

 

[jcwilliams9]

Thank you for the response, I am unable to open the link. Do you have the full web address available?

 

[lizzycole_photos]

Here ya go - try this (I'm still trying to figure out how to do all this)

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

 

[lizzycole_photos]

See the article "Mail Merge to E-mail with Attachments" at

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

 

[lizzycole_photos]

Ok...maybe this time

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

 

[jcwilliams9]

the second link you sent worked and sent me to the site. At first glance this looks like it is exactly what I was looking for, thank you!