vba courses london - When importing data from excel to vba mail merge (excel to word)

The UK's most regular instructor-led training courses.
Training information: vba courses london · Excel london

Resolved · Low Priority · Version Standard

When importing data from excel to vba mail merge (excel to word)

Chris has attended:
Access Introduction course
Excel VBA course

by - delegate Chris [2 posts] (2007 May 17 Thu, 16:05) Reply

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

by - trainer Andrew gold contributer [398 posts] (2007 Jun 12 Tue, 10:14) Reply

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

· What Is Microsoft Excel VBA and How Can It Help You Work Smarter?
· Company Roles in Visual Basic Training

Vba tip:

Empty The Clipboard with CutCopyMode

After 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:

ActiveSheet.Paste
Application.CutCopyMode = False

View all VBA hints and tips