Outlook - HELP!!!

Asked By Angel Martinez on 28-Jul-12 09:05 AM
OK I am workin in Excel 2007 and I have a macro that will create an email f=
or you with all the data I need. I am also adding text to the body of this =
email. 2 lines  of text that I am adding I want to change the Font color an=
d also Highlight it yellow. I can get it to change the Font color but I can=
not get it to highlight the text. I have tried the following lines of code =
and nothin

objSel.BackgroundPatternColor =3D wdColorYellow
objSel.Font.ColorIndex =3D wdColorYellow
objSel.Font.Highlight =3D 65535
objsel.Interior.Color =3D wdColorYellow

Is there something I am missing. Or a different line I can use to Highlight=
the text I want? Please help!