docmd.sendobject for email

[chuck]

Trying to use DoCmd.SendObject to email a report via Thunderbird. I have
tried every combination I can think of, but cannot get an entry in the
"To" field of the email - I've used a name in the address book (e.g.,
Joe), an email address (which is what I really need to work - e.g.,
(e-mail address removed)), both of them with and without enclosing double-quotes,
both of them with and without a trailing semi-colon (. Thunderbird
opens fine, but nothing in the To field.

Does anybody have an answer?

Thanks in advance for any help.

Chuck ([email protected])

 

[Allen Browne]

Tell us about the EmailAddress field.
If you open your table in design view, what type of field is this? Text?
Hyperlink? Text is better for email addresses.

 

[chuck]

Tell us about the EmailAddress field.
If you open your table in design view, what type of field is this? Text?
Hyperlink? Text is better for email addresses.

eMail fields are defined as text in the MDB. Additionally, I have coded
a constant string (e.g., "(e-mail address removed)" and/or "(e-mail address removed);") in the
sTo string variable for the DoCmd.SendObject
acSendReport,sRptName,,sTo,... VBA statement. Also tried acSendNoObject
variant, same result - nothing in the Recipient field for T-Bird.

Thanks for any help.
Chuck

 

[chuck]

eMail fields are defined as text in the MDB. Additionally, I have coded
a constant string (e.g., "(e-mail address removed)" and/or "(e-mail address removed);") in the
sTo string variable for the DoCmd.SendObject
acSendReport,sRptName,,sTo,... VBA statement. Also tried acSendNoObject
variant, same result - nothing in the Recipient field for T-Bird.

Thanks for any help.
Chuck

I foolishly neglected to mention that the code works perfectly with
Outlook Express - is there a Thunderbird forum anyone knows about where
I might also post this issue since it is pretty clearly a disconnect
between Access & Thunderbird?

Thanks.

Chuck

 

[Allen Browne]

Okay, so if the code works with Outlook, your code is fine.

SendObject is suppposed to work with any MAPI-compliant email program. I
can't comment on Thunderbird. Maybe someone else can.