 |
 | 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 / General MS Word Questions / September 2007Add attachment to e-mail Mail merge
Hello, Does anybody know how to add an attachment to a mail merge e-mail from Word (2007)? I have to send a message to about 45 recipients, giving them a personalized username/password and at the same time I want to add a manual as a (.pdf) attachment. The username, password and email address are found in a (excel)file. When I complete the mail merge, I don't have the opportunity to add an attachment. If this is not possible from Word, do you know a way to work around this? (To me this looks like something that is done more often). Thanks in advance. See the article "Mail Merge to E-mail with Attachments" at http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm  SignatureHope 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 > Hello, > Does anybody know how to add an attachment to a mail merge e-mail from [quoted text clipped - 9 lines] > (To me this looks like something that is done more often). > Thanks in advance. Thanks a lot Doug, I will try this today! > See the article "Mail Merge to E-mail with Attachments" at > [quoted text clipped - 13 lines] > > (To me this looks like something that is done more often). > > Thanks in advance. Doug -- I've tried your Macro. I can see where it would work if the email being sent to folks is identical, but we're wanting to send individualized emails out to folks all with the same attachment. When I tried following your instructions and completed my merge on the second document then executed the macro, it successfully sent the first email with attachment but all other recipients received a blank email with the attachment. What am I doing wrong? Thanks, Paul > See the article "Mail Merge to E-mail with Attachments" at > [quoted text clipped - 13 lines] > > (To me this looks like something that is done more often). > > Thanks in advance. The mail merge that produces the individualised letters must be executed with the destination being a new document and then the macro must be run when that new document (the one containing each of the individual letters) is the active document. It sounds like you have run the macro when you are perhaps previewing the results of the mail merge and have not actually executed it. SignatureHope 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 > Doug -- > [quoted text clipped - 36 lines] >> > (To me this looks like something that is done more often). >> > Thanks in advance. Lion; Did this work? I have the same problem exactly as you have described. I sent out a personalized letter each week to over 300 people and would like to add a PDF file as an attachment, but 2007 gives no option to do so. Please advise. SignatureGeorge Mancuso President Gman Business Resources > Hello, > Does anybody know how to add an attachment to a mail merge e-mail from Word [quoted text clipped - 7 lines] > (To me this looks like something that is done more often). > Thanks in advance. See the article "Mail Merge to E-mail with Attachments" at http://word.mvps.org/FAQs/MailMerge/MergeWithAttachments.htm It works with Word 2007 as well. SignatureHope 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 > Lion; > [quoted text clipped - 18 lines] >> (To me this looks like something that is done more often). >> Thanks in advance. Hi, I have also tried this macro and it is still not working let me know wher I am going wrong, here are the steps followed by me:- 1. Open the word file and save the email address and the attachement path against each name. 2. Close the file after saving it. 3. Open the template for mail merge and select the "Directory" Option 4. Apart from the save the macro in this file. 5. After going thru the entire mail merge process it creates a new doc with each page representing each person in the database. 6. Run the macro 7. Select the word file where we have saved the email and path 8. Provide a subjetc line 9. Keep clicking "yes" After doing this outlook does send a email but it is blank email with only the attachement with it. Please tell me where am I going wrong. Thanks. SignatureRegards, Pranay Shah > See the article "Mail Merge to E-mail with Attachments" at > [quoted text clipped - 24 lines] > >> (To me this looks like something that is done more often). > >> Thanks in advance. It sounds like you have changed to type of the mail merge main document that forms the message that will be sent to each recipient into a directory type mail merge main document and then you have executed that merge to a new document. That is not correct. That main document must remain as a formletter type main document. You need to create a new Directory type mail merge main document that uses the same data source and execute that to a new document, then save and close it and then with the document created by executing the Formletter type merge as the active document, you then run the maco. SignatureHope 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 > Hi, > [quoted text clipped - 53 lines] >> >> (To me this looks like something that is done more often). >> >> Thanks in advance. Hello George, I have not yet followed the procedure as described in the link. Out of lack of time, I sent 2 seperate emails (one with the username / password and the other with the attachment). As soon as I have tryed it, I'll let you know! > Lion; > [quoted text clipped - 14 lines] > > (To me this looks like something that is done more often). > > Thanks in advance. Can I make a suggestion here? The best solution I have found for sending out emails to customers with different attachements based, say on a field in a spreadsheet, is a 3rd party solution http://www.mapilab.com/outlook/mail_merge/ I am NOT employed by them! Works a treat > Hello George, > [quoted text clipped - 21 lines] > > > (To me this looks like something that is done more often). > > > Thanks in advance. |
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.