mail merge issue

G

Guest

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
 
G

Guest

thanks a million!

SVC said:
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.
Click to expand...
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem with mail merge in Word/Excel 2002 1
Multiple Line Mail Merge 1
Mail Merge in Word using Excel Spreadsheet 1
Label - Mail Merge - Word 2007 2
Mailing address block: sorting 1 row to columns 1
Mail Merge & Excel 2
Mail Merge Update Labels Not Working 4
Mail Merge Headings 2

Top