Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
betzp betzp is offline
external usenet poster
 
Posts: 2
Default merging highlighted data from excel

I have formatted my excel spreadsheet with highlighting and text color.
However, when I mail merge data from my excel spreadsheet to make labels,
none of the formatting transfers- only the data. Is it possible to merge
the colors too?
  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Peter Jamieson Peter Jamieson is offline
external usenet poster
 
Posts: 4,582
Default merging highlighted data from excel

Mailmerge doesn't bring that kind of formatting information over from
any data source, but a "trick" you may be able to use to transfer some
of the formatting information is as follows:

Select the data on your Excel sheet and copy/paste it into a new Word
document.

Use that document as your mail merge data source.

Insert your mailmerge fields into the first label in the usual way.

Press Alt-F9 to show the underlying fields, e.g.

{ MERGEFIELD "myfield" }

and change the MERGEFIELD to REF so you have

{ REF "myfield" }

Propagate the fields in the usual way, then merge to a new document and
see what formatting is carried over. That seems to work with text colour
but I would not expect it to work with the ackground colour for the
entire cell

Peter Jamieson

http://tips.pjmsn.me.uk

betzp wrote:
I have formatted my excel spreadsheet with highlighting and text color.
However, when I mail merge data from my excel spreadsheet to make labels,
none of the formatting transfers- only the data. Is it possible to merge
the colors too?

  #3   Report Post  
Posted to microsoft.public.word.mailmerge.fields
betzp betzp is offline
external usenet poster
 
Posts: 2
Default merging highlighted data from excel

Thank you for that post, it works well! Unfortunately I am trying to
simplify the process, so if I cannot get the colors to merge, then I will
leave them out.


"Peter Jamieson" wrote:

Mailmerge doesn't bring that kind of formatting information over from
any data source, but a "trick" you may be able to use to transfer some
of the formatting information is as follows:

Select the data on your Excel sheet and copy/paste it into a new Word
document.

Use that document as your mail merge data source.

Insert your mailmerge fields into the first label in the usual way.

Press Alt-F9 to show the underlying fields, e.g.

{ MERGEFIELD "myfield" }

and change the MERGEFIELD to REF so you have

{ REF "myfield" }

Propagate the fields in the usual way, then merge to a new document and
see what formatting is carried over. That seems to work with text colour
but I would not expect it to work with the ackground colour for the
entire cell

Peter Jamieson

http://tips.pjmsn.me.uk

betzp wrote:
I have formatted my excel spreadsheet with highlighting and text color.
However, when I mail merge data from my excel spreadsheet to make labels,
none of the formatting transfers- only the data. Is it possible to merge
the colors too?


Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problems Merging Data from Excel to Word for MAC AndyC812 Mailmerge 5 June 12th 08 08:34 PM
Not merging all records from an Excel data source CMEC Mailmerge 3 December 8th 06 07:41 PM
Merging data from Excel to Word Paige Microsoft Word Help 2 March 22nd 06 06:59 AM
Merging Data from Excel into words Joie Mailmerge 1 November 17th 05 04:02 PM
How do you keep the currency format when merging data from Excel? MJW Mailmerge 2 February 22nd 05 07:33 PM


All times are GMT +1. The time now is 11:07 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"