![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
![]()
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 |
#2
|
|||
|
|||
![]()
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_sampl...ripAttachments -- Sue Mosher, Outlook MVP Author of Configuring Microsoft Outlook 2003 http://www.turtleflock.com/olconfig/index.htm and Microsoft Outlook Programming - Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx wrote in message ups.com... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Shortcuts do not work when using Insert/File Attachment | Millicent | Outlook Express | 10 | March 14th 06 09:27 PM |
Insert a hyperlink to section of Word doc in an outlook message | [email protected] | Outlook - General Queries | 0 | February 8th 06 06:07 AM |
Slow pull down menu within the insert file dialog box | Harold | Outlook - General Queries | 0 | January 26th 06 05:00 PM |
syncing attachments/colours with contact file | carolgouveia | Outlook - Using Contacts | 0 | January 25th 06 03:19 PM |
File send send Link by Email problems in IE after Thunderbird Install | Woody | Outlook - General Queries | 0 | January 8th 06 01:26 AM |