Merging a document automatically based on excel or csv data ?

[Staunts]

Hi there,

I have a spreadsheet (or csv) file that I want to be able to have
merged into a word doc (i.e. Name , Address etc etc)

Is there some way I can "force" word to use this data when opened,
rather than have to use the merge button etc.

I don't want any user interraction and basically just want to print the
"populated" word document.
access).

any help would be greatly appreciated.

cheers,

Adam

 

[Doug Robbins - Word MVP]

If you save the document with the data source attached and the merge fields
in place, the next time that you open it, it should still be attached, ready
to go.

--
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

 

[Staunts]

Hi Doug,

with this approach does it still require me to hit the merge button to
merge the data ? I will be printing off over 40 documents at once, so I
was hoping to not have to do that.

cheers,

Adam

 

[Doug Robbins - Word MVP]

If you mean that you have 40 records in the data source, it is only
necessary to execute the merge once, directly to the printer.

How are you doing it now?

--
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

 

[Staunts]

Hi Doug,

I am hoping to print out 40 word documents, with details from a 1 line
csv file.

The csv will contain, for example, simply name and address details etc
that will form the header for each document.

The documents will all have the name and address info at the top of
each page(for 40 different word documents).

This is part of a new system

am I making sense here ?

cheers

 

[Doug Robbins - Word MVP]

I would combine all of the documents into one.

See the "Preserving Section Formatting when Pasting between Documents" item
in the article at:

http://www.word.mvps.org/FAQs/Formatting/WorkWithSections.htm


--
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