SEARCH

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 1 year ago by amyjowsey
  • Latest reply from moreeg
  • Topic Viewed 1415 times

amyjowsey
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 1 year ago
Top
 
moreeg
moreeg
Posts: 842

Hi

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 1 year ago
Top
 



Topic Closed

This topic has been closed to new replies.