Carmelo_Iorianni_NWCCAC
asked on
Import Exchange Mailbox into SQL
I would like to automatically check an Exchange mailbox and import the messages into a SQL 2000 Database.
What is the best way to do this? T-SQL? DTS?
If you have an example of a script to do this, that be excellent.
Thank you,
What is the best way to do this? T-SQL? DTS?
If you have an example of a script to do this, that be excellent.
Thank you,
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hmm, I don't think you can do so.
Have you tried using the linked server?
Have you tried using the linked server?
ASKER
Thank you,
From the links you provided, I was able to use xp_readmail to check a mailbox and import the messages into a MS SQL DB.
From the links you provided, I was able to use xp_readmail to check a mailbox and import the messages into a MS SQL DB.
ASKER
When using xp_readmail, is there any way to retrive the accual address in CC field? Currently when I import the CC it just shows the firendly name (example for jon.doe@somewhere.com, it just shows doe, jon)
Thank you