Macro to send saved pdf file (within my F:) to an Outlook recipient named in a named range ( Email_To) of the current sheet

Tink0301

New Member
Joined
Sep 30, 2014
Messages
1
Hi
I am not a Macro Whiz by any means, but somehow managed to set up an Excel Spreadheet, and set a button to save the file as a pdf within my F: (F:POrequest.pdf) then delete the file, and create a little pop up box to say that the message is sent.

My issue is that the old Macro for sending the file was linked to Groupwise email.
We are now using Microsoft Outlook 2010 and I can't remember how I got the Macro to do the sending bit.
I have unticked any boxes in the VBA Project References that referred to Groupwise & ticked the bix for the Outlook Library, but I'm not sure if this is sufficient.

I had saved each bit separately & added them all together on a button in the correct order, so it is just the macro for finding the pdf file within the F: then attaching it to an email to the email address within the range on the active sheet "Email_To" a subject of "Purchase Order Request" and a message body of "Please can you raise the attached PO"
Then the next Macro will continue with the little message box.

Your help would be greatly appreciated.

Thanks
Clair
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,163,891
Messages
5,834,263
Members
430,273
Latest member
Windrunner

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top