Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Printing envelopes using a CSV mail file

1,188 views
Skip to first unread message

Pei...@officeformac.com

unread,
Jul 20, 2009, 10:23:10 AM7/20/09
to
Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

I need to print 200 envelopes (custom size) using a csv mail file data base. I have been able to set up the envelope so that it prints an address from my address book, but cannot figure out how to get it to use a csv or comma delimited mail file.

Any help...desparate!
Bob Peiffer

Peter Jamieson

unread,
Jul 20, 2009, 11:14:44 AM7/20/09
to
Were you using the Tools->Envelopes option?

If so, for mass printings you need to start with Tools->Mail Merge
Manager, then
1. under "Select Document Type," click "Create New" and select
Envelopes... .
2. Do the page setup that you need in the Envelopes dialog that pops
up. I wouldn't put anything in the Delivery Address box at this point
3. Under "Select Recipients List," click Get List and select Open Data
Source... .
4. Locate and select your csv file. You may see a dialog asking for
the field and record delimiters that Word should look for - typically
comma and Enter, but could be e.g. tab and enter.
5. Drag the placeholder fields you need into the box on the envelope
that says "Drag fields into this box or type text"
6. continue with steps 4,5 and 6 in the Mail Merge Manager dialog box.

To be honest I am much more familiar with the equivalent process on
Windows Word, but my guess is that if you have any difficulties it is
likely to be with Word not being able to read the csv properly (e.g. if
yu have multiline address data). If so, and you happen to have Excel as
well, your best bet in that situation may be to import your csv into
Excel and use that worksheet as your data source.


Peter Jamieson

http://tips.pjmsn.me.uk

j...@giddydigs.com

unread,
Dec 15, 2019, 12:41:43 AM12/15/19
to
There is no Tools -> Envelopes in Google docs
0 new messages