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

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

Forum Jump


All times are GMT -5. The time now is 05:19 AM.

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

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