ExcelBanter - Mail merge from excel to word SUCKS

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Mail merge from excel to word SUCKS (https://www.excelbanter.com/excel-discussion-misc-queries/266622-mail-merge-excel-word-sucks.html)

danny1234

Mail merge from excel to word SUCKS

Hello,

I have a excel sheet and I just want to print labels on a a4 page with 3 columns and 5 rows.

This seems to be impossible with WORD 2007. I use mail merge, select the data source, but whatever size i give for the labels, IT ALWAYS PRINTS EACH RESULT PER PAGE.

And the preview is per page also, whatever I do.

Can someone please help me out?

TabooCheddar

I messed around with this for a while before my wife figured it out. Before hitting the "Preview Results" button, make sure you hit "Update Labels". Then click "Preview Results" to make sure all of the labels are filled in, not just the first one on each page.

Amandabui252

ThÃ´ng tin khÃ¡ bá»• Ã*ch, mong má»i ngÆ°á»i sáº½ Ä‘Ã³ng gÃ³p nhiá»u hÆ¡n thÃ´ng tin dáº¡ng nhÆ° tháº¿ nÃ*y Ä‘á»ƒ forum thÃªm pháº§n Ä‘a dáº¡ng.

Luannguyen992

Thanks bÃ¡c, giá» mÃ¬nh má»›i biáº¿t Ä‘áº¿n thÃ´ng tin há»¯u Ã*ch nÃ*y. Ai cÃ³ nhá»¯ng thÃ´ng tin dáº¡ng nhÆ° tháº¿ nÃ*y post lÃªn cho má»i ngÆ°á»i cÃ¹ng tham kháº£o luÃ´n nhÃ©. Äang ráº¥t quan tÃ¢m

Amandabui252

Luannguyen992

Sandytran144

All times are GMT +1. The time now is 02:40 PM.