Chris has attended:
Access Introduction course
Excel VBA Intro Intermediate course
When importing data from excel to vba mail merge (excel to word)
when importing data from excel to word on mail merge the data looses some data looses its font style how do i change this? i.e. in the pre mail merge screen then i press alt F9 and can enter/##'##.00 is there a code for entering the font.
RE: when importing data from excel to vba mail merge (excel to w
Hi Chris
You may find adding the \* MERGEFORMAT switch to your merge field helps preserve the formatting.
You can find out more information about this switch on the Microsoft site at:
http://office.microsoft.com/en-us/word/HP051893941033.aspx?pid=CH061047111033
Hope this helps - do let us know if you have any other questions.
Kind regards,
Andrew