Automate Excel Mail merge msgs to multiple email id

[Akshay_divecha]

Hi,

I am new to mail merge and while going thru posts and instructions i could not find post wherein it shows the steps to send mail merge email to multiple email id.

If this is the repeated post, would appreciate if some one would relay me to correct post and apology for re-posting.

Requirements as below,

Excel "Sheel 1" contains list of clients with their multiple email ID's for e.g as below

[TABLE="width: 1000"]
<tbody>[TR]
[TD]Client Name
[/TD]
[TD]To Email id
[/TD]
[TD]CC Email ID
[/TD]
[/TR]
[TR]
[TD]Client 01
[/TD]
[TD]shasnt.ghge@allcargolotics.com; panaj.suar@allcrgoloistics.com; trti.ramurkar@manlgistics.in
[/TD]
[TD]BBYOO@OO.com
[/TD]
[/TR]
[TR]
[TD]Client 02
[/TD]
[TD]imports@pentagonindia.net; info@pentagonindia.net
[/TD]
[TD]BBYOO@OO.com
[/TD]
[/TR]
</tbody>[/TABLE]

Excel "Sheet 02" contains, shipment details of clients.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Client No
[/TD]
[TD]Shipments Nos
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 65"]
<colgroup><col width="65"></colgroup><tbody>[TR]
[TD="width: 65"]Client 01[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 108"]
<colgroup><col width="108"></colgroup><tbody>[TR]
[TD="width: 108"]OOLU123456789[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 65"]
<colgroup><col width="65"></colgroup><tbody>[TR]
[TD="width: 65"]Client 01[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 108"]
<colgroup><col width="108"></colgroup><tbody>[TR]
[TD="width: 108"]OOLU987654321[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 65"]
<colgroup><col width="65"></colgroup><tbody>[TR]
[TD="width: 65"]Client 02[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 108"]
<colgroup><col width="108"></colgroup><tbody>[TR]
[TD="width: 108"]OOLU123456789[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
[TR]
[TD][TABLE="width: 65"]
<colgroup><col width="65"></colgroup><tbody>[TR]
[TD="width: 65"]Client 02[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD][TABLE="width: 108"]
<colgroup><col width="108"></colgroup><tbody>[TR]
[TD="width: 108"]OOLU987654321
[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[/TR]
</tbody>[/TABLE]

We are currently notifying our clients by sending emails manually.

Any way where mail merge can help to send this in one click.

Appreciate your guidance.

 

[Akshay_divecha]

Dear Experts,

Need your guidance...

Tks

 

[Akshay_divecha]

Dear Experts,

Any suggestions

 

[pvr928]

Hi Akshay_divecha

No need to re-invent the wheel: have a look through Ron De Bruin's examples: https://www.rondebruin.nl/win/s1/outlook/mail.htm

Cheers

pvr928