Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Exporting Excel information to Word
Can anyone tell me if there is a way (and how to do it) to create a spread
sheet in Excel and then have the information in the cells imported into a Word template at different places? In other words, 'cell A1' in the spread sheet would go to one place in the Word template while 'cell B1' would go to another place in the same template. Thanks, gman |
#2
|
|||
|
|||
Word can read an Excel file. You'll need to set up your document in Word,
using the Mailmerge features. Then you simply need to setup your Excel sheet to lok like a database, with Column Headings that Word can read Probably best to seek help on Mailmerge in the Word NGs "gman" wrote: Can anyone tell me if there is a way (and how to do it) to create a spread sheet in Excel and then have the information in the cells imported into a Word template at different places? In other words, 'cell A1' in the spread sheet would go to one place in the Word template while 'cell B1' would go to another place in the same template. Thanks, gman |
#3
|
|||
|
|||
Thanks, Duke. The main thing is I need to have the data in one cell go to
one place in the template and the data in another cell go to another place in that same template. Can Excel export non-numerial data, i.e., can I enter text and have Excel export it? gman "Duke Carey" wrote: Word can read an Excel file. You'll need to set up your document in Word, using the Mailmerge features. Then you simply need to setup your Excel sheet to lok like a database, with Column Headings that Word can read Probably best to seek help on Mailmerge in the Word NGs "gman" wrote: Can anyone tell me if there is a way (and how to do it) to create a spread sheet in Excel and then have the information in the cells imported into a Word template at different places? In other words, 'cell A1' in the spread sheet would go to one place in the Word template while 'cell B1' would go to another place in the same template. Thanks, gman |
#4
|
|||
|
|||
It sure can -
take a look at this site from David McRitchie for some guidance http://www.mvps.org/dmcritchie/excel/mailmerg.htm "gman" wrote: Thanks, Duke. The main thing is I need to have the data in one cell go to one place in the template and the data in another cell go to another place in that same template. Can Excel export non-numerial data, i.e., can I enter text and have Excel export it? gman "Duke Carey" wrote: Word can read an Excel file. You'll need to set up your document in Word, using the Mailmerge features. Then you simply need to setup your Excel sheet to lok like a database, with Column Headings that Word can read Probably best to seek help on Mailmerge in the Word NGs "gman" wrote: Can anyone tell me if there is a way (and how to do it) to create a spread sheet in Excel and then have the information in the cells imported into a Word template at different places? In other words, 'cell A1' in the spread sheet would go to one place in the Word template while 'cell B1' would go to another place in the same template. Thanks, gman |
#5
|
|||
|
|||
Thanks, Duke. I will look it over.
gman "Duke Carey" wrote: It sure can - take a look at this site from David McRitchie for some guidance http://www.mvps.org/dmcritchie/excel/mailmerg.htm "gman" wrote: Thanks, Duke. The main thing is I need to have the data in one cell go to one place in the template and the data in another cell go to another place in that same template. Can Excel export non-numerial data, i.e., can I enter text and have Excel export it? gman "Duke Carey" wrote: Word can read an Excel file. You'll need to set up your document in Word, using the Mailmerge features. Then you simply need to setup your Excel sheet to lok like a database, with Column Headings that Word can read Probably best to seek help on Mailmerge in the Word NGs "gman" wrote: Can anyone tell me if there is a way (and how to do it) to create a spread sheet in Excel and then have the information in the cells imported into a Word template at different places? In other words, 'cell A1' in the spread sheet would go to one place in the Word template while 'cell B1' would go to another place in the same template. Thanks, gman |
#6
|
|||
|
|||
Well, Duke, I still cannot understand how Word will know what data from each
cell in the Excel sheet is to go where in the Word template. If I could understand this aspect alone it would be helpful. I cannot find a reference on the web to doing what I want. Man, this seems like something that would be easy and common place. I tried the Mail Merge thing and it just hung up the program. I have Office 2003 and got this Wizard thing when I selected Mail Merge. It was asking me to select stuff that I didn't understand; I really had no idea what I was doing. Any additional assistance would be appreciated. gman "Duke Carey" wrote: It sure can - take a look at this site from David McRitchie for some guidance http://www.mvps.org/dmcritchie/excel/mailmerg.htm "gman" wrote: Thanks, Duke. The main thing is I need to have the data in one cell go to one place in the template and the data in another cell go to another place in that same template. Can Excel export non-numerial data, i.e., can I enter text and have Excel export it? gman "Duke Carey" wrote: Word can read an Excel file. You'll need to set up your document in Word, using the Mailmerge features. Then you simply need to setup your Excel sheet to lok like a database, with Column Headings that Word can read Probably best to seek help on Mailmerge in the Word NGs "gman" wrote: Can anyone tell me if there is a way (and how to do it) to create a spread sheet in Excel and then have the information in the cells imported into a Word template at different places? In other words, 'cell A1' in the spread sheet would go to one place in the Word template while 'cell B1' would go to another place in the same template. Thanks, gman |
#7
|
|||
|
|||
Hey, Duke, I think I got it working!!! Still not exactly like I envision,
but it is something. If I could just find a way for Word to take the data from a specific row in Excel then it would be perfect. Right now, I have to use a different sheet or workbook each time I enter my data so that Word will only retrieve the data in Row B. gman "Duke Carey" wrote: It sure can - take a look at this site from David McRitchie for some guidance http://www.mvps.org/dmcritchie/excel/mailmerg.htm "gman" wrote: Thanks, Duke. The main thing is I need to have the data in one cell go to one place in the template and the data in another cell go to another place in that same template. Can Excel export non-numerial data, i.e., can I enter text and have Excel export it? gman "Duke Carey" wrote: Word can read an Excel file. You'll need to set up your document in Word, using the Mailmerge features. Then you simply need to setup your Excel sheet to lok like a database, with Column Headings that Word can read Probably best to seek help on Mailmerge in the Word NGs "gman" wrote: Can anyone tell me if there is a way (and how to do it) to create a spread sheet in Excel and then have the information in the cells imported into a Word template at different places? In other words, 'cell A1' in the spread sheet would go to one place in the Word template while 'cell B1' would go to another place in the same template. Thanks, gman |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Entering Excel information into MS Word | Excel Discussion (Misc queries) | |||
Column format when merging Excel data to Word labels | Excel Discussion (Misc queries) | |||
How do I export information from excel to word, ie database of na. | Excel Worksheet Functions | |||
Getting specific data from a word document into an excel sheet | Excel Worksheet Functions |