98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft VBA Training and help » vba courses london - When importing data from excel to vba mail merge (excel to word)
vba courses london - When importing data from excel to vba mail merge (excel to word)
Resolved · Low Priority · Version Standard
Thu 17 May 2007, 16:05Delegate Chris said...
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.
Tue 12 Jun 2007, 10:14Trainer Andrew said...
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
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
VBA tip:Empty The Clipboard with CutCopyModeAfter each Copy/Paste operation in VBA, you should use the following line of code to empty the clipboard. This ensures that the computer memory doesn't overload: |
