Formatting letter in Word created from Excel VBA?

Hello all,

I'm new to manipulating Word from Excel. I recently have need for it and have made an attempt. Below is what I have so far. Please run it and refer to the Word doc produced when reading the next few questions.

How do I:

• ...make the underline in the subject line across all the words (rather than word by word)?
• ...turn off the underline format afterwards?
• ...create a bullet point list (at "something something")?

Please Login or Register  to view this content.

Brilliant! That fixed it, Thanks!

Do you know of any good web page that covers this topic (manipulating Word documents from Excel)?

Round 2 of Word formatting problems!

Does anyone know how to:

• ...add text as hyperlink? (Say in the email address at the bottom of the address box)
• ...change the text font colour?
• ...add highlighting to text?

UPDATE: I think I have solved the text colour

Please Login or Register  to view this content.

Can anybody assist with either the hyperlink or highlighting?

Originally Posted by AlphaFrog

Please Login or Register  to view this content.

Thanks again AlphaFrog.

Two questions:

1. How do I fully implement the hyperlink? Hover over the hyperlink and use 'Ctrl + Click' to see what I mean. The address isn't valid - it tries to open a file rather than the dummy email address.
2. Would it be possible to have the font colour and/or highlighting applied conditionally? For e.g. how would I change the font to red on inpCltNmePrincipalEmail only if inpCltNmePrincipalEmail = "Enter Email Address"?

Originally Posted by AlphaFrog

1) I got this syntax from recording my steps in a macro in MS-Word.
.Hyperlinks.Add .Range, "MailTo:" & inpCltNmePrincipalEmail, , , inpCltNmePrincipalEmail

2) I'm not sure what you're asking but use an If statment then set the font color red or not.

Thanks. Both remaining problems solved.