Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.newusers
|
|||
|
|||
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! |
#2
Posted to microsoft.public.word.newusers
|
|||
|
|||
Moving csv. database into Merge Mail
"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! |
#3
Posted to microsoft.public.word.newusers
|
|||
|
|||
Moving csv. database into Merge Mail
"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. |
#4
Posted to microsoft.public.word.newusers
|
|||
|
|||
Moving csv. database into Merge Mail
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" 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! |
#5
Posted to microsoft.public.word.newusers
|
|||
|
|||
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! |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail merge using a secure database | Mailmerge | |||
Mail merge text keeps on moving | Mailmerge | |||
Mail Merge Database Name | Microsoft Word Help | |||
Database Mail Merge with Currency! | Mailmerge | |||
Can I Mail Merge from SQL Database without an odc datasource? | Mailmerge |