CODEWITHSUNDEEP
vbams-accessms-word
Ben
Ben

Reputation: 21625

How do I change the font and size of a hyperlink inserted into ms word with vba

I have a subroutine in ms access that runs this line of code

wrdDoc.Hyperlinks.Add Anchor:=wrdDoc.Bookmarks("LCEmail").Range, Address:="[email protected]"

How do I change the font of the inserted email to Microsoft sans serif and the font size to 10?

Upvotes: 0

Views: 3204

Answers (1)

Alex K.
Alex K.

Reputation: 175816

You can;

With wrdDoc.Hyperlinks.Add(Anchor:=wrdDoc.Bookmarks("LCEmail").Range, Address:="[email protected]")
    .Range.Font.Name = "Microsoft sans serif"
    .Range.Font.Size = 10
End With

Upvotes: 4

Related Questions