Outlook 2003 VBA - Custom Bulk Email Saving


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"


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.



Beceriler: Microsoft, Visual Basic

Daha fazlasını görün: Email VBA, vba save email msg, save email outlook 2003 user, vba with, email bulk sender, bulk outlook 2003, outlook 2003 bulk email vba, saving outlook emails bulk, outlook vba bulk email, bulk save emails outlook, what is vba in excel, what is vba, vba time, vba for, microsoft vba, microsoft macro, microsoft excel VBA, in vba, vba, vba excel, vba excel macro, VBA and excel, outlook visual basic, outlook email, mm

İşveren Hakkında:
( 1 değerlendirme ) Manchester, United Kingdom

Proje NO: #741718



Over ten years experience in developing Microsoft Office solutions.

1 gün içinde 30$ USD
(9 Değerlendirme)

6 freelancers are bidding on average $77 for this job


Hello. Ready to help. I'm creating add-ins for Outlook, compartible with Outlook 2000-2010 Using several languages to do it, including Visual Basic 6.0 that is similar to VBA. Could you please answer question Daha fazlası

in 2 gün içinde80$ USD
(62 Değerlendirme)

Please see PMB

1 gün içinde 66$ USD
(43 Değerlendirme)

Please see PMB.

1 gün içinde 55$ USD
(2 Değerlendirme)

See my Profile. I am into tool development VBA. I will be the right person to do this job

1 gün içinde 30$ USD
(0 Değerlendirme)

15 years experience working with Macros and VBA in office products

in 30 gün içinde200$ USD
(1 Değerlendirme)