ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Mail Merge postcards (https://www.excelbanter.com/excel-discussion-misc-queries/4309-mail-merge-postcards.html)

Terri

Mail Merge postcards
 
I'm trying to do an mail merge to postcards that are 4 cards to 1 8x11 sheet,
everytime I merge I get the same client on all four cards, then on the next
page I'll get the next client on all four card. I want 1 card for each
client not all 4. Is there a way to have 4 clients on 1 sheet?

TheDude

If you're using maile merge on Word and using Excel as the source, you should
have «Next Record» on each cell. It should read something like «Next Record»
««AddressBlock»» after the first cell.




"Terri" wrote:

I'm trying to do an mail merge to postcards that are 4 cards to 1 8x11 sheet,
everytime I merge I get the same client on all four cards, then on the next
page I'll get the next client on all four card. I want 1 card for each
client not all 4. Is there a way to have 4 clients on 1 sheet?



All times are GMT +1. The time now is 09:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com