I need to use outlook to send the same pdf file as an attachment to any one who requests it. All I want to do is this. After the new mail form is launched (by clicking on the recipient's email address) I want a button, or something, that will automatically insert the subject and body text (which will always be the same for every mail) attach the pdf (which will always have the same filename and be stored in the same location), and send the mail.

I'm sure this is very easy and that I'm missing something obvious but I've searched for hours and can't find what I need. Any help would be very much appreciated.

You can access the email via
Application.ActiveInspector.CurrentItem

It has a Body, and a Subject property, and an Attachments.Add funtion. For
an example see the VBA help file.

--
Best regards
Michael Bauer - MVP Outlook
Category Manager - Manage and share your categories:
SAM - The Sending Account Manager:
http://www.vboffice.net/product.html?lang=en



Am Thu, 13 May 2010 10:47:07 +0100 schrieb steve sharpe:

I need to use outlook to send the same pdf file as an attachment to any
one who requests it. All I want to do is this. After the new mail form
is launched (by clicking on the recipient's email address) I want a
button, or something, that will automatically insert the subject and
body text (which will always be the same for every mail) attach the pdf
(which will always have the same filename and be stored in the same
location), and send the mail.

I'm sure this is very easy and that I'm missing something obvious but
I've searched for hours and can't find what I need. Any help would be
very much appreciated.

Hello Michael

I'm still stuck. Thankyou for your reply which has enabled me to write a macro that works but I can't find a way to attach it to a button on the email ribbon. Since I only want a short message to be automated it does not save time if I have to open developer and run the macro manually.
Is there a way to but a button on the message ribbon that will run the macro directly? I still feel like I'm missing something... Thankyou for your help. I'm a complete novice at this stuff.

Best regards

Steve


post

For instance, for OL07 right click the toolbar of the email window, then
Edit Quick Access Toolbar (or similar). Select macros, then drag the macro's
name to the pane right hand.

--
Best regards
Michael Bauer - MVP Outlook
Category Manager - Manage and share your categories:
SAM - The Sending Account Manager:
http://www.vboffice.net/product.html?lang=en


Am Mon, 17 May 2010 12:04:22 +0100 schrieb steve sharpe:

Hello Michael

I'm still stuck. Thankyou for your reply which has enabled me to write
a macro that works but I can't find a way to attach it to a button on
the email ribbon. Since I only want a short message to be automated it
does not save time if I have to open developer and run the macro
manually.
Is there a way to but a button on the message ribbon that will run the
macro directly? I still feel like I'm missing something... Thankyou for
your help. I'm a complete novice at this stuff.

Best regards

Steve


post 'Michael Bauer [MVP - Outlook Wrote:
;348866']You can access the email via
Application.ActiveInspector.CurrentItem

It has a Body, and a Subject property, and an Attachments.Add funtion.
For
an example see the VBA help file.

--
Best regards
Michael Bauer - MVP Outlook
Category Manager - Manage and share your categories:
SAM - The Sending Account Manager:
http://www.vboffice.net/product.html?lang=en



Am Thu, 13 May 2010 10:47:07 +0100 schrieb steve sharpe:
-
I need to use outlook to send the same pdf file as an attachment to
any
one who requests it. All I want to do is this. After the new mail
form
is launched (by clicking on the recipient's email address) I want a
button, or something, that will automatically insert the subject and
body text (which will always be the same for every mail) attach the
pdf
(which will always have the same filename and be stored in the same
location), and send the mail.

I'm sure this is very easy and that I'm missing something obvious but
I've searched for hours and can't find what I need. Any help would be
very much appreciated.-

Hi Michael

Thanks very much, You solved my problem.

Best regards

Steve