Link to home
Create AccountLog in
Avatar of Mel
MelFlag for United States of America

asked on

Microsoft Access Report or form (chart) export to body of email?

I created chart in Microsoft access and need to export it into the body of an email.  I have in in a form and in a report. Will one of them work and how to do so??

Thanks in advance for guidance!


SOLUTION
Avatar of Maria Barnes
Maria Barnes
Flag of United States of America image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
SOLUTION
Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
SOLUTION
Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
Avatar of Mel

ASKER

Hi Maria - 

I am not having success with this.

I put this code:

DoCmd.SendObject acSendReport, , acFormatHTML, ,"michellelaurin@comcast.net", , "Test", "Testing object in body, False

The article you send me said this "If you want to include the active object in the mail message, specify the object's type with the ObjectType argument and leave this argument blank."

It sent the email but did not put the object into the email body.

Do you have code that will do this?

Thanks,

Michelle


SOLUTION
Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
ASKER CERTIFIED SOLUTION
Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.