Excel attachments in

QuestionEdit

Hi there I work for a healthcare company, and receive approx 700 emails each week, each one being from a separate nursing home, that havespreadsheet attachments that have to be saved into excel, and renamed, according to which nursing home has sent the email, eg home ABC needs to have its attachment renamed to ABC.xls. When the email arrives, the attachment can be called anything, eg Weekly report, Monday report, hours report or any combination of these. Do you know of any easy way to do this? At the moment I have to do a "file, save as" on every one, and it takes me about 2 days! I feel this is a very inefficient way of doing it, but dont know how to do it any differently.

Thanks Gail

AnswerEdit

Gail,

take a look at this site and see if this will work for you:

http://www.fontstuff.com/outlook/oltut01.htm

If not, do a google search on vbaattachment

I am assuming your are usingsince that is referenced in your subject.