By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,665 Members | 2,763 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,665 IT Pros & Developers. It's quick & easy.

Sending reports via OUTLOOK from ACCESS

P: 2
Hi,

I am new to posting about issues so I hope I do this correctly.

I have an Application in Access 2003 that generates reports in Excel 2003. These reports are run for individual representatives to show them their productivity for the day. I have a request to allow the manager to push a button that will generate each individuals report and send this report to the individual via Outlook 2003. Is this possible?

If it is, does anyone know of a site or documentation that I could use to determine how to do this?

Any help is appreciated.

Thanks
Jun 6 '07 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 218
Hi Francis,

You can use the DoCmd.SendObject command to send an Access report.

However I'm not so sure you can do this with an Excel workbook.

Looking further for you.

HTH
Jun 6 '07 #2

P: 2
That would be great. I will do some looking into that as well.

Thanks
Jun 6 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.