[jomuir]

You just copy and paste the data, not the field hearders........

Then in your word document on your mail merger tool bar the second item is
open data source - pick this new workbook that you have created.

You template has not changed, and should be looking for the same fields, so
here all you have done is point to the same data in the same format, just in
a different order.

(If I have understood what you are looking for)

"Jo8379" wrote:

When I do this, it does not recognize my merge fields any longer. Can't find
"First" for example. Wants me to replace them but they are not listed.

"jomuir" wrote:

In Excel, highlight your data, copy it€¦€¦then open a new wookbook and €˜paste
special tick the option to €˜Transpose that okay it.

Save this new workbook as what ever you want (you can delete it after the
mail merge) and then use this data for you mail merge.


"Jo8379" wrote:

I figured it out - but one more question...My list is in alpha order and I
want the lables to print down the first column then down the second column
rather that across the row. Is there a way to make that happen?

"Jo8379" wrote:

I'm using an excel data list and want to merge it to Word labels. It looks
good at first glance, but then I noticed that one label is missing at the end
of each page. They are included on the data list - just skipped in the merge.
I think there is a code or a switch I'm missing on my form document at the
end of the page...Help