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