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
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