Including several records from a database (Excel) into a single word document

O

Ojfm

Dear All,

I have an Excel sheet with a list of names and titles. I would like
to create with Word a presentation schedule, by typing a date and time
and then including the name of the presenter and the title of her/his
presentation by refering the Excel sheet.

Mail merge can only include one Excel record per document, what I need
is to select different records and place them accordingly in the Word
document.

Thanks a lot,

Olivier
 
A

arcarius

Ojfm said:
Dear All,

I have an Excel sheet with a list of names and titles. I would like
to create with Word a presentation schedule, by typing a date and time
and then including the name of the presenter and the title of her/his
presentation by refering the Excel sheet.

Mail merge can only include one Excel record per document, what I need
is to select different records and place them accordingly in the Word
document.

Thanks a lot,

Olivier
Oliver,

One of the many ways to accomplish this task is to save your Excel
document as a Text base document. After you do that, you can import the
whole thing into Word. After that everything will be in Word as text and
you can cut and paste as much as you want.

Another way is to place the Excel spreadsheet as an object in your
document. Before you do this, just sort your spreadsheet how you want
it, save it as spreadsheet 1 or something like that so that you don't
overwrite the original. Then place the newly created Excel spreadsheet
as an object. When you do that, it will treat it,when printed like a
table. This method, you let Excel do all the work of sorting your list.
The real work that you have to do is to import it.

Arcarius 76
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top