Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook - Using Forms (http://www.outlookbanter.com/outlook-using-forms/)
-   -   Macro to add an attachment (http://www.outlookbanter.com/outlook-using-forms/5552-macro-add-attachment.html)

Bear February 2nd 06 06:13 PM

Macro to add an attachment
 
I have been asked to investigate whether we could have a series of "buttons"
within a tool bar which will add certain specified files (ie: one per button)
to an already opened e-mail - but I simply do not know how to start. Within
excel it is easy - since there is the record feature and trying to transpose
my exel programming skills to this is proving difficult.

I am guessing that this is easy - so does anyone have any advice?

Thanks

Hollis D. Paul February 3rd 06 05:57 AM

Macro to add an attachment
 
In article 5b49639029f3b@uwe, Bear wrote:
I have been asked to investigate whether we could have a series of "buttons"
within a tool bar which will add certain specified files (ie: one per button)
to an already opened e-mail - but I simply do not know how to start. Within
excel it is easy - since there is the record feature and trying to transpose
my exel programming skills to this is proving difficult.

I am guessing that this is easy - so does anyone have any advice?

The following articles on my blog describe how I generate a Word file, save it
to the file system, then create an e-mail item, and attach the file to it. You
can find the code that attaches the file to the final message, and add it to
your code. Putting your buttons on a toolbar is going to cause you more grief
that attaching the message.

If these articles are too much like heavy lifting, then you should look for an
attachment sample on www.outlook-code.com or www.slipstick.com.

Automating Tip Capture with Office Systems 2003 - Part 1
http://msmvps.com/blogs/obts/articles/71691.aspx

Automating Tip Capture with Office Systems 2003 - Part 2
http://msmvps.com/blogs/obts/articles/71693.aspx

Hollis D. Paul [MVP - Outlook]
Mukilteo, WA USA





All times are GMT +1. The time now is 08:50 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com