Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Word / Mailmerge and Fax / February 2007

Tip: Looking for answers? Try searching our database.

mail merge-email with attachments

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Michelle Hanan - 16 Feb 2007 21:42 GMT
I have a macro that merges data from a worksheet onto a document and then to
the printer. Instead of going to the printer, it now needs to be emailed. So
I inserted the addresses into the worksheet and added a mergefield on the
documents. The only problem is that first of all I can't get the code right
and secondly I want to be able to attach other misc. documents to the email
before it is sent and I can't seem to find a way to do that. Thanks
Peter Jamieson - 16 Feb 2007 22:07 GMT
You have to do some coding, e.g. in VBA. See Doug Robbins' article at

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

Peter Jamieson

>I have a macro that merges data from a worksheet onto a document and then
>to the printer. Instead of going to the printer, it now needs to be
[quoted text clipped - 3 lines]
>documents to the email before it is sent and I can't seem to find a way to
>do that. Thanks
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.