A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Word » Mailmerge
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Help With Emailing Attachments



 
 
Thread Tools Display Modes
  #1  
Old November 21st, 2008, 05:03 PM posted to microsoft.public.word.mailmerge.fields
Paul Ette
external usenet poster
 
Posts: 1
Default 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  
Old November 23rd, 2008, 12:12 AM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default 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  
Old November 24th, 2008, 11:01 AM posted to microsoft.public.word.mailmerge.fields
Paul Ette[_2_]
external usenet poster
 
Posts: 1
Default 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  
Old November 24th, 2008, 08:34 PM posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP
external usenet poster
 
Posts: 8,239
Default 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






 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:46 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.