Turning PalmPilot Contact info Address Labels - best way?

Factual Questions
1

I am searching on this and haven’t found the best answer - any Dopers have experience with this:

I have the mailing lable sheets I can feed into my printer

  • should I export the contact file to MS Word or Excel?
  • how can I do it so it will require the least formatting after export? Right now, I end up with the contact info all on one line. How can I get it in label format:

name
address
city, state zip

  • how can I get it in rows, so they match the address labels on the page? I was thinking that I could export to Excel then cut and paste the addresses into rows - that would be easier than trying to use tabs in Word - or I could use a Table in Word…any thoughts?

If you have a specific website that you would recommend I check, please let me know.

2

I think the best way is to export to Excel, make sure each line is a separate column (may have to c&p for this, depending on how the info is exported) then save your workbook.

Go into word and go to tools>letters and mailings>mail merge, then choose labels. Follow instructions after that to choose the type of labels, and make sure you match up your fields. (i.e. name to name, address to address, etc.)

3

That worked XJETGIRLX - thanks. I figured out based on your post and some further investigation that I could import an Excel file with the contact info all on one line in Excel and it woudl format it correctly in Word.

Cool.

4

Where was this question earlier, when I was attempting the same thing?I got fed up with trying,and hand wrote all my labels for Chritmas cards

5

UPDATE:

The Great News: Got 'em done - thanks again.

The Challenging News/Question: Okay, how am I supposed to handle Zip Codes that start with “0”??? I set the cell format in Excel to “Special - Zip Code” and it looks just right - 0xxxx; but when I import it into Word using the Mail Wizard, it just comes up xxxx - no 0!!!

I even tried to individually edit each label and added a “0” manually, but they still didn’t print. I eventually just faked it and stashed their zip code in their State field and printed it off that way - a pain, but at least I only had a few addresses to those states…

What is the correct way to do this - anyone?

6

Hrm. I’ve never encountered this problem before, not having had the opportunity to use a zip code beginning with zero but have you tried using the letter O instead? It might look a little different, but may serve the purpose.

7

The Excel “Zip Code” format that you used is just a number with leading zeroes displayed.

To get what you want, you need to change the number into text. Use the Excel function =TEXT(a1,“00000”) where a1 is the cell address of the zip code.

8

I don’t understand the need to export into Excel.

The Palm DESKTOP software, that resides on your computer…has the ability to print out address labels.

See here , for example

9

Hmm on review, I should amend my previous response. Apparently in Windows, the above suggestion also requires the use of MS Word.

In the Mac version of the Palm Desktop (that I use) , you can directly print labels…perhaps the Windows version is different?

http://www.palmone.com/us/software/desktop/mac.html

10

Wow beagledave - I didn’t even think to check that out. I will - thanks.