+Ladycacher Posted December 19, 2005 Share Posted December 19, 2005 Right now I am getting the labels and packaging ready for the KS coin. I am copying the address from pay-pal and pasting it onto the label format. Is there a way to merge it, upload it, etc. from pay-pal or ebay a easier way? I do not have any programs other than WordPerfect 12. I am also using Avery label sheets that hold 30 address per sheet. I am then running that through a regular printer. Thanks in advance. Quote Link to comment
+Camp Explorer Posted December 19, 2005 Share Posted December 19, 2005 (edited) You can download from history. edit I quess not I did not get address when I tried sorry Edited December 19, 2005 by Camp Explorer Quote Link to comment
+AtlantaGal Posted December 19, 2005 Share Posted December 19, 2005 You can download from history. To import into excel, right? Or am I thinking of something else? Quote Link to comment
+Camp Explorer Posted December 19, 2005 Share Posted December 19, 2005 (edited) Yes if it gave the address it would be to excel then make a label from there. Edit Ok go to history then down load history then Customize history and check shipping address. uncheck what you don't want. Edited December 19, 2005 by Camp Explorer Quote Link to comment
+Ladycacher Posted December 19, 2005 Author Share Posted December 19, 2005 I do not have excel. I have Quattro Pro. which I believe is the same thing. Quote Link to comment
+Ladycacher Posted December 19, 2005 Author Share Posted December 19, 2005 I tired to download the history onto my computer and it didn't work like ya'll are talking. More info please. Quote Link to comment
+Camp Explorer Posted December 19, 2005 Share Posted December 19, 2005 Did it give you a chose where to download too? Q pro I have never done this before so I'm learning now. make sure the dates are right from when you sold coins. File type to download select Comma Delimited all activity. Quote Link to comment
PCFrog Posted December 19, 2005 Share Posted December 19, 2005 Bummer I used excel and mail merg to word to make labels. Quote Link to comment
+CacheDragons Posted December 19, 2005 Share Posted December 19, 2005 The way I did it was to download the history from paypal into an excel format. Then I used microsoft word and did a mail merge, the only thing I got burnt on was that excel saw the zipcode as a numeric field so it removed all the leading 0 in the zip code. Quote Link to comment
+Ladycacher Posted December 19, 2005 Author Share Posted December 19, 2005 (edited) edit Edited December 19, 2005 by Ladycacher & Boys Quote Link to comment
+Ladycacher Posted December 19, 2005 Author Share Posted December 19, 2005 (edited) edit Edited December 19, 2005 by Ladycacher & Boys Quote Link to comment
+Camp Explorer Posted December 19, 2005 Share Posted December 19, 2005 Sorry I can't help It won't let me download right now. When I did get it a window opened and ask if i wanted excel to open it. Anyone Else HELP! Quote Link to comment
+Ladycacher Posted December 19, 2005 Author Share Posted December 19, 2005 Ok, I have it in Q-pro. How would I move it from there into printing labels? Quote Link to comment
+Blind Avocado Posted December 19, 2005 Share Posted December 19, 2005 (edited) You will need a word processor program that has mail merge. Microsoft word does this well. I used MS Publisher to design my label to the specific Avery label size and then mail merged. Edited December 19, 2005 by Blind Avocado Quote Link to comment
+Shop99er Posted December 19, 2005 Share Posted December 19, 2005 Right now I am getting the labels and packaging ready for the KS coin. I am copying the address from pay-pal and pasting it onto the label format. Is there a way to merge it, upload it, etc. from pay-pal or ebay a easier way? I do not have any programs other than WordPerfect 12. I am also using Avery label sheets that hold 30 address per sheet. I am then running that through a regular printer. Thanks in advance. WOW!! That's pretty involved. We use a MK1 paper and a MK2 pen. Quote Link to comment
+DutchBoy Posted December 19, 2005 Share Posted December 19, 2005 When I did my presales, I opened up Word and used the label format, then I also copied and pasted the addresses from my paypal emails and printed them out. I did them as they came in so I would not get behind. Then I wrote the number of coins on each label. I double checked them when I shut off presales. Now I have several pages of ready to go labels, when my coins come in. This is not a very high tech way to do it, but it worked for me. Quote Link to comment
+GBOTS Posted December 19, 2005 Share Posted December 19, 2005 I used a "Magic Marker". Worked quite well Quote Link to comment
+Lemon Fresh Dog Posted December 19, 2005 Share Posted December 19, 2005 (edited) Go to PayPal Download as a .csv file pay special attention to the option that allows the address to be loaded as SEPARATE fileds (otherwise it's one big line) You can then pull the fields you want -- I put the number of coins right after the name -- this made envelop stuffing WAY easier. You can then bring this into a spreadsheet program to "clean" it up. (I also sorted on the country field to ensure I separeated envelopes that needed customs forms) If you use Quatro Pro, are you also using WordPerfect? If so, it should import no problem. Open WordPerfect, select Label/Mail Merge, choose the Avery #, choose the Quattro Pro file and follow the wizard. When I did mine, I have hundreds of customs labels to do -- so I printed "game token value $7" onto clear labels and just stuck them on. Edited December 19, 2005 by Lemon Fresh Dog Quote Link to comment
+WeatherednBoston Posted December 19, 2005 Share Posted December 19, 2005 You can print your postage labels right from Paypal. It prints the postage and the address all in one. Tracking on your packages would only be 13 cents each...or free if shipping priority. What I like best about this feature is NO huge lines to wait in at the post office. Just drop the envelopes into the box at the post office and they are on thier way. To use this service is free...just pay for postage costs. I use it on all my Ebay transactions. Quote Link to comment
+Ladycacher Posted December 19, 2005 Author Share Posted December 19, 2005 Go to PayPalDownload as a .csv file pay special attention to the option that allows the address to be loaded as SEPARATE fileds (otherwise it's one big line) You can then pull the fields you want -- I put the number of coins right after the name -- this made envelop stuffing WAY easier. You can then bring this into a spreadsheet program to "clean" it up. (I also sorted on the country field to ensure I separeated envelopes that needed customs forms) If you use Quatro Pro, are you also using WordPerfect? If so, it should import no problem. Open WordPerfect, select Label/Mail Merge, choose the Avery #, choose the Quattro Pro file and follow the wizard. When I did mine, I have hundreds of customs labels to do -- so I printed "game token value $7" onto clear labels and just stuck them on. Trying it now.... Quote Link to comment
+Ladycacher Posted December 19, 2005 Author Share Posted December 19, 2005 Go to PayPalDownload as a .csv file pay special attention to the option that allows the address to be loaded as SEPARATE fileds (otherwise it's one big line) You can then pull the fields you want -- I put the number of coins right after the name -- this made envelop stuffing WAY easier. You can then bring this into a spreadsheet program to "clean" it up. (I also sorted on the country field to ensure I separeated envelopes that needed customs forms) If you use Quatro Pro, are you also using WordPerfect? If so, it should import no problem. Open WordPerfect, select Label/Mail Merge, choose the Avery #, choose the Quattro Pro file and follow the wizard. When I did mine, I have hundreds of customs labels to do -- so I printed "game token value $7" onto clear labels and just stuck them on. How do you "pull the fields" you want? I am new to this program..... Quote Link to comment
+crake Posted December 19, 2005 Share Posted December 19, 2005 I bought a Brother thermal printer for $30 after rebate. Paypal knows how to talk to this printer. So I just need to click "ship", fill out the USPS info and press print. A few seconds later a prepaid label shoots out of the printer. Drop the whole mess off at the post office (no lines), and that's it! This isn't the cheapest method (requires paypal merchant I think, plus the thermal label runs about $.20 per print), but its probably the fastest! Also get delivery confirmation, automatic emailing of tracking numbers, etc. I battled the trade off (cost vs. time) and time won Quote Link to comment
+WWC-World's Worst Cacher Posted December 19, 2005 Share Posted December 19, 2005 Hmm . . . . The easiest way would be to send the csv file to someone who has Word along with the label size you want to use. They could in 10 minutes create the file you need and sent it back. I would do it, but may not have decent access to my computer until Thursday. If it can wait until then let me know. I can have it done in less than 30 minutes. Southbayday Quote Link to comment
+Ladycacher Posted December 19, 2005 Author Share Posted December 19, 2005 We are just going to continue the way we are doing it. It's not all that bad once we had a system going. Quote Link to comment
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.