M
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 pgidding@company.com Open
2 02/21/2009 03/25/2009 Greg Barlett gbarlett@company.com Open
3 02/28/2009 03/17/2009 Karen Sapp ksapp@company.com Open
4 03/05/2009 03/20/2009 Rebecca McMillian rmcmillian@company.com Open
5 03/06/2009 03/16/2009 Patrick Gidding pgidding@company.com Open
6 03/06/2009 03/21/2009 Greg Barlett gbarlett@company.com Open
7 03/07/2009 03/25/2009 Karen Sapp ksapp@company.com 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 pgidding@company.com Open
5 03/06/2009 03/16/2009 Patrick Gidding pgidding@company.com 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 gbarlett@company.com Open
6 03/06/2009 03/21/2009 Greg Barlett gbarlett@company.com 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
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 pgidding@company.com Open
2 02/21/2009 03/25/2009 Greg Barlett gbarlett@company.com Open
3 02/28/2009 03/17/2009 Karen Sapp ksapp@company.com Open
4 03/05/2009 03/20/2009 Rebecca McMillian rmcmillian@company.com Open
5 03/06/2009 03/16/2009 Patrick Gidding pgidding@company.com Open
6 03/06/2009 03/21/2009 Greg Barlett gbarlett@company.com Open
7 03/07/2009 03/25/2009 Karen Sapp ksapp@company.com 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 pgidding@company.com Open
5 03/06/2009 03/16/2009 Patrick Gidding pgidding@company.com 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 gbarlett@company.com Open
6 03/06/2009 03/21/2009 Greg Barlett gbarlett@company.com 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