Moving csv. database into Merge Mail

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!

Jergy
Sat Aug 11 22:20:01 CDT 2007



"Jergy" wrote:

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

Jergy
Sat Aug 11 22:22:01 CDT 2007



"Jergy" wrote:

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

I forgot to mention that I am using Office 2003 Professional.

Suzanne
Sat Aug 11 22:35:35 CDT 2007

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.

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
Word MVP FAQ site: http://word.mvps.org
Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

"Jergy" <Jergy@discussions.microsoft.com> wrote in message
news:9EB6E619-A6A0-46E6-B25C-80F3DB21765A@microsoft.com...
> 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!

Graham
Sun Aug 12 00:08:15 CDT 2007

This is more or less covered at
http://www.gmayor.com/convert_labels_into_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" <Jergy@discussions.microsoft.com> wrote in message
> news:9EB6E619-A6A0-46E6-B25C-80F3DB21765A@microsoft.com...
>> 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!