View Single Post
  #6  
Old April 28th 08, 06:54 PM posted to microsoft.public.outlook.program_vba
Sue Mosher [MVP-Outlook]
external usenet poster
 
Posts: 11,651
Default Access Email Automation

By template, do you mean an .oft file? In that case, instantiate an Outlook.Application object and call its CreateItemFromTemplate method. Add a recipient, send, and repeat for as many addresses as you have.

--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54


"Emma Hope" wrote in message ...
The Access newsgroup people say i should ask the Outlook newsgroup people!!!!

The problem is knowing how to use this with an Outlook template which is
nothing to do with Access. I need to know how to pull the data from Access
and use it in Outlook with a template.

Surely this is possible?

Ads