PC Review


Reply
Thread Tools Rate Thread

How do I make a macro that automatically adds attachments.

 
 
Mike
Guest
Posts: n/a
 
      28th Jan 2010
I'm looking to make a macro (I think that's the best solution) that will
automatically add attachments to my messages when certain text appears in the
message.

For example, let's say I say "please sign and return form 1880 - make sure
to complete sections A, B, and C", then the form correlating to form 1880
automatically adds to the message. My verbiage is always the same as I
already use autocorrect to make each of the line-items in my emails by have a
string of characters autocorrect to the long explanations of what needs to be
done. Typically I have 5-20 of these per message and I have to go back and
add all the attachments after writing the message, but it would save me a lot
of time to have them auto add.
 
Reply With Quote
 
 
 
 
Michael Bauer [MVP - Outlook]
Guest
Posts: n/a
 
      28th Jan 2010


You could search the text in the ItemSend event. Use the Instr function for
that. If you detect a certain phrase, use the Attachments.add function to
add your attachment.

--
Best regards
Michael Bauer - MVP Outlook
Manage and share your categories:
<http://www.vboffice.net/product.html?pub=6&lang=en>


Am Wed, 27 Jan 2010 19:33:01 -0800 schrieb Mike:

> I'm looking to make a macro (I think that's the best solution) that will
> automatically add attachments to my messages when certain text appears in

the
> message.
>
> For example, let's say I say "please sign and return form 1880 - make sure
> to complete sections A, B, and C", then the form correlating to form 1880
> automatically adds to the message. My verbiage is always the same as I
> already use autocorrect to make each of the line-items in my emails by

have a
> string of characters autocorrect to the long explanations of what needs to

be
> done. Typically I have 5-20 of these per message and I have to go back and
> add all the attachments after writing the message, but it would save me a

lot
> of time to have them auto add.

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
macro automatically save attachments to several emails from the same sender ThomasX Microsoft Outlook VBA Programming 0 6th Jun 2011 02:59 PM
how do i make a totals fieldthat adds automatically =?Utf-8?B?TWlyYQ==?= Microsoft Access 1 14th Aug 2006 02:26 AM
how do you make a macro run automatically when a criteria is met? =?Utf-8?B?TGVlIENyZXc=?= Microsoft Excel Programming 3 13th Jul 2006 04:07 PM
How to make a link that automatically adds an appointment to calen =?Utf-8?B?bWVzc2VuZ2VyMQ==?= Microsoft Outlook Calendar 1 21st May 2005 01:18 AM
how do I make picture attachments open automatically? =?Utf-8?B?d2luYm95cw==?= Microsoft Outlook 1 1st Jan 2005 12:43 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:28 PM.