VBA - Move MSG files into Outlook

[CMIIandExcel]

Hi all I need to write a bit of VBA to move msg files from a disk location into Outlook.

Once I have moved them into Outlook I then have to read the list of recipients from the email to process into a database.

I am fine with the reading the names once I have the email in out look but I am a bit stuck on how to approach getting the email into outlook in the first place.

Does anyone have any code they are willing to share to help me do this? or can anyone point me in the right direction on how to accomplish this?

Thanks in advance for your assistance


(I am working with about 40k emails, the list of recipients is populated back against a record of the email held in a database)

Regards


Michael

 

[PrompIt]

This is old but i have a near identical problem. Did you ever find a solution?

 

[CMIIandExcel]

If i recall correctly I ended up using redemption to import the emails into a PST.

there is a thread here OutlookCode.com :: Import .msg files with redemption on the topic.

I had a quick look but couldnt find the code I had previously written.

Hope that is of some help

Michael