Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Attachments in Outlook :-)

Status
Not open for further replies.

Mungovan

Programmer
Oct 24, 2002
94
IE
Hi!
Basically this is my boggle;

I have a bunch of e-mails in an Outlook folder that all have attachment that are of the same type. The e-mails are sent into this Outlook folder using rules wizards, grand.

What I want to do is to be able to have Outlook to automatically extract the attachments from each message, and send the attachments to a folder on my C: Drive.

Can this be done?? I'm competent with Visual Basic. :)

Anywho, hope someone can help,
Thanks a million,
D
 
Stick this in your email sending loop and it will save a copy of each attachment with a revised filename (which is just todays date appended to the attachment filename) to your C:
myattachment = "C:\AttachmentFile.xls" 'make this a variable
.Attachments.Add myattachment, olByValue, 2
ChDir "C:\"
fordate = Format(Date, "mmddyy")
dailyfile = myattachment & "_" & fordate & ".xls"
FileCopy myattachment, dailyfile Thank you,
Dave Rattigan
 
Hi, thanks,
Where do I put this code?? And I want to keep the same attachment file as the one I receive.

Thanks,
D
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top