The How-To Geek Forums Have Migrated to Discourse

How-To Geek Forums / Microsoft Office

Attaching a PDF file to an auto email sent from Excel Macro

(2 posts)
  • Started 5 years ago by amyjowsey
  • Latest reply from moreeg
  • Topic Viewed 1415 times

Posts: 1

I am using Office 2010, and have a Macro which allows me to send an email containing the infomation relating to a chose row in a table. This information includes a file path to a PDF file. Is there a way in which I can get the macro to attach the PDF file to the email using the file path which is already present in the table?
If anymore information is required please let me know...

Posted 5 years ago
Posts: 842


You don't say what email program you are using but this page will show how it's done in several of the popular ones. I tested the one for Outlook and it worked perfectly. If you download the sample worksheet and try the "SendFile" tab it will show you how it works. In the outlook sample workbook the code is in Module 5.

Let us know if this works for you or if you have any questions let us know that too.

Posted 5 years ago

Topic Closed

This topic has been closed to new replies.