Insert file paths for attachments into message on send.

[architimmy]

I'm new to VBA so please excuse any overtly obvious questions I might
ask.

I am trying to create a macro that will run each time a user sends a
message. Before sending, the macro will check the message for
attachments and then write the file paths for those attachments into
the message (preferrably the end or end of most recent comment if a
discussion). This is primarily to track document transmissions without
having to retain the (large) attachment files on the network or
locally.

Principly I am interested in how one can automate this process to run
each time a message is sent. Of course some coaching on some other
issues like identifying the message object and pulling it's attachment
collection, how one can loop over the collection and the syntax for
creating and adding to a String variable (with line breaks) works in
VBA.

Once again apologies for any overly obvious (and yes I admit lazy)
questions.

Thanks!
Tim

 

[Sue Mosher [MVP-Outlook]]

These samples show various ways to save attachments and put file names in messages:

http://www.fontstuff.com/outlook/oltut01.htm
http://www.outlookcode.com/codedetail.aspx?id=70
http://www.slovaktech.com/code_samples.htm#StripAttachments


--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003

and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers