Email individualised Word attachments to list of recipients

[mcjj]

I have an Access 2003 db containing employee details including name and email address. Based on a query, I need to send an email (Outlook 2003) with a Word attachment (a certificate) to certain employees. I need to include on the certificate the employee's name and other information from the query. Based on examples found on forums I have been able to send emails with a Word attachment but I have not been able to include the recipent's name in it. I have tried using a Word mailmerge but have not been successful. I don't have much VB experience so any help with this problem would be much appreciated.

[crowegreg]

Why don't you try creating a report within Access, with fields based off your query results, then output the report to a word document, and use that as your attachment file.