If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how 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. |
#2
|
|||
|
|||
how can you send a email merge to over 200 with an attachment
See the article "Mail Merge to E-mail with Attachments" at
http://word.mvps.org/FAQs/MailMerge/...ttachments.htm -- Hope 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 "LJ" wrote in message ... 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. |
#3
|
|||
|
|||
how can you send a email merge to over 200 with an attachment
I've only read this very quickly but will this work if my list of address etc
is an excel spreadsheet? "Doug Robbins" wrote: See the article "Mail Merge to E-mail with Attachments" at http://word.mvps.org/FAQs/MailMerge/...ttachments.htm -- Hope 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 "LJ" wrote in message ... 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. |
#4
|
|||
|
|||
how can you send a email merge to over 200 with an attachment
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. -- Hope 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 "LJ" wrote in message ... I've only read this very quickly but will this work if my list of address etc is an excel spreadsheet? "Doug Robbins" wrote: See the article "Mail Merge to E-mail with Attachments" at http://word.mvps.org/FAQs/MailMerge/...ttachments.htm -- Hope 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 "LJ" wrote in message ... 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. |
#5
|
|||
|
|||
how can you send a email merge to over 200 with an attachment
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, "Doug Robbins" wrote: 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. -- Hope 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 "LJ" wrote in message ... I've only read this very quickly but will this work if my list of address etc is an excel spreadsheet? "Doug Robbins" wrote: See the article "Mail Merge to E-mail with Attachments" at http://word.mvps.org/FAQs/MailMerge/...ttachments.htm -- Hope 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 "LJ" wrote in message ... 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. |
#6
|
|||
|
|||
how can you send a email merge to over 200 with an attachment
Post back with full details of what you have done, step by step and what
happens when you run the macro. -- Hope 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 "LJ" wrote in message ... 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, "Doug Robbins" wrote: 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. -- Hope 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 "LJ" wrote in message ... I've only read this very quickly but will this work if my list of address etc is an excel spreadsheet? "Doug Robbins" wrote: See the article "Mail Merge to E-mail with Attachments" at http://word.mvps.org/FAQs/MailMerge/...ttachments.htm -- Hope 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 "LJ" wrote in message ... 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. |
#7
|
|||
|
|||
how can you send a email merge to over 200 with an attachment
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 "Doug Robbins" wrote: Post back with full details of what you have done, step by step and what happens when you run the macro. -- Hope 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 "LJ" wrote in message ... 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, "Doug Robbins" wrote: 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. -- Hope 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 "LJ" wrote in message ... I've only read this very quickly but will this work if my list of address etc is an excel spreadsheet? "Doug Robbins" wrote: See the article "Mail Merge to E-mail with Attachments" at http://word.mvps.org/FAQs/MailMerge/...ttachments.htm -- Hope 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 "LJ" wrote in message ... 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. |
#8
|
|||
|
|||
how can you send a email merge to over 200 with an attachment
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. -- Hope 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 "LJ" wrote in message ... 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 "Doug Robbins" wrote: Post back with full details of what you have done, step by step and what happens when you run the macro. -- Hope 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 "LJ" wrote in message ... 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, "Doug Robbins" wrote: 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. -- Hope 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 "LJ" wrote in message ... I've only read this very quickly but will this work if my list of address etc is an excel spreadsheet? "Doug Robbins" wrote: See the article "Mail Merge to E-mail with Attachments" at http://word.mvps.org/FAQs/MailMerge/...ttachments.htm -- Hope 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 "LJ" wrote in message ... 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. |
#9
|
|||
|
|||
how can you send a email merge to over 200 with an attachment
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!!! "Doug Robbins" wrote: 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. -- Hope 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 "LJ" wrote in message ... 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 "Doug Robbins" wrote: Post back with full details of what you have done, step by step and what happens when you run the macro. -- Hope 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 "LJ" wrote in message ... 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, "Doug Robbins" wrote: 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. -- Hope 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 "LJ" wrote in message ... I've only read this very quickly but will this work if my list of address etc is an excel spreadsheet? "Doug Robbins" wrote: See the article "Mail Merge to E-mail with Attachments" at http://word.mvps.org/FAQs/MailMerge/...ttachments.htm -- Hope 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 "LJ" wrote in message ... 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. |
#10
|
|||
|
|||
how can you send a email merge to over 200 with an attachment
The line should be
Dim oOutlookApp As Outlook.Application -- Hope 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 "LJ" wrote in message ... 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!!! "Doug Robbins" wrote: 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. -- Hope 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 "LJ" wrote in message ... 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 "Doug Robbins" wrote: Post back with full details of what you have done, step by step and what happens when you run the macro. -- Hope 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 "LJ" wrote in message ... 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, "Doug Robbins" wrote: 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. -- Hope 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 "LJ" wrote in message ... I've only read this very quickly but will this work if my list of address etc is an excel spreadsheet? "Doug Robbins" wrote: See the article "Mail Merge to E-mail with Attachments" at http://word.mvps.org/FAQs/MailMerge/...ttachments.htm -- Hope 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 "LJ" wrote in message ... 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. |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how do i send a mailmerge email using a merge field as subject? | emitecaps | Mailmerge | 3 | June 15th, 2005 04:35 PM |
mail merge email attachment problems | Jimmy | Mailmerge | 1 | April 21st, 2005 08:30 AM |
Email attachment not available | OzBo | Outlook Express | 4 | April 1st, 2005 07:53 AM |
Sending Mail Merge to Email to Multiple Recipients in the Same Mes | Mark V | Mailmerge | 11 | December 20th, 2004 10:58 PM |
Merge to Fax with SBS/Exchange? | Tom | Mailmerge | 3 | May 18th, 2004 11:22 PM |