Help with simple macro - looping though all emails in my inbox

[dalep]

Hello,

I'm trying to write a simple script to open and close, one-by-one, all 6,000+ emails in my outlook inbox! This will retrieve them all from my company archive to my local machine, where I often work offline and need access.

I had started opening these emails manually (in batches of 50 emails) but a friend has said I can automate this process with a macro script. I know this must be a simple operation in VB, but I don't know where to start! My google searches have found nothing that I can make sense of!! (albeit I come from a php background)

This is the process that I would like to learn how to loop through:

1. Take the first email in my inbox

2. Open it (by performing the same action as double-clicking the email sender and subject)

3. Wait for email to be retrieved from the archive and appear in a new message window

4. Close the message window and move onto the next email

Any help, pointers would be greatly appreciated. Thanks a lot in advance.

 

[Diane Poremsky]

This one is not quite what you want, but should do the trick - Saving All Messages to the Hard Drive Using VBA - Slipstick Systems - it might be better than opening because you don't need to work in a timer function. Delete the folder from the hard drive when finished... or use it as your offline archive. (I'll see if i can find some code that will do the open & close.)

 

[dalep]

This one is not quite what you want, but should do the trick - Saving All Messages to the Hard Drive Using VBA - Slipstick Systems - it might be better than opening because you don't need to work in a timer function. Delete the folder from the hard drive when finished... or use it as your offline archive. (I'll see if i can find some code that will do the open & close.)

Thanks so much for that Diane. I've run the script but unfortunately it just saves each message in its current state, without retrieving them for the archive - i.e. each message contains this text: "The original message has been archived. Click the following link to retrieve it".

It's only when I double click message (either in outlook, or now the messages folder in explorer) that it retrieves it.

Is there a way I could modify the code to open and close each message in turn? Or perhaps there is a script I could use in explorer to loop through opening each file within a folder?

 

[Diane Poremsky]

I'll look into it - i thought for sure that saving the message would download a full copy.