Register FAQ / Rules Forum Spy Search Today's Posts Mark Forums Read
Go Back   MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Reply
 
Thread Tools Search this Thread Display Modes
Old Aug 10, 2013, 04:19 PM   #1
Oracle1729
macrumors 6502
 
Join Date: Feb 2009
Print envelopes without "contacts"

I'd like to print a couple of hundred envelopes from address I have in a semi-csv format basically "firstname,fulladdress". Is there a good way to do this, even if I have to do a lot of cutting and pasting. I probably will need to print another set in a few months that will include about half of these and a lot from another list.

Everything I've found online (such as pages, and contacts itself) says it automatically pulls the addresses out of contacts. This isn't helpful to me, I don't want to add hundreds of addresses to my contacts and it looks like on ML it's cloud based so I need to create a new iCloud account to do that? Also Contacts assumes too much about how I want the envelope formatted based on what it can pull from the records, like trying to mix Mr. and Mrs. from two records which it always seems to guess wrong. It seems like this was so easy last time I did it (about 20 years ago using MS Works in Win 3.1), and so much harder now.
Oracle1729 is offline   0 Reply With Quote
Old Aug 10, 2013, 08:44 PM   #2
prisstratton
macrumors regular
 
Join Date: Dec 2011
Location: Winnipeg
Quote:
Originally Posted by Oracle1729 View Post
I'd like to print a couple of hundred envelopes from address I have in a semi-csv format basically "firstname,fulladdress". Is there a good way to do this, even if I have to do a lot of cutting and pasting. I probably will need to print another set in a few months that will include about half of these and a lot from another list.

Everything I've found online (such as pages, and contacts itself) says it automatically pulls the addresses out of contacts. This isn't helpful to me, I don't want to add hundreds of addresses to my contacts and it looks like on ML it's cloud based so I need to create a new iCloud account to do that? Also Contacts assumes too much about how I want the envelope formatted based on what it can pull from the records, like trying to mix Mr. and Mrs. from two records which it always seems to guess wrong. It seems like this was so easy last time I did it (about 20 years ago using MS Works in Win 3.1), and so much harder now.
I would use Mail Merge in MS-Office to do this, it can pull the data from a .csv file into Word and then print your envelopes. If you do not use MS-Office then OpenOffice can do the same thing:

http://www.openoffice.org/documentat...Mail-Merge.pdf
__________________
 17" 2011 MacBook Pro, 2.3 GHz i7 Quad, 16GB DDR3, Intel 520 240GB SSD
prisstratton is offline   0 Reply With Quote
Old Aug 11, 2013, 12:20 PM   #3
FoxFifth
macrumors regular
 
Join Date: Oct 2012
Another option is Avery Design and Print Online. It allows import form csv files. http://www.avery.com/avery/en_us/Tem...int-Online.htm
FoxFifth is offline   0 Reply With Quote
Old Aug 27, 2013, 03:15 PM   #4
Oracle1729
Thread Starter
macrumors 6502
 
Join Date: Feb 2009
Quote:
Originally Posted by prisstratton View Post
I would use Mail Merge in MS-Office to do this, it can pull the data from a .csv file into Word and then print your envelopes. If you do not use MS-Office then OpenOffice can do the same thing:

http://www.openoffice.org/documentat...Mail-Merge.pdf
Thanks for your reply, sorry for the lack of thanks, I just wanted to get the job done. Your advice was very useful.

I ended up using openoffice. The database part went pretty smoothly until I changed the list display format when I was trying to print the listing and can't get it to look right. Apparently envelope printing is a disaster in openoffice it took a lot of trial and error and wasted envelopes until I got something that looks like crap on the screen but prints right (based on my searches, this is normal for openoffice).

Anyway, the job is done, the end results are perfect and I just wanted to say thanks for steering me in the right direction.
Oracle1729 is offline   0 Reply With Quote

Reply
MacRumors Forums > Apple Applications > Mac Applications and Mac App Store

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
iTunes "purchase history" print out? (for taxes) jammybastard iCloud and Apple Services 3 Apr 5, 2014 11:43 AM
Move contacts from "Exchange" to "iCloud" sonicrobby iPhone Tips, Help and Troubleshooting 5 Aug 4, 2013 02:53 PM
Contacts created from text message don't show up in "Contacts" dabigone iPhone Tips, Help and Troubleshooting 0 Apr 7, 2013 04:24 PM
My "review" of Apple Print Services Prodo123 Digital Photography 4 Nov 3, 2012 08:57 AM
IOS6 - Yahoo mail account: Turn on "contacts" does what? PeteLP iPhone Tips, Help and Troubleshooting 1 Sep 20, 2012 10:24 PM

Forum Jump

All times are GMT -5. The time now is 09:16 PM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2013, MacRumors.com, LLC