Split mail merge letters and send email

Hi friends,

Since long time I’m trying to split the mail merge letters and sends by email.

I want to split the mail merge letters and send it to friends by email individually.

Please see the attached workbook and do suggest me a code for it positively.

Thanking you in anticipation.

Is there a reason for not merging direct to email? No code required.

Hi macropod,
Thank you for your quick positive response. If it's possible to create a mail directly and send a separate letter to each of my friend individually then I have no problem. I don't have any idea to do it.

Will you please suggest me a code to accomplish my target since a long time?

Thank you,

When you do a mailmerge in Word, the first step is, logically enough, to click on the 'Start Mailmerge' button. The second option on the drop-down there is to merge to email. As I already said, no code is needed for any of this...

Thank you for suggestion.

To avoid the repeated job and save time I have recorded a macro to achieve the target. If there is no email id, I have a dash sign. If there is a dash sign in email column then I’m getting error.

I have recorded the code so there are some unwanted command lines which I didn’t understand. I have no password for word and excel file.

Please Login or Register  to view this content.

I request you to please clean up the code and suggest me a concrete solution positively.

Sorry for trouble.

Thanking you.

As I keep saying, there is no need for any code to do this. Simply set up your mailmerge main document in Word and save it. From then on, there is no 'repeated job' to avoid; all anyone needs to do is click 'finish and merge'.

As for the error regarding dashes:
a) you should not have anything except valid email addresses in the email address column (even for a manual merge); and
b) if you are going to do this programmatically with bad data, you need to loop through each record and test its contents so bad data can be skipped over. That means using quite different code to what the recorder can produce.

Hi macropod,

Greetings from me!

Thank you. Now I understood why the error is. Repeated job means whenever I want to send mails I have to do all the steps each time which I don’t want. I want to achieve it by simply clicking of 'SendMail' button automatically.

b) If you are going to do this programmatically with bad data, you need to loop through each record and test its contents so bad data can be skipped over.
Yes I want to do it programmatically to speed up the job and skip those entries which have no valid email address in email field, have a dash sign instead of email address.
Therefore, I request you do suggest me a proper code to achieve it programmatically.

Sorry for trouble.

Thank you and have a nice day.

Originally Posted by mso3

Repeated job means whenever I want to send mails I have to do all the steps each time

Garbage. You obviously haven't paid any attention to what I posted in my last reply:

Simply set up your mailmerge main document in Word and save it. From then on, there is no 'repeated job' to avoid; all anyone needs to do is click 'finish and merge'.

Hi macropod,

I agree with you but I want to speed up the work automatically. I understood your suggestion.

Repeated job:
Click on ‘Yes’ first
Click on ‘Finish’ second
Click on ‘Email message’ third
Click on ‘Ok’ fourth

So there are 4 steps to repeat each time.

There are about 1000 entries in my database.
Some members have no email address. So there is a dash sign instead of email address.
It’s taking a long time to send all email messes.
If there is a dash sign in email field then I’m getting error.

I want to skip all these problems so repeatedly I’m requesting you to suggest me a code to achieve the target in a single click quickly.

Hope this will help you to understand my problem well.

Thanking you in anticipation.

Originally Posted by mso3

Hi macropod,

I agree with you but I want to speed up the work automatically. I understood your suggestion.

Repeated job:
Click on ‘Yes’ first
Click on ‘Finish’ second
Click on ‘Email message’ third
Click on ‘Ok’ fourth

So there are 4 steps to repeat each time.

Hardly worth a macro, which would save only one or two clicks...

Some members have no email address. So there is a dash sign instead of email address.

That's hardly the right way to go about it - a 'proper' database would only have valid data in the fields - fields for which there are no data should be empty.

It’s taking a long time to send all email messes.

A macro won't make that any quicker; indeed, using VBA instead of an application's built-in functionality generally takes take longer...

Hi macropod,

Thank you for guidance.

The dash sign problem is solved by keeping the cell empty.

I think The speed up problem will be solved by using

Please Login or Register  to view this content.

Thanking you.

Originally Posted by mso3

I think The speed up problem will be solved by using

Please Login or Register  to view this content.

No, it won't:
• .screenupdating doesn't do anything for a mailmerge to email because a mailmerge to email doesn't update the screen anyway.
• .enableEvents will cause errors because that's for Excel, not Word.
• .calculation will cause errors because that's for Excel, not Word.
Instead of wasting time, why don't you just accept that VBA doesn't automatically make something better???

Hi macropod,

Thank you for clearing my concept of mail merge.

I appreciate you for the same.

Have a nice day.