Access Email Automation

[Emma Hope]

Hi All,

I need to send an email to a group of people from Access, this is the
scenario....

I run a query to select the people i want to send to (approx 20 people), i
want to send the same email to each of the 20 but i want to send each one
individually i.e. personalise it, Hi John, Hi Sarah, Hi Dave etc....... using
the [First Name] field from my query. The rest of the email stays the same.

I know how to use SendObject to email one person at a time from an Access
macro but i want send all 20 at once, i don't need to view the email before i
send but i do want to be able to make the email look nice, i.e. some bold
text, change the font colour etc, i believe i need a template to do this but
i don't know how to make one.

Can someone help me do this from first principles, i have intermediate
coding (VBA) skills in Access but absolutely no idea about coding in Outlook
(i have Office 2003).

Thanks very much
Emma

 

[Michael Bauer [MVP - Outlook]]

You can code your solution to send 20 e-mails with a single click. But you
still have to send 20 e-mails individually.

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool:
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Fri, 25 Apr 2008 03:31:01 -0700 schrieb Emma Hope:

 

[Emma Hope]

Thanks. Can you give me some advice on how to go about this.

 

[Michael Bauer [MVP - Outlook]]

I don't know Access VBA. But if you know how to use SendObject once, you
just need to loop trough the result of your query and call the object once
in every loop.

--
Best regards
Michael Bauer - MVP Outlook

: Outlook Categories? Category Manager Is Your Tool:
: <http://www.vboffice.net/product.html?pub=6&lang=en>


Am Mon, 28 Apr 2008 00:43:00 -0700 schrieb Emma Hope:

 

[Emma Hope]

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?

 

[Sue Mosher [MVP-Outlook]]

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.