Excel/Mail Merge/Convert to PDF and Send email

[Damir]

Hi All,

Need your help.

Is there an option to write a VBA code for the follwoing: I need to send PDF file to email address

- I have the list of staff in excel with details like emp id, name, date of Join, title, departmet, salary, email etc.
- With Mailmerge help I create word doc addressed to staff
- Mailmerge doc converted to PDF format and send to email address of particular staff

Appreciate your help.

▬▬▬▬▬▬▬▬▬ Mod edit : thread moved to appropriate forum !

​

 

[Sumit Kumar Jayswal]

Hi All,

Need your help.

Is there an option to write a VBA code for the follwoing: I need to send PDF file to email address

- I have the list of staff in excel with details like emp id, name, date of Join, title, departmet, salary, email etc.
- With Mailmerge help I create word doc addressed to staff
- Mailmerge doc converted to PDF format and send to email address of particular staff

 

[Deepak]

You can directly do the same from Excel with word. Do a search as we have lot's of post regarding the same.
Share sample Excel, Word/PDF and email if having no luck.

 

[mdfreeman]

Hey @Damir

The best resources for this are from Ron de Bruin

Page here: Mail from Excel and make/mail PDF files - https://www.rondebruin.nl/win/section1.htm

I suggest working with the addin he has created: Mail Add-ins for Excel for Windows. It is a great tool!

Mark