Excel to outlook mail merge VBA

[Lakshmi Narain]

Dear All,

PFA of the excel sheet, In that i have mentioned 4 tables, In right side of table i have mentioned the To and CC mail id's of Fake. I want to send every table separately to the given mail ID in right side of the table. Table should copy and paste in the mail body. is there any VBA Script for this

I will attach a screenshot of the body of mail in outlook
Is there any possible for the date should automatically today's date in both body and subject.

 

[bobhc]

One of the best sites for mailing from Excel.


http://www.rondebruin.nl/win/section1.htm


.

 

[Lakshmi Narain]

One of the best sites for mailing from Excel.


http://www.rondebruin.nl/win/section1.htm

.

Thank You Bobhc Hope it will help me but I have some doubt. How to apply todays date in body of text & Subject.

 

[Lakshmi Narain]

Thank you, I did it.

 

[bobhc]

Pleased you worked it out, did you do it via the link or some other method, if by some other method perhaps you could explain so that it will show in any searches made.

 

[Lakshmi Narain]

Pleased you worked it out, did you do it via the link or some other method, if by some other method perhaps you could explain so that it will show in any searches made.

Thanks a lot. i have done my task.

 

[bobhc]

But you are not going to say how you did it.....

 

[Lakshmi Narain]

But you are not going to say how you did it.....

With the URL you shared. I study the scrips and customized for my requirement.
For Subject I used my text and with the current date VBA script.
My task is one day i want to send 5 reports for different teams. I made a template as i attached and i created 5 different module in Macros and create the distribution list separately for different team. while i run it will send to all 5 teams

 

[bobhc]

Sounds like you have done a first class job, it is a very good site with a lot of helpful excel subjects.


.