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
 

Some videos you may like

Excel Facts

Does the VLOOKUP table have to be sorted?
No! when you are using an exact match, the VLOOKUP table can be in any order. Best-selling items at the top is actually the best.

Watch MrExcel Video

Forum statistics

Threads
1,122,186
Messages
5,594,745
Members
413,929
Latest member
Hypatia

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