DO NOT Use Stamps.Com

[Nikhil]

It seems what you would need is a spreadsheet with the first line having the categories and then each row containing a person's information. If done right you can import any number of addresses. Example would be:

Name   Address   City  State   Zip
Abra   123 Cad   Abra  AL       12345
etc    234 etc   etc   TX       23456

The USPS program's address book format for CSV is like this:

Full Name,Company,Address 1,Address 2,Address 3,City,State,Zip Code,Province,Country,Urbanization,Phone,Fax,E Mail,Customer Ref #,Short Name

Joe Customer,ABC Co.,480 L'Enfant Pl. SW,,,Washington,DC,20024,,United States,,2022222222,,icustomercare@usps.com,,ABCCO

 

[GtrSoloist]

Yeah I tried that, it would only bring in data from the first line. In fact if you have the Header info in the first line, the program chokes. The way their software is setup I don't see it working out for the folks here who have all the info saved in a single file.

For example if you have Record 1 and Record 2. It will only see Record 1.

It's just sloppy programing, they need some sort of an address book feature.

 

[Nikhil]

It appeared fine for me and hitting Next Sample I saw 18 working addresses in my test. However, when I imported it said Error: "Please enter a mailing address" for all 18 of them.

 

[GtrSoloist]

Yeah I couldn't get it work right either. The problem though is when it does import an address it sets it up as a label ready to be printed and go out. I don't think it would work for how people here want to use it, provided we could get it to import all the data.

It's not like you can import into an address book where it will be saved and you can select who is getting a package any time you want to send them one. When you import it in, it's a one shot deal for a package getting ready to go out immediately.

 

[Nikhil]

Success! I managed to import the 18 addresses into the book.

What I did was take my .csv file and go to the online address book importer here: https://sss-web.usps.com/cns/landing.do

After I imported it successfully, I then exported it and it had the Province, Country, and Short Name columns filled in addition to the other columns I already had filled (Name, Address 1, City, State, Zip).

Then I imported it with the Shipping Assistant and it worked fine. I guess it just needed the Country and/or Province to be filled?

 

[GtrSoloist]

Pure, are you doing that at the usps site, or the Paypal multi-order shipping?

 

[Nikhil]

I only used the USPS site I linked to (the My Address Book link is in the bottom right of that page) and the USPS Shipping Assistant.

I'll attach a template that worked for me (it's the format it was in after exporting from the USPS site). Rename it to .csv or use right click -> Open With... and find your spreadsheet program.

 

[Jules22871]

Ah hell, it's storming here and my big vicious guard dog is shaking like a leaf so I'll just go ahead and type all 20 pages in there. It's not like I have anything else to do and I am sick to death of Farmville,lol

 

[DemonCowboy]

lol jules, the minions that take care of my apps for me would probably like to have u as a neighbor...lol

 

[Jules22871]

Your minions, lmao Being able to type 90 words a minute really makes putting all this in really easily,lol Now all I have to do is send out the bounty hunters for my escaped printer cables and I'd be set on mailing things. Well, I have to get a new mail box that doesn't leak but those are cheap.

Oh DC, your package went out today. I have the confirmation number if you want to play stalk the mailman,lol

 

[DemonCowboy]

well u could b my minion too and just alert me when it's out for delivery...

but TYVM again u always do go above and beyond any expectations i could ever have in some1...now if only i could find some1 like that for my own...lol

 

[markfm]

I just tried a PP MOS test, it seemed to go fine. I saved an Excel spreadsheet off as a CSV file, then PP allowed me to import it no problem.
The first time you do it, you map the CSV fields to Paypal fields, and you can save the import filter to reuse.
So, if folks are building up a master list of people to send to, one that they keep reusing, and need to send it to a subset on a given run, copy the master spreadsheet file into a "this shipment" copy, delete the ones you don't want, save to CSV and it should import cleanly to PP.

 

[Zenfrogs]

Thanks for this Sallana... Have thought of using paypal before but was too lazy to figure it out
Wanted to chime in that the USPS shipping assistant does not support Mac or Linux OS's so this a great option for Mac users like me. Thanks again!


