Outlook 2003 VBA - Custom Bulk Email Saving

• Project ID:

  741718

• Project Type:

  Fixed

• Budget:

  $30-$250 USD
  

Project Description:

Hi,

I am someone with a basic working knowledge of VBA - predominantly for excel - but no understanding of the MS Outlook Object Model.

For Outlook 2003 I am looking for what i think should be a relatively simple macro for someone who does understand the outlook model.

The macro needs to save in bulk the contents of an outlook folder. It must:

i) Give the user a prompt for the folder where all the emails will be saved
ii) For each email in turn in the folder give the "Save As" prompt with:
a) File type already selected *.msg
b) The filename already populated as "YYYY MM DD - SI - RI - MSGSUBJECT"

Where
YYYY MM DD = The date the email was sent from the message properties
SI = The sender's initials from the message's properties
RI = The recipient's initials from the message's properties
MSGSUBJECT = The original email subject

The idea is that the user should be able to review this information for each message before the save is performed but not have to waste time coming up with the default format for the save.

The most likely part of the message to need changing would be the 'MSGSUBJECT'. It would be excellent to have two versions of the macro, one as described above and another where before the 'Save As' Dialogue the email was visible and a messagebox appeared with the title "Message Description" with the default input the original email subject. The return of this message box could then be used to build the filename rather than the subject.

If any of the above is unclear i would be more than happy to answer any questions.

Thanks,

Paul

Skills required:

Microsoft, Visual Basic