Re: Another Mailing Label Question!
From: Suzanne S. Barnhill (sbarnhill_at_mvps.org)
Date: 02/22/04
- Next message: Anthony Giorgianni: "Re: List of Words Used in a Document"
- Previous message: Suzanne S. Barnhill: "Re: Can't bold one word at a time on Word 2002"
- In reply to:(deleted message) Bright Spark: "Another Mailing Label Question!"
- Next in thread: Bright Spark: "Re: Another Mailing Label Question!"
- Messages sorted by: [ date ] [ thread ]
Date: Sat, 21 Feb 2004 19:10:44 -0600
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 Word MVP FAQ site: http://www.word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Bright Spark" <BrightSpark1901@Hotmail.com> wrote in message news:pblf30th5n54abkaj2sqb47kig8oqbeb9g@4ax.com... > 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 >
- Next message: Anthony Giorgianni: "Re: List of Words Used in a Document"
- Previous message: Suzanne S. Barnhill: "Re: Can't bold one word at a time on Word 2002"
- In reply to:(deleted message) Bright Spark: "Another Mailing Label Question!"
- Next in thread: Bright Spark: "Re: Another Mailing Label Question!"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
