Access Crash on "EMailDatabaseObject" on Terminal Server/RDP

[Barlow]

OK, thanks for looking out for such. The VBA definitely seems to be working, so thanks again for the suggestion of converting the Macro to VBA.
Many thanks


Brian

[ItsMe]

When you get a chance try "acFormatHTML" Post back if it works or not.

Post #10 in this link has an example of the code I was referring to. This code will allow for formatting in HTML.
https://www.accessforums.net/access/...mdb-39036.html

[Barlow]

Unfortunately, changing the PDF Format to HTML did not work--it just produced a Compile Error.
You wouldn't think it would be so hard, would you?!

[ItsMe]

It seems DoCmd.SendObject acReport... does not support acFormatHTML

I think transferspreadsheet and a few others support acFormatHTML

I know I send reports in the body of emails via VBA. I use code similar to what I provided in the link above. I think I export the report in MS Word to a temp folder and then place it in the body as .rtf

[Barlow]

Hi all
Just to let you know that using acFormatTXT worked for me. For whatever reasons, Access didn't like the PDF or HTML format, but TXT has stopped it from crashing.
Thank you all again for all your help. It was very much appreciated.
Have a good day.
Brian

[ItsMe]

Thanks for posting your results!