How To Create A Mailing List in "Comma Delimited" Format?

[Bright Spark]

I need to type up a mailing list in "comma delimited" format so that
it can go to a mailing company. Can anyone please tell me how I can
do this in MS Word. Thanks very much. ))

Bright Spark

 

[Mark Tangard]

Hi Bright Spark,

It'd be very tedious to do this in Word, but easy to do in Excel.
In Excel, just enter each record in one row, with field labels
in the first row. Then when you save it, choose ".CSV" in the
Save As Type box.

One caveat: If you have fields with leading zeros (like zip
codes for the New England states, New Jersey, or Puerto Rico)
you must format that column as TEXT, not numeric, or the zeros
will be lost. AND, once you save the file to CSV format and
close it, reopening it in Excel strips out those zeros. So
if you must edit the file after closing it, you must either
repair those cells each time, or edit it in another program
(Wordpad is useful for this.)

(This applies to Excel 2000; I'm not sure if it's the same in
2002 or 2003. I'm not even sure if it's considered a bug.)

 

[Bright Spark]

Hi Bright Spark,

It'd be very tedious to do this in Word, but easy to do in Excel.
In Excel, just enter each record in one row, with field labels
in the first row. Then when you save it, choose ".CSV" in the
Save As Type box.

One caveat: If you have fields with leading zeros (like zip
codes for the New England states, New Jersey, or Puerto Rico)
you must format that column as TEXT, not numeric, or the zeros
will be lost. AND, once you save the file to CSV format and
close it, reopening it in Excel strips out those zeros. So
if you must edit the file after closing it, you must either
repair those cells each time, or edit it in another program
(Wordpad is useful for this.)

(This applies to Excel 2000; I'm not sure if it's the same in
2002 or 2003. I'm not even sure if it's considered a bug.)

Thanks very much for the help, Mark - I appreciate it! ))

Bright Spark

 

[Graham Mayor]

When I saw your original question I too thought 'table' - but in my case I
was thinking Word table rather than Excel. You can do the same thing in a
Word table which you can then convert to text with the tool from the table
menu. The result would be effectively the same.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>
Graham Mayor - Word MVP
E-mail (e-mail address removed)
Web site www.gmayor.com
Word MVP web site www.mvps.org/word
<>>< ><<> ><<> <>>< ><<> <>>< <>>< ><<>

 

[Bright Spark]

Ahhhhhh, thank you very much, Graham! ))

Bright Spark