Word documents from records in csv file?

If you have a csv file and you would like to create a standardized word
document for a record in the csv file, how would you do that? Can anyone
point me in a direction to start reading? If there a way to set up a word
document to pull fields for entries from another file? Or maybe there is
another MS product to explore?

Thanks,
Susan

Herb
Sat Sep 22 13:44:36 CDT 2007

If I needed to have the csv file in Word format, I would open the file with
Excel, copy the resulting columns/rows to the clipboard, then paste into
Word (to produce a Word table), then save in Word format.

You could do everything using Word (e.g., using mailmerge, and sending the
output to a file; or using find/replace), but using Excel as an intermediary
strikes me as easier. If you plan to use the resulting file as a data file,
in fact, you might simply leave it in Excel format, and not bother
converting it to Word.

--
Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com


"Susan" <dsnsacree@msn.com> wrote in message
news:OqD1XqT$HHA.4568@TK2MSFTNGP02.phx.gbl...
> If you have a csv file and you would like to create a standardized word
> document for a record in the csv file, how would you do that? Can anyone
> point me in a direction to start reading? If there a way to set up a word
> document to pull fields for entries from another file? Or maybe there is
> another MS product to explore?
>
> Thanks,
> Susan
>

Susan
Sat Sep 22 19:41:41 CDT 2007


Thanks. It will work for one record but would be too much for several
records.

"Herb Tyson [MVP]" <herb@1x2y3z.xnw> wrote in message
news:OS$biiU$HHA.5360@TK2MSFTNGP03.phx.gbl...
> If I needed to have the csv file in Word format, I would open the file
> with Excel, copy the resulting columns/rows to the clipboard, then paste
> into Word (to produce a Word table), then save in Word format.
>
> You could do everything using Word (e.g., using mailmerge, and sending the
> output to a file; or using find/replace), but using Excel as an
> intermediary strikes me as easier. If you plan to use the resulting file
> as a data file, in fact, you might simply leave it in Excel format, and
> not bother converting it to Word.
>
> --
> Herb Tyson MS MVP
> Author of the Word 2007 Bible
> Blog: http://word2007bible.herbtyson.com
> Web: http://www.herbtyson.com
>
>
> "Susan" <dsnsacree@msn.com> wrote in message
> news:OqD1XqT$HHA.4568@TK2MSFTNGP02.phx.gbl...
>> If you have a csv file and you would like to create a standardized word
>> document for a record in the csv file, how would you do that? Can anyone
>> point me in a direction to start reading? If there a way to set up a
>> word document to pull fields for entries from another file? Or maybe
>> there is another MS product to explore?
>>
>> Thanks,
>> Susan
>>
>

Herb
Sat Sep 22 22:31:15 CDT 2007

Why would it be too much for several records? In Excel, each record is a
row, and each variable is a column. You open the csv file, and presto... If
you then want it in Word format, copy the data to the clipboard and paste it
into Word. It's fast and efficient. I don't see where the difficulty lies.

--
Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com


"Susan" <dsnsacree@msn.com> wrote in message
news:Oq1$$pX$HHA.3916@TK2MSFTNGP02.phx.gbl...
>
> Thanks. It will work for one record but would be too much for several
> records.
>
> "Herb Tyson [MVP]" <herb@1x2y3z.xnw> wrote in message
> news:OS$biiU$HHA.5360@TK2MSFTNGP03.phx.gbl...
>> If I needed to have the csv file in Word format, I would open the file
>> with Excel, copy the resulting columns/rows to the clipboard, then paste
>> into Word (to produce a Word table), then save in Word format.
>>
>> You could do everything using Word (e.g., using mailmerge, and sending
>> the output to a file; or using find/replace), but using Excel as an
>> intermediary strikes me as easier. If you plan to use the resulting file
>> as a data file, in fact, you might simply leave it in Excel format, and
>> not bother converting it to Word.
>>
>> --
>> Herb Tyson MS MVP
>> Author of the Word 2007 Bible
>> Blog: http://word2007bible.herbtyson.com
>> Web: http://www.herbtyson.com
>>
>>
>> "Susan" <dsnsacree@msn.com> wrote in message
>> news:OqD1XqT$HHA.4568@TK2MSFTNGP02.phx.gbl...
>>> If you have a csv file and you would like to create a standardized word
>>> document for a record in the csv file, how would you do that? Can anyone
>>> point me in a direction to start reading? If there a way to set up a
>>> word document to pull fields for entries from another file? Or maybe
>>> there is another MS product to explore?
>>>
>>> Thanks,
>>> Susan
>>>
>>
>
>

Graham
Sat Sep 22 23:45:33 CDT 2007

What I suspect you are looking for is mail merge -
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm or
http://www.gmayor.com/merge_labels_with_word_2007.htm These pages cover the
essentials of mail merge, albeit concentrated on labels as these are the
most complex of the merge types. Letter and directory merges are simpler.
Word can use a variety of data sources for merge - including CSV.
See also http://www.gmayor.com/convert_labels_into_mail_merge.htm which
demonstrates how to convert a CSV format file to a table.
--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

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

Susan wrote:
> Thanks. It will work for one record but would be too much for several
> records.
>
> "Herb Tyson [MVP]" <herb@1x2y3z.xnw> wrote in message
> news:OS$biiU$HHA.5360@TK2MSFTNGP03.phx.gbl...
>> If I needed to have the csv file in Word format, I would open the
>> file with Excel, copy the resulting columns/rows to the clipboard,
>> then paste into Word (to produce a Word table), then save in Word
>> format. You could do everything using Word (e.g., using mailmerge, and
>> sending the output to a file; or using find/replace), but using
>> Excel as an intermediary strikes me as easier. If you plan to use
>> the resulting file as a data file, in fact, you might simply leave
>> it in Excel format, and not bother converting it to Word.
>>
>> --
>> Herb Tyson MS MVP
>> Author of the Word 2007 Bible
>> Blog: http://word2007bible.herbtyson.com
>> Web: http://www.herbtyson.com
>>
>>
>> "Susan" <dsnsacree@msn.com> wrote in message
>> news:OqD1XqT$HHA.4568@TK2MSFTNGP02.phx.gbl...
>>> If you have a csv file and you would like to create a standardized
>>> word document for a record in the csv file, how would you do that?
>>> Can anyone point me in a direction to start reading? If there a
>>> way to set up a word document to pull fields for entries from
>>> another file? Or maybe there is another MS product to explore?
>>>
>>> Thanks,
>>> Susan