Extracting specific Excel data into word

[Nicole Knapp]

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.

 

[Suzanne S. Barnhill]

If I'm understanding you correctly, you should be able to use the Excel
sheet as a mail merge data source.

 

[Nicole Knapp]

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]

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.