Re: Access Email Automation



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:

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
.

Relevant Pages