Copying data from excel into Word

Without seeing your updated code - especially for the font - it's impossible to know what the issue is. That said, the way you're adding content to the bookmarks means that you can't format the added content. For code to update a bookmarked range so that the update is accessible via the bookmark, try:

Please Login or Register  to view this content.

If you apply the desired font characteristics to the bookmarks before updating them, they should apply to whatever's inserted there. Otherwise, after updating the content, you could use code like:

Please Login or Register  to view this content.

Originally Posted by chrisellis250

My word template has text in the bookmarks, but when my code runs it doesn't keep the font the same as in the template.

When you're writing a string to a document, regardless of the source of that string, it takes on the formatting characteristics of the range it's written to. That said, you're also not creating a document from a Word template - you're merely opening an existing Word document.

Originally Posted by chrisellis250

Where in the code that you have posted do I put the code to set the font?

You might put it immediately after the corresponding Call statement, or anywhere between there and:
objDoc.Close True

Cross-posted at: https://stackoverflow.com/questions/...35704#56435704 without even the courtesy of acknowledging the help - and comprehensive answer - you've already received here.
Kindly read Excel Forum's Cross-Posting policy in rule 8: http://www.excelforum.com/forum-rule...rum-rules.html