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

Client Name	To Email id	CC Email ID
Client 01	shasnt.ghge@allcargolotics.com; panaj.suar@allcrgoloistics.com; trti.ramurkar@manlgistics.in	BBYOO@OO.com
Client 02	imports@pentagonindia.net; info@pentagonindia.net	BBYOO@OO.com

<tbody>
</tbody>

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

Client No	Shipments Nos
Client 01 <colgroup><col width="65"></colgroup><tbody> </tbody>	OOLU123456789 <colgroup><col width="108"></colgroup><tbody> </tbody>
Client 01 <colgroup><col width="65"></colgroup><tbody> </tbody>	OOLU987654321 <colgroup><col width="108"></colgroup><tbody> </tbody>
Client 02 <colgroup><col width="65"></colgroup><tbody> </tbody>	OOLU123456789 <colgroup><col width="108"></colgroup><tbody> </tbody>
Client 02 <colgroup><col width="65"></colgroup><tbody> </tbody>	OOLU987654321 <colgroup><col width="108"></colgroup><tbody> </tbody>

<tbody>
</tbody>

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