If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Mail Merge with Excel
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? |
#2
|
|||
|
|||
Mail Merge with Excel
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 EditCopy, EditPaste SpecialTranspose, 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" wrote in message ... 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? |
#3
|
|||
|
|||
Mail Merge with Excel
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! -----Original Message----- 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 EditCopy, EditPaste SpecialTranspose, 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" wrote in message ... 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? . |
#4
|
|||
|
|||
Mail Merge with Excel
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 CopyPaste 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 "Mandy" wrote in message ... 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! -----Original Message----- 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 EditCopy, EditPaste SpecialTranspose, 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" wrote in message ... 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? . |
Thread Tools | |
Display Modes | |
|
|