I have two questions.
First - In Oulook I have 4 accounts. I want the SendObject email to be sent from an account other than the default. I don't see how to do this in the SendObject method.
Second - To be sent is a formated summary of a client's status for them to review and return with corrections, if any. The summary is an Access Report that is snail-mailed and is fairly lengthy. Since it has to be editable by the client for return, which would be better a) to create the report in rtf to use as the acSendReport, "reportname", acFormatRTF or b) to put the info (or the report itself) in the Message field, or c) to send the report as an attachment? I'd really like to use the report as it if possible.
Limitations of the SendObject Command
While the SendObject command is useful for sending an object or short message, it has several significant limitations:
Messages must be 255 characters or less
Messages are plain text and cannot be HTML format
Cannot attach multiple files (limited to one attachment)
Cannot attach a file on disk
Cannot filter the data source or report to just the data you need to send Cannot specify the FROM address
Cannot specify settings such as priority, sensitivity, and read receipt
MAPI security dialog box prompts the user for each email to verify it is okay to send
Doesn't always work with email programs if it's not Outlook, Outlook Express, or Exchange
Report in rtf would probably be your best bet with the limitations.
I have seen a couple of posts on here listing code including
Set objOutlook = CreateObject("Outlook.Application")
Set objOutlookMsg = objOutlook.CreateItem(olMailItem)
Set objOutlookRecip = .Recipients.Add("STAFFNAME")
objOutlookRecip.Type = olTo
which may be the answer your looking for (I unfortunately didnt have much success with it though)