Runner
This app. will merge data from Access to a Word document and then send the document out as an attachment using Collaborative Data Objects (CDO).
Some Keywords:
Outlook, MAPI, NameSpace, MailItem, Recipient, Attachment, FileSystemObject, ADODB.Connection, ADODB.Recordset, ADO 2.6, Word.Application, MailMerge, OpenDataSource, SQL creation, Array, HotCode, Spaniel (you have to find it)
You will have to do a bit of work to get set up (if you don't have CDO/Exchange Server), but you can adapt the Outlook function I have in order to do the emailing.
Any questions, then please drop them on the site and I'll endeavour to get back to you.
Cheers, and if there are any bugs, stodgy code etc then let me know and I'll try to fix. I hope that you find this interesting and if you do and like the cut of my code, then give me a rating. Cheers
Regards,
The GazMan
(3(3 Vote))