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.
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.