Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Extracting specific Excel data into word
I have a document that is a certificate. I have a spreadsheet that is an
attendance sheet for a training session. The Word document is a mail merge which pulls data for "credit hours", "course", "Name", "Location" and "date". This is pulled via SQL from a table created separately based on the spreadsheet. My spreadsheet has header information in the first 11 rows that basically stays the same between each - the "hours", "Course", "Location" and date are all in the same cells each session. The names are located in a specific column below the header I would like to eliminate moving the data out of the spreadsheet to the table and have Word and Excel interact directly to create certificates for each attendee. Thanks. |
#2
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Extracting specific Excel data into word
If I'm understanding you correctly, you should be able to use the Excel
sheet as a mail merge data source. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Nicole Knapp" wrote in message ... I have a document that is a certificate. I have a spreadsheet that is an attendance sheet for a training session. The Word document is a mail merge which pulls data for "credit hours", "course", "Name", "Location" and "date". This is pulled via SQL from a table created separately based on the spreadsheet. My spreadsheet has header information in the first 11 rows that basically stays the same between each - the "hours", "Course", "Location" and date are all in the same cells each session. The names are located in a specific column below the header I would like to eliminate moving the data out of the spreadsheet to the table and have Word and Excel interact directly to create certificates for each attendee. Thanks. |
#3
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Extracting specific Excel data into word
That's what I thought, but it wants to use the Excel sheet as a table & Mail
Merge won't correctly pull it in. I need to use information from: 4 cells (A5, E5, A7, E7) This information is static for each certficate. 1 column (B13:B32) - This information is the name that changes for each certificate. Thanks, Nicole "Suzanne S. Barnhill" wrote: If I'm understanding you correctly, you should be able to use the Excel sheet as a mail merge data source. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. |
#4
Posted to microsoft.public.word.docmanagement
|
|||
|
|||
Extracting specific Excel data into word
If you name the range that contains the names, then you should be able to
select the range as the data source (you'll need a heading row for convenience, so there'll be a form field name). You can then paste-link the data from the other cells, I think. In order to be able to name a range, you may have to connect to the Excel sheet via DDE rather than the default OLEDB; in order to be given that choice, you need to check the box for "Confirm conversion at Open" on the General tab of Tools | Options in Word. These are really guesses, though, based on ways I've used Excel sheets. For more authoritative answers, you should post your question in the microsoft.public.word.mailmerge.fields newsgroup on this same news server. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Nicole Knapp" wrote in message ... That's what I thought, but it wants to use the Excel sheet as a table & Merge won't correctly pull it in. I need to use information from: 4 cells (A5, E5, A7, E7) This information is static for each certficate. 1 column (B13:B32) - This information is the name that changes for each certificate. Thanks, Nicole "Suzanne S. Barnhill" wrote: If I'm understanding you correctly, you should be able to use the Excel sheet as a mail merge data source. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Extracting Headers and Body text from MS Word to use in Excel | Microsoft Word Help | |||
Extracting Data in Word 2003 | Microsoft Word Help | |||
Merge Excel data into specific form areas in a Word Doc | Microsoft Word Help | |||
Extracting data from a file | Microsoft Word Help | |||
Extracting data from a file | Formatting Long Documents |