printing address labels

[tacomamac]

I maintain a 2700 member roster on Excel and need to know if I can print Members address labels from the worksheet. Cant seem to find any info in Excel publications.

Mac Maginnis

[Juan Pablo González]

Easy thing to do, do a mail merge with Word. Excel does not provide a built in feature for this.

[Anne Troy]

Agreed.

Here's complete instructions on how to mailmerge with Word to Excel:

http://www.thewordexpert.com/word.htm#MailMerge

[Yogi Anand]

On 2002-04-27 10:23, tacomamac wrote:
I maintain a 2700 member roster on Excel and need to know if I can print Members address labels from the worksheet. Cant seem to find any info in Excel publications.

Mac Maginnis

Hi Mac:
Juan Pablo and Dreamboat have already given you a good solution using Word. In case you want to work this from within Excel, you can do this using the Index Function and concatenate various items that make up a record. As Juan has correctly pointed out, working from within Excel will require setting up at least one label, and may be a set of labels before you can get going with it. It is going to take a bit of effort to learn the setup but once you have it figured out, I am sure Excel will do the job to your satisfaction.

HTH

[Jack in the UK]

you will know i love excel she is wonderful and beautiful,,, but she retired from the lables,,, her sister WORD cover this,,,,

After Dreamboat pointing to a few ideas, mt hate for word is less Lables and mail merge she loves.. but batch mail merge i would still aks my lover Excel to do.. as i feel she does the with sex, and offers tweaks word can not.

Use word my friend...

[Jack in the UK]

did you have a winner?