Help With Emailing Attachments

[Paul Ette]

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

 

[Doug Robbins - Word MVP]

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]

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]

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