 |
 | 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 / November 2003email merge with attachments
Hi, Im trying to send attachments with emails using mail merge. I know that this isnt possible to do using outlook so I wondered if there was a way to merge all emails without sending them straight away? Can I send merged emails to a folder then add the attachments before sending them? Many thanks Nicola Hi Nicola, See the article "Mail Merge to E-mail with Attachments" at http://www.mvps.org/word/FAQs/MailMerge/MergeWithAttachments.htm Please post any further questions or followup to the newsgroups for the benefit of others who may be interested. Unsolicited questions forwarded directly to me will only be answered on a paid consulting basis. Hope this helps Doug Robbins - Word MVP > Hi, > Im trying to send attachments with emails using mail [quoted text clipped - 5 lines] > Many thanks > Nicola Thanks for this Doug. I got as far as creating a word document but dont know how to do macros. Do you know of a site which will talk me precisely through every step? Thanks again Nicola >-----Original Message----- >Hi Nicola, [quoted text clipped - 20 lines] > >. Hi Nicola, See the article "What do I do with macros sent to me by other newsgroup readers to help me out? I don't know how to install them and put them to use" at: http://www.mvps.org/word/FAQs/MacrosVBA/CreateAMacro.htm Please post any further questions or followup to the newsgroups for the benefit of others who may be interested. Unsolicited questions forwarded directly to me will only be answered on a paid consulting basis. Hope this helps > Thanks for this Doug. I got as far as creating a word > document but dont know how to do macros. Do you know of a [quoted text clipped - 31 lines] > > > >. Hi Doug, I managed to run the macro so it attaches the right document to the emails but the email itself is blank without the personalised email merge- can you tell me what im doing wrong? Thank you Nicola >-----Original Message----- >Hi Nicola, [quoted text clipped - 48 lines] > >. Hi Nicola, Do you have the document created by the mailmerge as the active document when you are executing the macro? These lines of the code Source.Sections.First.Range.Cut Documents.Add Selection.Paste Set oItem = oOutlookApp.CreateItem(olMailItem) With oItem .Body = ActiveDocument.Content Create a new document for each record that contains the content of the relevant section of the document created by the execution of the mailmerge. That new document then becomes the body of the email message that is sent. If you want to include a subject line, add the following command after .Body = .Subject = "This is the subject" Please post any further questions or followup to the newsgroups for the benefit of others who may be interested. Unsolicited questions forwarded directly to me will only be answered on a paid consulting basis. Hope this helps Doug Robbins - Word MVP > Hi Doug, > I managed to run the macro so it attaches the right [quoted text clipped - 63 lines] > > > >. Hi Doug- thanks a million for this- ive cracked it now. I was doing the mail merge as an email merge - not realising the macro converted resulting the word document to an email. Its saved me days of work!! Thanks so much Nicola >-----Original Message----- >Hi Nicola, [quoted text clipped - 95 lines] > >. |
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.