I'm trying to send a report via email using SendObject (VBA)... but the report is always sent as an attachment. I need the report content to be inserted into the body text of the email.
Background: I'm transfering information from Access into Remedy using Remedy's email import tool (armaild). I am accepting input from a variety of sources, and need to support a "standard" mode of input that can be easily adapted into a variety of programs. The Remedy email import tool scans email as it arrives, and it needs to be in plain text. When Access send the email as an attachment, it is getting encoded as it transits our mail server. It works fine when the report content appears as body text... (pasted in by the user, not automated via VBA) but how can I force the report content into the body text via VBA?
Background: I'm transfering information from Access into Remedy using Remedy's email import tool (armaild). I am accepting input from a variety of sources, and need to support a "standard" mode of input that can be easily adapted into a variety of programs. The Remedy email import tool scans email as it arrives, and it needs to be in plain text. When Access send the email as an attachment, it is getting encoded as it transits our mail server. It works fine when the report content appears as body text... (pasted in by the user, not automated via VBA) but how can I force the report content into the body text via VBA?
