Printing envelopes

Ann-Marie

Registered User
Messages
250
hi
i have a spreadsheet with addresses on it in excel anyone know how i print envelopes with this list
thanks for your help
 
Did you search the Excel help for terms like "envelope" and "mail merge"? Seems to explain everything as far as I can see.
 
or alternatively, do the mail merge in word, using your excel list as a data source and print to A4 avery labels. Advantage is that envelopes can be any size .
 
Did you search the Excel help for terms like "envelope" and "mail merge"? Seems to explain everything as far as I can see.

The search (either in word or excel) will give you everything you need to know.

As a basic example...
Open "word", go to "tools", then to "letters and mailing", then to "mail merge".
From there select the type of document you want (either envelopes or labels in this case I'd guess) [then click on next].
Use the options to select the size of envelope/label and fine tune any settings as needed (printing setup etc.). [then click on next]
Now select "use an existing list" and browse to the excel file that contains the info. [click on next]
Use the "address block" to layout the address as you wish it to appear (you can also use the mail merge option to give a standard letter etc a personalised touch for each person on the list).

Then preview the results and complete the merge.

Thats a very (VERY) basic overview of it just to show it isn't hard. Use the guides in Excel or Word to give you far more information and learn to use the full benefits of Mail Merge. Can save a lot of time if sending out mass mails to numerous recepients.
 
Back
Top