Need to be able to send email with attached PDF file based on a list

**jkhuskies** · 08-15-2019, 05:54 PM

Hello,

Currently I have a workbook that can create a pdf file from a list and stores it in a location. I have tried creating a macro that looks at the list and sends the pdf file to the emails specified in the list.

I have not been able to figure out why the file doesn't get attached.

Please Login or Register  to view this content.

Any help would be appreciated!

Thanks,
Jonathan

**jkhuskies** · 11-08-2019, 03:41 PM

I was able to solve the issue. Here is the working code.

Please Login or Register  to view this content.

**PCI** · 11-09-2019, 03:55 AM

Thx for the feedback

Need to be able to send email with attached PDF file based on a list

LinkBack

Thread Tools

Rate This Thread

Display

Need to be able to send email with attached PDF file based on a list

Re: Need to be able to send email with attached PDF file based on a list

Re: Need to be able to send email with attached PDF file based on a list

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Respond email using Outlook based in data in Range A9 (from attached file)

VBA Send email to Contact Group / Distribution List File

[SOLVED] Use a drop down list to send a different email based on selection

macro to send an email with an active excel sheet attached

Generate path of a file in column and send email as attachment based on a cell value

Send excel file attached in email

Send email integrating cell data into Subject and Body, with attached invoice

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions