Mail Merge with Excel

[Mandy]

I have a question that I'm really hoping the answer is
yes . First, I'm using Office 2000 Professional SR-
1. I have a large list of names and dates in Excel that
I want to merge with Word using mail merge. The names
are listed in Column A and the dates in Column B. I
would like to set up a document in word to merge with the
excel database but would like to use Column A as my merge
fields instead of retyping all 2000 names in Row 1 and
the dates in Row 2 in order to get it to merge properly.
Is there anyway to do this?

 

[Doug Robbins - Word MVP]

If what you are saying is that you want to have 2000 merge fields, you will
not be able to do that as Excel can only handle about 255 columns. You can
set up a comma separated value (CSV) text file with more fields and such a
file could be set up with a series of Edit>Copy, Edit>Paste
Special>Transpose, Save As CSV in Excel, then open the files in a text
editor and copy and paste from one to the other. BUT, is that really what
you are saying?

--
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

 

[Mandy]

Sorry about not being really clear. It's kind of hard to
explain what I'm trying to do.

I actually have the merge broken up on different
worksheets, with the max currently being about 200. I
want it to use the rows instead of columns as merge
fields headers. Instead of (with the names as the merge
field headers and the dates as the merged info)

John Smith Nancy Smith
01/15/2004 08/03/2004

I want it to use the following format:

John Smith 01/15/2004
Nancy Smith 08/03/2004

Thanks!

 

[Doug Robbins - Word MVP]

Hi Mandy,

Sorry, but I still do not understand what you have and what you want to do.
Can you give a more expanded sample of the way the data is arrange in the
spreadsheet and the way in which you want it in the Word document. Are
there only two rows of data? The first row containing names and the second
containing dates

Name John Smith Nancy Smith
Date 01/15/2004 08/03/2004

and what you want to have is

Name Date
John Smith 01/15/2004
Nancy Smith 08/03/2004

so that you could use a mergefield for the names and another for the dates.

If so, it's a simply Copy>Paste Special Transpose excercise in Excel.

If that's not it, please give more information.

--
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