Hello,

I did a mail merge but it only does one record at a time. Do you know of a
way to group? That way that one person is not getting 16 emails when they
could just get one?

"John K." wrote:

I'm not sure if this is a solution for you but you could perhaps do a mail
merge in Word with your query as the data source. (You can do a mass email
as a mail merge).
Place the fields where necessary (perhaps in a table) add any text you need
and complete the merge.
A cautionary note - when you complete the merge the emails are sent so make
sure things are as you want them before you merge.
Perhaps this might prove easier than wrting some code to accomplish your task.
Just a thought...

John

"mp80237" wrote:


I have a query in Microsoft Access 2007. I need to email each
employee every week their open orders that need to be updated. There
are about 120 employees I need to send these updates to every Friday.
Is there a way to create a query and just send each employee there
order that needs to be updated thru Outlook?

OrderId OpenDate DateNeededBy EmployeeName EmployeeEmail Status
1 02/9/2009 03/05/2009 Patrick Gidding Open
2 02/21/2009 03/25/2009 Greg Barlett Open
3 02/28/2009 03/17/2009 Karen Sapp Open
4 03/05/2009 03/20/2009 Rebecca McMillian Open
5 03/06/2009 03/16/2009 Patrick Gidding Open
6 03/06/2009 03/21/2009 Greg Barlett Open
7 03/07/2009 03/25/2009 Karen Sapp Open


**For example Patrick's email will state:

Please review the open tickets below and if there are any issues
please contact your manager.

OrderId OpenDate DateNeededBy EmployeeName EmployeeEmail Status
1 02/9/2009 03/05/2009 Patrick Gidding Open
5 03/06/2009 03/16/2009 Patrick Gidding Open

Thank you,

**Then another email will follow for Greg

Please review the open tickets below and if there are any issues
please contact your manager.

OrderId OpenDate DateNeededBy EmployeeName EmployeeEmail Status
2 02/21/2009 03/25/2009 Greg Barlett Open
6 03/06/2009 03/21/2009 Greg Barlett Open

Thank you,

---- Is there a way to do this without creating a macro for each
employee? Thank you so much for the help. I am sure I would need to
create a ODBC which is fine, I have one going from the read only SQL
server to Access. Any help is greatly appreciated.

M