Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I make a customer list that converts to labels?
Can I set up an address listing of my customers and then convert that to
address labels? Can I add customers and keep them in alphabeticval order? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can I make a customer list that converts to labels?
Hi,
You would do this most easily from Word using a mail merge. In Word; Tools, Letters & Mailings, Mail Merge Wizard Follow the prompts on the task pane (which IMHO is actually quite good on this one) - there is an option on the first pane for Labels. You can choose a spreadsheet as your source - although you may have to reformat your data - see how the wizard goes. As for adding new items & maintaining alphabetical order in your spreadsheet look up 'sort a list' in help. Regards, Chris. -- Chris Marlow MCSD.NET, Microsoft Office XP Master "Deeregirl" wrote: Can I set up an address listing of my customers and then convert that to address labels? Can I add customers and keep them in alphabeticval order? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I make chart labels or legends wordwrap? | Charts and Charting in Excel | |||
How to make a chart from a list of names? | Charts and Charting in Excel | |||
Text manipulaion (summarizing customer records) Index function probably not good choice | Excel Discussion (Misc queries) | |||
How do I make the Excel progam alphabetize my client list? | Excel Discussion (Misc queries) | |||
How do I make mailing labels from an excel document? | Setting up and Configuration of Excel |