Email Format Font

  • Thread starter Thread starter WireGuy
  • Start date Start date
W

WireGuy

I use the Docmd.SendObject within MS Access to launch an Outlook message.
Can someone tell me if a can control the font color within the code?

I'd like most of the font to remain black, but change sections like
***REVISED***Engineering Change Request: to RED or some color. A portion of
the code is below for review.

Thanks,
Wireguy

DoCmd.SendObject , , , , , "***REVISED*** Engineering Change Request: " &
Forms![ECR Form-Find-Submit]![ECR #:] & " " & [Decision], _
"***REVISED*** ECR #: " & Forms![ECR Form-Find-Submit]![ECR #:] &
vbCrLf & vbCrLf _
& "Immediate Action Required?: " & [Decision1] & vbCrLf & vbCrLf _
& " Requested By: " & Forms![ECR
Form-Find-Submit]![Requested By:] & vbCrLf & vbCrLf _
& " Requested Change: " & Forms![ECR
Form-Find-Submit]![Requested Change:] & vbCrLf & vbCrLf _
& " Reason: " & Forms![ECR
Form-Find-Submit]![Reason:] & vbCrLf & vbCrLf _
& " Date: " & Date
 
WireGuy said:
I use the Docmd.SendObject within MS Access to launch an Outlook
message. Can someone tell me if a can control the font color within
the code?

I'd like most of the font to remain black, but change sections like
***REVISED***Engineering Change Request: to RED or some color. A
portion of the code is below for review.
Click to expand...

Not with SendObject no. You would have to automate an external messaging
library like Outlook or CDO.
 
WireGuy said:
I use the Docmd.SendObject within MS Access to launch an Outlook message.
Can someone tell me if a can control the font color within the code?

I'd like most of the font to remain black, but change sections like
***REVISED***Engineering Change Request: to RED or some color. A portion of
the code is below for review.
Click to expand...

To add to Rick's reply you'd also have to use HTML and set a flag
accordingly for your email software solution of choice.

You may be best off creating the email in Outlook/Outlook Express and
saving it as a text file. Then using the HTML code as a template to
create your email text.

Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
 
Back
Top