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


Recommended: Clean Your Mac the Easy Way with CleanMyMac 3

If you want to clean up your Mac the easy way, CleanMyMac is a great tool to get the job done easily, and it will even keep your computer clean automatically.

Unlike the competition, it also includes great tools like a Clean Uninstaller, to get rid of applications and clean up the junk that they leave behind. All with the click of a button.

Download CleanMyMac 3 for Free Today

Posted yesterday 
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 3 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 3 years ago

Topic Closed

This topic has been closed to new replies.