Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Help With Emailing Attachments
Hi all,
I have been trying to set up a mailmerge with attachments using Doug's macro with some degree of success. When I run the macro the emails with attachments are created and sent however I seem to get one extra blank email being produced to the last person in the catalog. Any ideas would be gratefully accepted and tried. Regards Paul |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Help With Emailing Attachments
I recently modified the code in that article to try and overcome an issue
that a lot of people were having when they did not follow the instructions correctly and it seems like the following line of code For j = 1 To Source.Sections.Count needs to be modified to For j = 1 To Source.Sections.Count - 1 Try that and let me know how you get on. -- 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 "Paul Ette" Paul wrote in message ... Hi all, I have been trying to set up a mailmerge with attachments using Doug's macro with some degree of success. When I run the macro the emails with attachments are created and sent however I seem to get one extra blank email being produced to the last person in the catalog. Any ideas would be gratefully accepted and tried. Regards Paul |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Help With Emailing Attachments
Hi Doug,
I have tried your suggestion and that did the trick, thank you. The message box was also giving the incorrect count so I have also updated the message box code to: MsgBox Source.Sections.Count - 1 Just for my peace of mind do you have any idea why this has been a problem? Particularly as the rest of the process is working as expected. Many thanks. Paul "Doug Robbins - Word MVP" wrote: I recently modified the code in that article to try and overcome an issue that a lot of people were having when they did not follow the instructions correctly and it seems like the following line of code For j = 1 To Source.Sections.Count needs to be modified to For j = 1 To Source.Sections.Count - 1 Try that and let me know how you get on. -- 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 "Paul Ette" Paul wrote in message ... Hi all, I have been trying to set up a mailmerge with attachments using Doug's macro with some degree of success. When I run the macro the emails with attachments are created and sent however I seem to get one extra blank email being produced to the last person in the catalog. Any ideas would be gratefully accepted and tried. Regards Paul |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Help With Emailing Attachments
Hi Paul,
There is an error in the article that I recently updated so that it iterates through the Sections of the document created by executing the Letter merge rather than through the rows of the table in the Directory type mail merge that has to be created as part of the process. I made that change because many people were not executing the letter merge, but running the macro with the letter merge main document as the active document, which would then only have one section and as a result, they were sending our email messages with no text in the body. In making the modification, I overlooked that when the letter merge is executed to a new document, there is a continuous section break at the end of the document. I will have to get the article on the website updated. Thanks for bringing the problem to my attention. -- 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 "Paul Ette" wrote in message ... Hi Doug, I have tried your suggestion and that did the trick, thank you. The message box was also giving the incorrect count so I have also updated the message box code to: MsgBox Source.Sections.Count - 1 Just for my peace of mind do you have any idea why this has been a problem? Particularly as the rest of the process is working as expected. Many thanks. Paul "Doug Robbins - Word MVP" wrote: I recently modified the code in that article to try and overcome an issue that a lot of people were having when they did not follow the instructions correctly and it seems like the following line of code For j = 1 To Source.Sections.Count needs to be modified to For j = 1 To Source.Sections.Count - 1 Try that and let me know how you get on. -- 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 "Paul Ette" Paul wrote in message ... Hi all, I have been trying to set up a mailmerge with attachments using Doug's macro with some degree of success. When I run the macro the emails with attachments are created and sent however I seem to get one extra blank email being produced to the last person in the catalog. Any ideas would be gratefully accepted and tried. Regards Paul |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
emailing | Microsoft Word Help | |||
emailing an attachment | Microsoft Word Help | |||
Emailing from word | Microsoft Word Help | |||
emailing a form | Microsoft Word Help | |||
Emailing | Microsoft Word Help |