Sent from my iPod touch using Tapatalk

 

[Jules22871]

well u could b my minion too and just alert me when it's out for delivery...

Yeah, I see that happening.

I just tried a PP MOS test, it seemed to go fine. I saved an Excel spreadsheet off as a CSV file, then PP allowed me to import it no problem.
The first time you do it, you map the CSV fields to Paypal fields, and you can save the import filter to reuse.
So, if folks are building up a master list of people to send to, one that they keep reusing, and need to send it to a subset on a given run, copy the master spreadsheet file into a "this shipment" copy, delete the ones you don't want, save to CSV and it should import cleanly to PP.

You would think as much time as I spend at a computer I could do more on one,lol I can use WordPerfect 9 in my sleep because I used that when I did medical transcription. But I am lost when it comes to excel and spread sheets. It's easier for me to just type it all in there myself,lol

And yes, big thank you to Sallana for the PP info. I didn't know you could do that with them without paying seller fees on something. Learn something new every day around here!

 

[DemonCowboy]

Yeah, I see that happening.



You would think as much time as I spend at a computer I could do more on one,lol I can use WordPerfect 9 in my sleep because I used that when I did medical transcription. But I am lost when it comes to excel and spread sheets. It's easier for me to just type it all in there myself,lol

And yes, big thank you to Sallana for the PP info. I didn't know you could do that with them without paying seller fees on something. Learn something new every day around here!

wow i can't even find WP these days though i was taught how to (was the last class to learn lotus too though)
here's an interesting fact though jules
if u use WP's format window most of the tags for that are the same as for HTML in case u'r interested

 

[Jules22871]

wow i can't even find WP these days though i was taught how to (was the last class to learn lotus too though)
here's an interesting fact though jules
if u use WP's format window most of the tags for that are the same as for HTML in case u'r interested

Ok, you all have to stop teaching me so many things in one day. My poor addled brain can't handle it

 

[GtrSoloist]

I only used the USPS site I linked to (the My Address Book link is in the bottom right of that page) and the USPS Shipping Assistant.

I'll attach a template that worked for me (it's the format it was in after exporting from the USPS site). Rename it to .csv or use right click -> Open With... and find your spreadsheet program.

Okay that explains it, I was working with Paypal's Multi-order-shipping software. lol

I just tried a PP MOS test, it seemed to go fine. I saved an Excel spreadsheet off as a CSV file, then PP allowed me to import it no problem.
The first time you do it, you map the CSV fields to Paypal fields, and you can save the import filter to reuse.
So, if folks are building up a master list of people to send to, one that they keep reusing, and need to send it to a subset on a given run, copy the master spreadsheet file into a "this shipment" copy, delete the ones you don't want, save to CSV and it should import cleanly to PP.

Which is an awful lot of work compared to using the USPS shipping assistant where you can have an address book.

 

[Ravens Rose]

Thanks for posting this. Going to the post office for me is a nightmare.

So now I have my scale (got it today), more bubble mailers & now I just need to order some larger juices so I can jump in on the fun.

Thanks again to those that sent me some samples to try!!!

 

[Ru42]

For the truly hardcore:

I have a DVD biz and at it's height I used to have a lot of shipping going on. I bought a Dymo LabelWriter Twin Turbo. I can print labels and stamps right from my computer. It is great and easy. However, since the printer costs $100 or so it is for those who have a lot of mail. My stamp account does not cost me anything (other then obviously the stamp cost.) Having a scale is a need as well.

Just thought I would toss this out there for anyone who might be interested.

 

[pm2006]

I have like 20 pages of addresses saved in a word document, alphabetically by username,lol So far it works great. Wonder if I can transfer that file to PP,lol

I have 20 little scraps of paper stuffed in a drawer.

I bought a digital scale from ebay for 7 or 8 bucks. It should be here tomorrow. I can't wait. If it gets here, all the pkgs I have to mail will be sent thru paypal!! woohoo

Thanks so much Sallana for the step by step instructions. I love that!