Automatic Email Report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CP - 19 Dec 2005 19:50 GMT

Hi: I curently have a report built off of a table in a database. Is it
possible to create a macro that would generate an email and attach the report
to it?

Reply to this Message

Bob Miller - 20 Dec 2005 17:56 GMT

Yes. Use the SendObject macro command and fill in all the To:, etc.
info. I recommend that you send it as a SnapShot as that maintains the
formatting.
CP Wrote:

> Hi: I curently have a report built off of a table in a database. Is it
> possible to create a macro that would generate an email and attach the
> report
> to it?

Signature

Bob Miller

Reply to this Message

Bob Miller - 20 Dec 2005 18:44 GMT

Yes. Use the SendObject macro command and fill in all the To:, etc.
info. I recommend that you send it as a SnapShot as that maintains the
formatting.
CP Wrote:

> Hi: I curently have a report built off of a table in a database. Is it
> possible to create a macro that would generate an email and attach the
> report
> to it?

Signature

Bob Miller

Reply to this Message

David Lloyd - 20 Dec 2005 22:31 GMT

CP:

Look at using the SendObject action. You can find a reference here:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/ac
actSendObject.asp

Signature

David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.

Hi: I curently have a report built off of a table in a database. Is it
possible to create a macro that would generate an email and attach the
report
to it?

Reply to this Message