 |
 | 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 / September 2005how can you send a email merge to over 200 with an attachment
I want to send an email merge from word via outlook to over 200 people which has an attachment. How can this be done so that the attachment is picked up and attached in the merge. 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 >I want to send an email merge from word via outlook to over 200 people >which > has an attachment. How can this be done so that the attachment is picked > up > and attached in the merge. I've only read this very quickly but will this work if my list of address etc is an excel spreadsheet? > See the article "Mail Merge to E-mail with Attachments" at > [quoted text clipped - 5 lines] > > up > > and attached in the merge. Provided that the Excel spreadsheet contains the necessary information, there is no reason that it cannot be used as the datasource for the two mailmerges that are required. 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 > I've only read this very quickly but will this work if my list of address > etc [quoted text clipped - 10 lines] >> > up >> > and attached in the merge. ok Doug I think I've got as far as running the macro and this is where I'm stuck I think! How much would you charge to run me through this operation step by step please. thanks, > Provided that the Excel spreadsheet contains the necessary information, > there is no reason that it cannot be used as the datasource for the two [quoted text clipped - 14 lines] > >> > up > >> > and attached in the merge. Post back with full details of what you have done, step by step and what happens when you run the macro. 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 > ok Doug I think I've got as far as running the macro and this is where I'm > stuck I think! How much would you charge to run me through this operation [quoted text clipped - 21 lines] >> >> > up >> >> > and attached in the merge. Well I've done the preparation part of your document: i.e thevisual basic editor selecting references from the tool menu etc I've downloaded the express click yes then at the setup stage: I've started to create a separate directory type mail merge main document Now here I'm presuming in my excel spreadsheet I need to add a column which list the file path and name - and then add this in the directory as a merge field? So I've got a document with a merge field called email and another called attachment although it isn't in a table like you describe so I'm not too sure that I have that right! I've saved that file and closed it and then the next section is where I get lost you state execute a new document to mailmerge that you want to send by email wiht hete attachments - well I've written the word doc select my list of receipients but regarding the macro I haven't got a clue! could let me know how much it would cost for you to run this through with me thanks > Post back with full details of what you have done, step by step and what > happens when you run the macro. [quoted text clipped - 24 lines] > >> >> > up > >> >> > and attached in the merge. In the directory or catalog type mailmerge main document, you DO need to set up the mergefields (the field for the email address and that containing the path and filename of the attachment in the cells of a table as described in the article. The macro will NOT work if you do not do it that way. Then, with the formletter type mailmerge document, you MUST execute that merge to a new document. When you do that, the new document will become the active document (the one on the screen) and while it is the active document, you then run the macro. 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 > Well I've done the preparation part of your document: > i.e thevisual basic editor selecting references from the tool menu etc [quoted text clipped - 53 lines] >> >> >> > up >> >> >> > and attached in the merge. Ok I think I've done everything! but when I run the Macro it comes up with the error message Compile error. user-defined type not defined and highighlights the line Dim oOutlookApp A Outlook.Application I thought it might have refered to the prepartion part where you state "check the items microsoft office Outlook 11.0 object library" but I have done this and checked it was ticked! Help! Part of me what's to give up as 'above my head' and the other part wants to crack this!!! > In the directory or catalog type mailmerge main document, you DO need to set > up the mergefields (the field for the email address and that containing the [quoted text clipped - 63 lines] > >> >> >> > up > >> >> >> > and attached in the merge. The line should be Dim oOutlookApp As Outlook.Application 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 > Ok I think I've done everything! but when I run the Macro it comes up with > the error message Compile error. user-defined type not defined and [quoted text clipped - 87 lines] >> >> >> >> > up >> >> >> >> > and attached in the merge. Ok I've got the macro to run I've set it up to do a merge to 8 email addresses but when I run the macro it attempts to merge to over 250 which is at that point where I've stopped it by closing word! help what have I done wrong. > The line should be > [quoted text clipped - 91 lines] > >> >> >> >> > up > >> >> >> >> > and attached in the merge. I believe that you emailed me about this. Hopefully now you have it worked out. 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 > Ok I've got the macro to run I've set it up to do a merge to 8 email > addresses but when I run the macro it attempts to merge to over 250 which [quoted text clipped - 114 lines] >> >> >> >> >> > up >> >> >> >> >> > and attached in the merge. |
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.