Change color for docmd subject line

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jae - 11 Jul 2007 15:44 GMT

Hi!

I have a code that goes something like this

Dim strSub1, strSub2 As String
strSub1 = "Hello "
strSub2 = "world"
strSub1 = strSub1 & strSub2
DoCmd.SendObject , , , "asdf@asd.com", , , strSub1

I want the second part of the subject (strSub2) to be red (or some other
color that's different from strSub1) when this code is triggered. Does anyone
how to do this? Any help would be appreciated. Thank you.

Reply to this Message

Maurice - 11 Jul 2007 20:16 GMT

Jae,

Why would you want that? In VBA there are a couple of colors and they all
have a pretty specific purpose.

Red means somethings not right with the code you have written (a great
indicator)
Yellow shows the step process when stepping through code
Green means the code is commented being information provided by the
developer or some specific line of code being disabled
Black being the regular color for the code.

My advice would be don't use colors in your code. It's not meant to be a
wordprocessor with formatting possibilities.

And while activating code your users won't see this because that's not the
point of coding something. If it's just for personal use and you want to see
the designated values just hoover your mouse over the variables being set and
you will see a tooltip appear.

hth

Signature

Maurice Ausum

> Hi!
>
[quoted text clipped - 9 lines]
> color that's different from strSub1) when this code is triggered. Does anyone
> how to do this? Any help would be appreciated. Thank you.

Reply to this Message

Jae - 11 Jul 2007 21:34 GMT

Dear Maurice,

Thank you for your answer. I don't think I was very clear on my question. I
don't neet to have it red in the VB editor. I need to have it red in the
e-mail content. I know if I want to mak it all upper case, I would do
something like this: Ucase(strBody2). I want to make it different color
instead of making a different case. I'm hoping it would be something simple
like Font(strBody2, vbRed). Thank you.

> Jae,
>
[quoted text clipped - 31 lines]
> > color that's different from strSub1) when this code is triggered. Does anyone
> > how to do this? Any help would be appreciated. Thank you.

Reply to this Message

Maurice - 12 Jul 2007 13:52 GMT

Jae,

Sorry for the misunderstanding. I understand now what you mean. I've tried
formatting the body while sending a mail from Access. Didn't get it to work.
My guess is that you have to program that from within outlook.

Signature

Maurice Ausum

> Dear Maurice,
>
[quoted text clipped - 40 lines]
> > > color that's different from strSub1) when this code is triggered. Does anyone
> > > how to do this? Any help would be appreciated. Thank you.

Reply to this Message

Jae - 12 Jul 2007 14:24 GMT

Dear Maurice,

Thank you for trying. Have a good day. =)

Best regards,

Jae

> Jae,
>
[quoted text clipped - 46 lines]
> > > > color that's different from strSub1) when this code is triggered. Does anyone
> > > > how to do this? Any help would be appreciated. Thank you.

Reply to this Message