Send multiple emails based on employee using Microsoft Access 2007 and Outlookþ

[mp80237]

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 (e-mail address removed) Open
2 02/21/2009 03/25/2009 Greg Barlett (e-mail address removed) Open
3 02/28/2009 03/17/2009 Karen Sapp (e-mail address removed) Open
4 03/05/2009 03/20/2009 Rebecca McMillian (e-mail address removed) Open
5 03/06/2009 03/16/2009 Patrick Gidding (e-mail address removed) Open
6 03/06/2009 03/21/2009 Greg Barlett (e-mail address removed) Open
7 03/07/2009 03/25/2009 Karen Sapp (e-mail address removed) 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 (e-mail address removed) Open
5 03/06/2009 03/16/2009 Patrick Gidding (e-mail address removed) 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 (e-mail address removed) Open
6 03/06/2009 03/21/2009 Greg Barlett (e-mail address removed) 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

 

[John K.]

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]

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
















- Show quoted text -

Any idea how I would do that?

Thanks, M

 

[John K.]

For Word 2003 see this link:

http://office.microsoft.com/en-us/help/HA010349201033.aspx
http://office.microsoft.com/en-us/word/HP051872571033.aspx

For Word 2007 see these
http://www.baylor.edu/content/services/document.php/48542.pdf

http://support.microsoft.com/kb/294694

Hope these help

 

[mp80237]

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?