R
Robert Gillard
(using Access 2003)
I have a form which after completion is emailed to others in the company.
This works fine. I have now been asked to include a hyperlink in the email
(different link depending on which part of the co is receiving it.)
I have included the hyperlink in the table (set to show a "Short Name"
rather than the full http address), which then materialises on the form and
is then copied to the email.
HOWEVER, when it arrives in the email the link shows both the short cut name
"Find Report Here" as well as the full http address (which I did not want),
but the email is in "plain text" so the hyperlink does not work.
I am using the "SendObject" which previously completed the email ok. Reading
the notes for this action it seems I can send it as an HTML or Rich Text
format. I am not sure how to activate it, I am using it as below but it
still arrives in the email as "Plain Text". Could anybody offer any
assistance please.
DoCmd.SendObject , "", acFormatHTML, Forms![BAU
Reports]![subreports]![Recipiant] etc
Bob
I have a form which after completion is emailed to others in the company.
This works fine. I have now been asked to include a hyperlink in the email
(different link depending on which part of the co is receiving it.)
I have included the hyperlink in the table (set to show a "Short Name"
rather than the full http address), which then materialises on the form and
is then copied to the email.
HOWEVER, when it arrives in the email the link shows both the short cut name
"Find Report Here" as well as the full http address (which I did not want),
but the email is in "plain text" so the hyperlink does not work.
I am using the "SendObject" which previously completed the email ok. Reading
the notes for this action it seems I can send it as an HTML or Rich Text
format. I am not sure how to activate it, I am using it as below but it
still arrives in the email as "Plain Text". Could anybody offer any
assistance please.
DoCmd.SendObject , "", acFormatHTML, Forms![BAU
Reports]![subreports]![Recipiant] etc
Bob