Link to home
Start Free TrialLog in
Avatar of timohorn
timohornFlag for Netherlands

asked on

change fontsize of bookmark in vba exporting data from msaccess to word

I want toc hange the fontsize of bookmark in vba when exporting data from msacces to a word template.

i use

With .Bookmarks("Namen").Range
.Bookmarks("namen").Range.Font.Size = 12
        .Text = strText1
End With

but that does not do the trick
ASKER CERTIFIED SOLUTION
Avatar of wobbled
wobbled
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of timohorn

ASKER

Both answers worked, almost on the same time, so i split the points.<br /><br />I hope you're not offended.<br /><br />Thanxs<br /><br />Timo
Avatar of GrahamSkan
Note that it can be done in one step - there is no need to Select the Range.

ActiveDocument.Bookmarks("Namen").Range.Font.Size = 8