Access and outlook

[amal1973]

I have a table in an Access Database called Tbl_Contacts that has 4 columns. Department Number, Email Address, Department Manager Name, Path. I would like to send 66 Excel Workbooks to 66 Department Manager using Microsoft Outlook 2000. Every Excel workbook is name with the department Number it should go to. (ie: 0234356.xls) All emails will have the same Body. The email and subject and attachments will be different with every email. Will appreciate any help to start.
Thanks

 

[lespaul]

I would write an Outlook macro that gets all the records from Access and for each record, create the email and attach the document.

Leslie
landrews@metrocourt.state.nm.us

SELECT * FROM USERS WHERE CLUE > 0
No Rows Returned