 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Word / Mailmerge and Fax / February 2007Mail merge email with attatchments
I have a macro that is in an excel worksheet. The macro merges data from the worksheet into word documents and then merges the finished product to the printer. Right now I am trying to set up a new macro that instead of merging it to the printer, it merges to email. The catchup is that I need to also add a mergefield that adds attatchments to the email. I am stuck. I put a mergefield in the word document and added the field to the worksheet, but it's not pulling anything when I just go through the mail merge toolbar buttons. Any help would be great. Thanks! Using the out-of-the-box facilities, you can merge to email using a plain text or HTML body and no atttachments, or with a completely blank message with an attachment, but not both. For a method of e-mailing with attachments, see Doug Robbins' article at http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm Peter Jamieson >I have a macro that is in an excel worksheet. The macro merges data from >the worksheet into word documents and then merges the finished product to [quoted text clipped - 4 lines] >but it's not pulling anything when I just go through the mail merge toolbar >buttons. Any help would be great. Thanks! So far I have an email field that sends the document fine....but is there any way to stop the email before it is sent so I can add an attachment that way? > Using the out-of-the-box facilities, you can merge to email using a plain > text or HTML body and no atttachments, or with a completely blank message [quoted text clipped - 14 lines] >>worksheet, but it's not pulling anything when I just go through the mail >>merge toolbar buttons. Any help would be great. Thanks! The only way I know that's likely to work is to set Outlook so it does not send, do the merge, open each e-mail in the Outbox, add the attachment, then eventually re-enable Outlook so it sends. I don't know of a way that lets you interrupt a merge to email - you would have to do /something along the general lines/ of the code in Doug's article to do that. Peter Jamieson > So far I have an email field that sends the document fine....but is there > any way to stop the email before it is sent so I can add an attachment [quoted text clipped - 18 lines] >>>worksheet, but it's not pulling anything when I just go through the mail >>>merge toolbar buttons. Any help would be great. Thanks!
|
Reply to this Message |
 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.