PC Review


Reply
Thread Tools Rate Thread

Converting to mailing labels

 
 
Dave Stitz
Guest
Posts: n/a
 
      22nd Jun 2007
I am working in Excel 2003 and always export data from our accounting system
to Excel for mailing labels. Is there an easy/efficient way to convert the
data in an excel spreadsheet to print on an Avery Label?

Thank you for your time.

Dave


 
Reply With Quote
 
 
 
 
Dave Peterson
Guest
Posts: n/a
 
      22nd Jun 2007
I'd keep the data in excel and use MSWord to print the labels.

You may want to read some tips for mailmerge.
http://www.mvps.org/dmcritchie/excel/mailmerg.htm
http://www.mvps.org/word/FAQs/MailMerge

The first is from David McRitchie and the second is by Beth Melton and Dave
Rado.

And if your data has zipcodes and you want to keep a nice format:

Debra Dalgleish posted this:

There's an article on the Microsoft web site that might help you:

Answer Box: Numbers don't merge right in Word
http://office.microsoft.com/en-ca/as...164951033.aspx

And if you prefer the old Mail Merge helper, Word MVP Suzanne Barnhill
has instructions here:

http://sbarnhill.mvps.org/WordFAQs/C...ngWord2002.htm

about half way down the page.

Dave Stitz wrote:
>
> I am working in Excel 2003 and always export data from our accounting system
> to Excel for mailing labels. Is there an easy/efficient way to convert the
> data in an excel spreadsheet to print on an Avery Label?
>
> Thank you for your time.
>
> Dave


--

Dave Peterson
 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
converting word mailing labels to Excel Marie Microsoft Excel Worksheet Functions 0 19th Aug 2009 01:15 AM
creating mailing labels from an access data base customer mailing =?Utf-8?B?bGFkYXJpZHVib2lz?= Microsoft Access Getting Started 7 26th Jul 2006 10:39 PM
converting spreadsheet info onto mailing labels? =?Utf-8?B?ZWthdGVyaW5h?= Microsoft Excel Worksheet Functions 3 26th Jun 2006 05:06 PM
how do i convert MS Word mailing labels into an Excel mailing lis. =?Utf-8?B?dW5yaHlsbA==?= Microsoft Excel Misc 1 4th Feb 2005 12:19 AM
Converting a contact Database into mailing labels Jerard Microsoft Excel Misc 1 23rd Jul 2003 07:43 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 07:52 AM.