Import data from excell into a standard word report

[Spike09]

Trying to figure the best way to import data from certain Cells from an excel
workbook (multiple worksheets) into a word document.

The excel workbook is a template that requires certain cells to be filled in
for example name, address, property type and other information gathered to
complete the template.

The word document is a standard report that requires the information from
the excel workbook to be imported into certain sections of the report - if
this can be done!?

Cheers

 

[Doug Robbins - Word MVP]

It can certainly be done. Just depends upon how you want to do it and how
automated you want the process to be.

The most basic way would be to Copy from Excel and then Paste into Word as a
link.

Then, there's mail merge, that may or may not be suitable

Or there are various ways that the process could be automated using VBA.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

 

[Spike09]

It can certainly be done. Just depends upon how you want to do it and how
automated you want the process to be.

The most basic way would be to Copy from Excel and then Paste into Word as a
link.

Then, there's mail merge, that may or may not be suitable

Or there are various ways that the process could be automated using VBA.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

Thanks Doug,
I was hoping I was on the right track with mail merge. Thanks for the
confirmation. I will investiagate further.
Thanks again.
Brett