Run report and attach to Outlook Message

[Matt]

Hi All,

I would like to run a report from a form, and open an outlook email
with this report as an email attachment. The user can then decide who
she/he wants to send it to. I already run this report from the form
using:

DoCmd.OpenReport "Productivity and Efficiency", acViewPreview


Thanks in advance!

 

[strive4peace]

Hi Matt,

you can use SendObject

SendObject
[objecttype] --> acSendReport
[, objectname] --> "Productivity and Efficiency"
[, outputformat] --> acFormatSNP (for instance)
[, to] --> email address(es)
[, cc]
[, bcc]
[, subject] --> subject
[, messagetext] --> body
[, editmessage] --> True if you want to see message and change, False to
just send
[, templatefile]

this is a generic way to send email -- so if Outlook is your email
handler, that is what will be used.

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[Matt]

Hi Matt,

you can use SendObject

SendObject
[objecttype] --> acSendReport
[, objectname] --> "Productivity and Efficiency"
[, outputformat] --> acFormatSNP (for instance)
[, to] --> email address(es)
[, cc]
[, bcc]
[, subject] --> subject
[, messagetext] --> body
[, editmessage] --> True if you want to see message and change, False to
just send
[, templatefile]

this is a generic way to send email -- so if Outlook is your email
handler, that is what will be used.

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

Hi All,

I would like to run a report from a form, and open an outlook email
with this report as an email attachment. The user can then decide who
she/he wants to send it to. I already run this report from the form
using:

DoCmd.OpenReport "Productivity and Efficiency", acViewPreview

Thanks in advance!- Hide quoted text -

- Show quoted text -

Thanks Crystal!!!

 

[strive4peace]

you're welcome, Matt happy to help

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

Hi Matt,

you can use SendObject

SendObject
[objecttype] --> acSendReport
[, objectname] --> "Productivity and Efficiency"
[, outputformat] --> acFormatSNP (for instance)
[, to] --> email address(es)
[, cc]
[, bcc]
[, subject] --> subject
[, messagetext] --> body
[, editmessage] --> True if you want to see message and change, False to
just send
[, templatefile]

this is a generic way to send email -- so if Outlook is your email
handler, that is what will be used.

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

Hi All,
I would like to run a report from a form, and open an outlook email
with this report as an email attachment. The user can then decide who
she/he wants to send it to. I already run this report from the form
using:
DoCmd.OpenReport "Productivity and Efficiency", acViewPreview
Thanks in advance!- Hide quoted text -

- Show quoted text -

Thanks Crystal!!!