Get data from 1st row (Headers)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Grimmie - 13 May 2004 10:17 GMT

I have the following dataset separated by comma:
Firstname, Lastname, Street
Bill, harly, dasdasdas

In Word2000 I want the following
Firstname: <<Firstname>>
Lastname: <<lastname>>
Street: <<Street>>

But I what I really want is the header to come from the dataset too (1st
row)
<<Firstname (from row 1- header)>>: <<Firstname>>
<<Lastname (from row 1- header)>>: <<Lastname>>
<<Street (from row 1- header)>>: <<Street>>

Is this possible ?

Reply to this Message

Doug Robbins - Word MVP - 14 May 2004 06:52 GMT

That's not possible and I really wonder why you would want to do it.

Signature

Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP

> I have the following dataset separated by comma:
> Firstname, Lastname, Street
[quoted text clipped - 12 lines]
>
> Is this possible ?

Reply to this Message

Cindy M -WordMVP- - 14 May 2004 10:01 GMT

Hi Grimmie,

Are we talking about a catalog type mail merge? And you mean the document
headers (as in headers/footers)? Sorta like a telephone book?

Yes, this is possible. Sometimes a bit tricky to implement :-) But
possible.

You need to create a new character style in the main merge document;
doesn't matter how it's formatted, it's the name we need. If the data you
want is NOT all in the same cell, then you need a separate style for each
cell.

Select the text in the cell (note: NOT the whole cell, just the text in
the cell) and apply the appropriate style.

Now go to the document header/footer and insert a STYLEREF field. Specify
the character style name. Try the merge.

If the merge is dropping the merge field information (it can happen that
the merge field resets), then go back to the main merge document and add
the \* CharFormat switch to the end of the mergefield(s) in question. (If
there's a \* MergeFormat switch present, remove it) Try again.

> I have the following dataset separated by comma:
> Firstname, Lastname, Street
[quoted text clipped - 10 lines]
> <<Lastname (from row 1- header)>>: <<Lastname>>
> <<Street (from row 1- header)>>: <<Street>>

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Sep 30 2003)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

Reply to this Message