Automated Excel->Pdf conversion + Email sending

Ipitos

New Member
Joined
Jun 28, 2020
Messages
1
Office Version
  1. 365
Platform
  1. Windows
  2. Web
Hello!

I have a problem I've seen many different answers, but not the way I would like it to happen.


I have many excel files in folder and I need to create individual PDF files, send them to a email pointed out in the excel file, sometimes there are more than 1 email, so is it possible to search for a recipient email from the sheet or does it need to be a specific cell? There can never be any other email than the ones I want to send the file.


So in a nutshell what I would like for the VBAcode to do:

1. Create pdf from the excel file I have
2. Attach the pdf to a email and send it to the recipient that is found from the pdf/excel
- Only need to customise the Topic, since the email is the same for everyone, only pdf/recipients are unique
3. Go through that in a loop, so I could send all files from the folder without any manual work
(I need to save the excel and the pdf files, so they would need to stay in the same folder)

Thank you so much in advance, this could possibly save me so many working hours.
 

Some videos you may like

Excel Facts

How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.

Watch MrExcel Video

Forum statistics

Threads
1,112,799
Messages
5,542,574
Members
410,560
Latest member
1ndependent
Top