Another Mailing Label Question!

[Bright Spark]

I am still trying to get a real handle on mailing lists - this time I
need to transform my mailing list, which is a comma delimited list,
into mailing labels. I don't need or want to mail/merge - I only want
labels - would there be somewhere a tutorial on how to do this? My
address list contains of 7 fields, only 6 of which I want on the label
(the first field is just an identifying number), as follows:

1435,"JANE","JONES","656 WEST STREET","LOS ANGELES","CA","90010"

I need this to come out as a mailing label:

Jane Jones
656 West Street
Los Angeles, CA 90010

Thank you so much.

Bright Spark

 

[Suzanne S. Barnhill]

Although you could convert such a list directly to labels, you'll probably
find it far easier to convert the list to a table first, then use the table
as a data source for a merge to labels. If you are ever going to use this
list for labels again, and if the list will ever change (people be added or
removed), you're much better off having it as a data source.

To convert it to a table, use Table | Convert | Table to Text, separating at
commas and making sure that Word's idea of the correct number of columns
agrees with yours. You can remove the quotes either before or after
converting to a table. Add a heading row (marked as such) to give Word
something to use as the mergefield names. From there, see these articles:

How to create a Mail merge
http://word.mvps.org/FAQs/MailMerge/CreateAMailMerge.htm

Creating a mail merge Data Source
http://word.mvps.org/FAQs/MailMerge/CreateADataSource.htm

--
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA

Email cannot be acknowledged; please post all follow-ups to the newsgroup so
all may benefit.

 

[Graham Mayor]

You *do* need mail merge for this task, and your data file can be used
almost as it stands. You could convert it to a table as suggested by
Suzanne, or you could add seven field names as the first line of the file eg

ID,FirstName,LastName,Street,City,State,Zip

Then you must search and replace all the quotes " with nothing, so that you
end up with a file that looks like

ID,FirstName,LastName,Street,City,State,Zip
1435,JANE,JONES,656 WEST STREET,LOS ANGELES,CA,90010
1436,JOHN,SMITH,657 WEST STREET,LOS ANGELES,CA,90010
etc
You can then use this as a data file to create a simple mail merge.
http://www.gmayor.com/mail_merge_labels_with_word_xp.htm explains how to do
that.

You can maintain the list from the Mail Merge Recipients tool on the Merge
toolbar.


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

 

[Beth Melton]

Hi Graham,

If the field names in the header row are enquoted there is no need to
remove the quotes in the data source.
--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

 

[Beth Melton]

You can use your delimited file 'as is' however you will either need
to create another file for the Header row (which is a little more
difficult to do if you are using the new Mail Merge Wizard in Word
2002/2003) or add the header row as the first line.

For more information on using a text file as a data source take a look
at:
http://word.mvps.org/FAQs/MailMerge/CreateADataSourceContent.htm#TextFile

--
Please post all follow-up questions to the newsgroup. Requests for
assistance by email can not be acknowledged.

~~~~~~~~~~~~~~~
Beth Melton
Microsoft Office MVP

Word FAQ: http://mvps.org/word
TechTrax eZine: http://mousetrax.com/techtrax/
MVP FAQ site: http://mvps.org/

 

[Bright Spark]

Thank you for the help, Suzanne! ))

Bright Spark

 

[Bright Spark]

Thank you, Graham! In old DOS WordPerfect this was such a snap to do
in just one file formatted for labels!! I sure don't understand why
MS Word has to be so unbelievably complicated!! <sigh> ))

Bright Spark

 

[Bright Spark]

Thank you for the link, Beth! ))

Bright Spark

 

[Graham Mayor]

That's what comes of not testing thoroughly. I was thrown by the fact that
the first field had no quotes, but the others had.
Nevertheless my suggestion works as supplied


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