PDA

View Full Version : Mail Merge help please



dianne pierce
18-12-2011, 04:38 PM
Using excel spreadsheet and word 2010. Problem; when I print an envelope out the address is in the wrong position. I am manually feeding the envelope into the printer faceup (which is the setting I chose) but the address appears on it vertically instead of horizontally - what setting do I choose to correct this. I cannot feed the envelope into the printer acrossways (which would correct the problem) I have to feed it in lengthways.

Snorkbox
19-12-2011, 12:12 AM
Change the printer mode from Portrait to Landscape mode then. Or from Landscape to Portrait.

mikebartnz
19-12-2011, 11:09 AM
Change the printer mode from Portrait to Landscape mode then. Or from Landscape to Portrait.
+1

dianne pierce
19-12-2011, 11:59 AM
Tried both ways, still no go

smurf
19-12-2011, 12:37 PM
Dianne, not sure if this is the same for Word 2010 but in Word 2011 Choose the Mailings tab, click on Envelopes and look down the bottom to choose Options. When the new box opens choose the tab Printing Options. This should then provide a feed option whereby the address should appear as you want it.

dianne pierce
19-12-2011, 08:18 PM
Brian, thanks but that part of the setup is all okay. Looks perfect on preview but when I manually feed the envelope into the printer the address doesn't come out the same. It would if I could put the envelope into the printer widthways but my printer wont allow that as the envelope is too long. I have to put the envelope in lengthways.

Snorkbox
19-12-2011, 08:22 PM
So what sort, Make and Model, printer do you have?

Also what O/S?

dianne pierce
19-12-2011, 08:27 PM
Have a Fuji Xerox Docuprint 203A operating Windows XP Home Edition. Mail merge using Excel into Word 2010.

dianne pierce
19-12-2011, 09:08 PM
Problem solved, many thanks for the help . I inserted the envelope into the printer according to the image shown when setting the print options(which was in the middle of the feed tray). It worked when I inserted the envelope to the far left instead

Snorkbox
19-12-2011, 11:27 PM
Great. Thanks for the feedback.

I had downloaded the manual and was going to suggest something like that.

Or the next question would have been what size envelope do you use?

Anyway it's sorted!!