i have a database in excel in which the data is organized in columns instead
of rows, i.e. name is the first row going across, address1 is the 2nd row,
city 3d row,

anyone know how to organize this data to do a mail merge? word will only
recognize data with the headers going across the top row, not the first column

thansk

thanks a million!

"SVC" wrote:

In Excel, copy the range of data, then on a new tab use Edit Paste Special,
select Transpose--this will turn our data so that the rows will become
columns. Use the new tab as your database for the merge. You will want to
add field names in Row 1 for each column.

"drewstein" wrote:

i have a database in excel in which the data is organized in columns instead
of rows, i.e. name is the first row going across, address1 is the 2nd row,
city 3d row,

anyone know how to organize this data to do a mail merge? word will only
recognize data with the headers going across the top row, not the first column

thansk

In Excel, copy the range of data, then on a new tab use Edit Paste Special,
select Transpose--this will turn our data so that the rows will become
columns. Use the new tab as your database for the merge. You will want to
add field names in Row 1 for each column.

"drewstein" wrote:

i have a database in excel in which the data is organized in columns instead
of rows, i.e. name is the first row going across, address1 is the 2nd row,
city 3d row,

anyone know how to organize this data to do a mail merge? word will only
recognize data with the headers going across the top row, not the first column

thansk