Create macro to open daily email and Excel attachment from Outlook

**wardpa** · 09-12-2012, 02:08 PM

Hello

I receive an email on a daily basis with a standard subject (Fund) which always holds an Excel file with a title that differs slightly (by date - eg ABC07.09.12) from day to day.

Would you be able to suggest how I can create a VBA macro that lets me find the email each day, open it and then save the attachment down in to a specific folder.

I'm new to VBA but am trying to pick things up as I go along.

Thanks!
Tricia

**Domenic** · 09-13-2012, 08:53 AM

The following macro will search for read and unread emails that have the subject "Fund". For each email it finds, it checks whether there are any attachments. If so, it saves any attachment to the specified folder. If, however, the file already exists, it asks whether you want to overwrite the file. Then, when it's finished with processing the email, it moves it to a subfolder within the InBox. If you don't already have a subfolder, create one and name it as desired. For this example, the subfolder is called "Fund". Note that the email is moved from the InBox to a subfolder once it processed so that it doesn't get processed a second time.

Please Login or Register  to view this content.

**wardpa** · 09-14-2012, 12:31 PM

Thank you Domenic. This is brilliant. I don't yet understand the objective of the Dim command - it seems to define applications in macro code - so the olApp example is the flag/term that relates to the Outlook application (which is recognised by VBA code), I think....but I need to learn all about this!

**Domenic** · 09-14-2012, 05:59 PM

You're very welcome! Thanks for the feedback!

As per the help file, "the Dim statement is used to declare variables and allocate storage space". For additional information, have a look at the following articles...

http://support.microsoft.com/kb/843144

http://msdn.microsoft.com/en-us/libr...ffice.10).aspx

**uimhirADo** · 10-30-2012, 09:12 PM

I can't get this to work and I am using excel 10. Am i missing something? thanks

**arlu1201** · 10-31-2012, 02:48 AM

UimhirADo,

Welcome to the Forum, unfortunately:

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.