Merging to one document

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sarah - 21 Apr 2005 17:39 GMT

I'm using a spreadsheet as my data source and I want put information from
each row onto one merged document. Can anyone tell me how to do this?

Reply to this Message

Sarah - 21 Apr 2005 17:41 GMT

Sorry guys, I just found that Word cannot do this.
Thanks!!

> I'm using a spreadsheet as my data source and I want put information from
> each row onto one merged document. Can anyone tell me how to do this?

Reply to this Message

Peter Jamieson - 22 Apr 2005 12:35 GMT

It can be done, but you have to use a macro. If you go to google groups and
search this newsgroup for, e.g. "splitter", you will probably find various
useful bits of code.

Peter Jamieson

> Sorry guys, I just found that Word cannot do this.
> Thanks!!
>
>> I'm using a spreadsheet as my data source and I want put information from
>> each row onto one merged document. Can anyone tell me how to do this?

Reply to this Message

Graham Mayor - 22 Apr 2005 12:55 GMT

e.g. http://www.gmayor.com/individual_merge_letters.htm

Signature

<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>

> It can be done, but you have to use a macro. If you go to google
> groups and search this newsgroup for, e.g. "splitter", you will
[quoted text clipped - 8 lines]
>>> information from each row onto one merged document. Can anyone tell
>>> me how to do this?

Reply to this Message

Mike - 28 Apr 2005 16:59 GMT

Sarah,

If you're still monitoring this thread the simplest solution is to select
"Directory" as your document type. This will create a single document.

Mike

> I'm using a spreadsheet as my data source and I want put information from
> each row onto one merged document. Can anyone tell me how to do this?

Reply to this Message