View Single Post
  #5   Report Post  
Posted to microsoft.public.word.newusers
Graham Mayor Graham Mayor is offline
external usenet poster
 
Posts: 19,312
Default Moving csv. database into Merge Mail

This is more or less covered at
http://www.gmayor.com/convert_labels...mail_merge.htm

--

Graham Mayor - Word MVP

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


Suzanne S. Barnhill wrote:
Although I believe Word *can* use CSV as a mail merge data source,
it's easy enough to convert it to a table, which Word can use easily.
Select the text and use Table | Convert | Text to Table, separating
at commas. This will put each record in a row of the table. If you
don't already have a heading row, add one so that the merge fields
will have names.


"Jergy" wrote in message
...
When I was with a company that went bankrupt, I bought a database
file with info on 2300 businesses in my area, including addresses.
It is in csv. which the tech guy told was a good general format to
be compatible with various office applications. I am trying to get
it (an edited version) into Merge Mail. I have reached Step 3,
Select recipients using an existing list (to address envelopes.) I
cannot get my file past Merge Mail. Can I convert it to one of the
file types that Word accepts without retyping the whole thing. Thanx!