How do I make a macro that automatically adds attachments.

M

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

Michael Bauer [MVP - Outlook]

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:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top