Macro to speed email creation

  • Thread starter Thread starter steve sharpe
  • Start date Start date
S

steve sharpe

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

I'm sure this is very easy and that I'm missing something obvious bu
I've searched for hours and can't find what I need. Any help would b
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:
 
Hello Michael

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

Best regards

Steve

;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 t
any
one who requests it. All I want to do is this. After the new mai
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 th
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.
Click to expand...
 
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

;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.-
Click to expand...
Click to expand...
 
Hi Michael

Thanks very much, You solved my problem.

Best regards

Steve

'Michael Bauer [MVP - Outlook said:
;349056']For instance, for OL07 right click the toolbar of the emai
window, then
Edit Quick Access Toolbar (or similar). Select macros, then drag th
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 t
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 automate
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 ru
the
macro directly? I still feel like I'm missing something... Thankyo
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.Ad
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.--
Click to expand...
 
Back
Top