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
|
|||
|
|||
mail merge with attachments
Hello,
I found this article with details on a macro to have an attachment with a ma il merge: http://word.mvps.org/faqs/mailmerge..Attachments.htm It works nicely if you just run the macro but if you want to merge fields in a mail merge document itself it will not do it. I guess the part I am not getting is, I would like to run the mail merge and have the macro run after the fields are populated in the word document. Th is would fill the fields required with the pertinent information then attach the applicable attachment. By just running the macro, the mail merge runs and attaches the document but the fields in the word document only show the merge fields (not actual valu es). Does anyone know how to do this? The document says: 'Then execute the mail merge that you want to send out by email with the att achments and with the result of execution of that mail merge on the screen, run a macro containing the following code. When the File open dialog appear s, select the file containing the table created by the catalogue type mail m erge.' From the sounds of this, the mail merge should run as normal then call up th e macro to add the attachment. But, in my case, the mail merge runs without calling up this macro - any ideas? |
#2
|
|||
|
|||
YOU have to run the macro which is what " and with the result of execution
of that mail merge on the screen, run a macro containing the following code. " says. You must also follow exactly all of the steps in the process if you want it to work. -- 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 "AS" wrote in message ... Hello, I found this article with details on a macro to have an attachment with a ma il merge: http://word.mvps.org/faqs/mailmerge..Attachments.htm It works nicely if you just run the macro but if you want to merge fields in a mail merge document itself it will not do it. I guess the part I am not getting is, I would like to run the mail merge and have the macro run after the fields are populated in the word document. Th is would fill the fields required with the pertinent information then attach the applicable attachment. By just running the macro, the mail merge runs and attaches the document but the fields in the word document only show the merge fields (not actual valu es). Does anyone know how to do this? The document says: 'Then execute the mail merge that you want to send out by email with the att achments and with the result of execution of that mail merge on the screen, run a macro containing the following code. When the File open dialog appear s, select the file containing the table created by the catalogue type mail m erge.' From the sounds of this, the mail merge should run as normal then call up th e macro to add the attachment. But, in my case, the mail merge runs without calling up this macro - any ideas? |
#3
|
|||
|
|||
Thanks for the reply Doug,
I think I am missing something on this though. I followed the document to a T but when I run the macro, the first merge works fine. The fields in the first email message are filled in according to the data source and the appropriate attachment is in the message. All subsequent messages are sent with the proper attachments but the email messages are blank. No text, no merged fields, just blank. I am using Word 2003 as the directory / catalog and actual document to merge. I am using excel 2003 as the data source. I am using Outlook 2003 setup to an exchange server for the mail application. I think I may be missing something here in your instructions: 'Then execute the mail merge that you want to send out by email with the attachments and with the result of execution of that mail merge on the screen,' I have the mail merge document on the screen and have the first record fields showing (I tried running this showing different record sets as well with the same result) - I go to run the macro and select the directory merge I created as stated earlier in the instructions. The email merge runs fine. But I check the resultant emails sent / received and only the first email in the list has the correct fields merged - all others are blank. Any suggestions? Is there something different with Word 2003 to cause this? AS "Doug Robbins - Word MVP" wrote in message ... YOU have to run the macro which is what " and with the result of execution of that mail merge on the screen, run a macro containing the following code. " says. You must also follow exactly all of the steps in the process if you want it to work. -- 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 "AS" wrote in message ... Hello, I found this article with details on a macro to have an attachment with a ma il merge: http://word.mvps.org/faqs/mailmerge..Attachments.htm It works nicely if you just run the macro but if you want to merge fields in a mail merge document itself it will not do it. I guess the part I am not getting is, I would like to run the mail merge and have the macro run after the fields are populated in the word document. Th is would fill the fields required with the pertinent information then attach the applicable attachment. By just running the macro, the mail merge runs and attaches the document but the fields in the word document only show the merge fields (not actual valu es). Does anyone know how to do this? The document says: 'Then execute the mail merge that you want to send out by email with the att achments and with the result of execution of that mail merge on the screen, run a macro containing the following code. When the File open dialog appear s, select the file containing the table created by the catalogue type m erge.' From the sounds of this, the mail merge should run as normal then call up th e macro to add the attachment. But, in my case, the mail merge runs without calling up this macro - any ideas? |
#4
|
|||
|
|||
Is it the mailmerge main document that you have on the screen when you run
the macro or have you executed the mailmerge to a new document and then it is with that document on the screen that you should run the macro. -- 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 "AS" wrote in message ... Thanks for the reply Doug, I think I am missing something on this though. I followed the document to a T but when I run the macro, the first merge works fine. The fields in the first email message are filled in according to the data source and the appropriate attachment is in the message. All subsequent messages are sent with the proper attachments but the email messages are blank. No text, no merged fields, just blank. I am using Word 2003 as the directory / catalog and actual document to merge. I am using excel 2003 as the data source. I am using Outlook 2003 setup to an exchange server for the mail application. I think I may be missing something here in your instructions: 'Then execute the mail merge that you want to send out by email with the attachments and with the result of execution of that mail merge on the screen,' I have the mail merge document on the screen and have the first record fields showing (I tried running this showing different record sets as well with the same result) - I go to run the macro and select the directory merge I created as stated earlier in the instructions. The email merge runs fine. But I check the resultant emails sent / received and only the first email in the list has the correct fields merged - all others are blank. Any suggestions? Is there something different with Word 2003 to cause this? AS "Doug Robbins - Word MVP" wrote in message ... YOU have to run the macro which is what " and with the result of execution of that mail merge on the screen, run a macro containing the following code. " says. You must also follow exactly all of the steps in the process if you want it to work. -- 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 "AS" wrote in message ... Hello, I found this article with details on a macro to have an attachment with a ma il merge: http://word.mvps.org/faqs/mailmerge..Attachments.htm It works nicely if you just run the macro but if you want to merge fields in a mail merge document itself it will not do it. I guess the part I am not getting is, I would like to run the mail merge and have the macro run after the fields are populated in the word document. Th is would fill the fields required with the pertinent information then attach the applicable attachment. By just running the macro, the mail merge runs and attaches the document but the fields in the word document only show the merge fields (not actual valu es). Does anyone know how to do this? The document says: 'Then execute the mail merge that you want to send out by email with the att achments and with the result of execution of that mail merge on the screen, run a macro containing the following code. When the File open dialog appear s, select the file containing the table created by the catalogue type m erge.' From the sounds of this, the mail merge should run as normal then call up th e macro to add the attachment. But, in my case, the mail merge runs without calling up this macro - any ideas? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Secured DB for a Word Mail Merge problem | Tony_VBACoder | General Discussion | 1 | August 30th, 2004 10:11 PM |
Word-Excel 2000 Mail Merge Failure | Jim | Mailmerge | 1 | August 12th, 2004 02:43 PM |
Outlook Mail Merge to WinFax Pro | [email protected] | General Discussion | 0 | July 30th, 2004 07:26 PM |
Mail Merge to Fax - Word 2003 | Paul | General Discussion | 1 | June 9th, 2004 02:19 PM |
Mial merge data base problems | Rachael | Mailmerge | 16 | May 21st, 2004 06:22 PM |