Help protect children from gaming harms.

Take our survey

Please or to access all these features

Geeky stuff

Please tell me there is a way I can print a load of addresses onto eveleopes (in Word) in one go

11 replies

Moln · 29/02/2012 13:28

I mean I've used mail merge for letters before, but used window envelopes so I never had a need to figure it out.

Now, in work, I'm given (already printed) letters that are confidential so window envelopes are out.

Is there a way i can print all the evelopes together?

At the moment I type all the addresses in to word (no way around the typing bit, handwritten envelopes won't wash) and then hightlight each address and use the tools - envekopes and labels function to print each one

i'd really like there to be a way I can just click print once and spend my time on More Important Stuff

OP posts:
PurplePidjin · 29/02/2012 13:30

Find out what type of envelopes they are and where the manual feed is on the printer

Enter settings into mail merge wizard

Good luck!!

PurplePidjin · 29/02/2012 13:31

Or put addresses into excel, save, use in word mail merge wizard to print labels?

RhinestoneCowgirl · 29/02/2012 13:31

You can do a mail merge to labels.

Moln · 29/02/2012 15:16

labels to stick on envelopes?

I can't (office procedure , i have to print on the envelope

i remain hopeful that purplePidgen's post means this can be done!

OP posts:
PurplePidjin · 29/02/2012 15:47

It definitely can, I managed to do Christmas cards once, and that would have been Word 97, it was that long ago!

PrisonerOfWaugh · 29/02/2012 15:51

We've got Word 2007 and in the 'Mailings' menu there is actually an 'envelopes' option. Anyway though, envelopes or labels is the same difference - you just need to select the right size then manually feed them in one by one

Moln · 29/02/2012 16:05

OK I'll have a look when I'm next in the office - at the moment I stick the envelopes in the feeder tray and they feed in from there

If it's mail merge then I imagine I'll have to move the address to excel them as the data source?

This is a Good Thing seeing as I've about 100 of the blooming things waiting on me

OP posts:
PurplePidjin · 29/02/2012 16:09

Set up a ss with columns for name, address 1, address 2 and postcode. Save. That's your data source. Envelopes in feeder tray is right, just make sure Word knows how big your envelope is so it centres the address :)

PrisonerOfWaugh · 29/02/2012 16:14

You don't strictly need to use Excel either. In the Word Mailing menu (under Select Recipients I think) there is the option to type a new list - which opens a window like a mini spreadsheet to enter your info.

Moln · 29/02/2012 17:16

Oh I get you with the envelope size now!!

Excellent - will give it a go - you have save me much time thank you (well providing I'm not too much of a stupid head that is!)

OP posts:
PurplePidjin · 29/02/2012 17:24

If i can figure it out you can Grin

New posts on this thread. Refresh page