Outlook/Access?

[McNasti]

Hello All:

I've been asked to create module that would on the event of every new email received by a specified folder, create a record in an Access table containing the Subject, Sender and Timestamp relating to that New email.

What would be the best approach? and would I create this module within Outlook or Access.

I am runnung Outlook, Access and Windows 2000.

Thank you in advance for your help and ideas.

Patty

 

[bradles]

Patty,

Either approach has pros & cons but I'd go for the Outlook module, adding records to your Access table on the Application NewMail event.

See

http://www.slipstick.com

and

http://www.outlookcode.com

for excellent resources.

Brad