I'm preparing an advertising campaign, and have a great promotional post card in MS Publisher 2007 that I would like have populated with the name and addresses merged from a mailing list I have prepared in Excel. I'm using 4-to-a-page postcard stock, so 4 - 4.25X5.5 inch postcards will come from a single sheet.
Publisher 2007 has a mail merge, but when bringing in the data source (the Excel list), all 4 cards from a single page are populated with the same name/address, with the next name/address populating all 4 cards from the next page.
I haven't figured out how to make the merge work so each name populates only one card, and that 4 cards can be printed from a single page. I would like to avoid the hassle and cost of applying mailing labels to such a large number of cards, and I would like to continue this kind of promotional campaign, so optimization is very important.
Does anyone have an idea how to make this kind of merge work?