Mail Merge & New Record

Originally Posted by lina624

Hello All,

Hoping someone can help me out.

In creating mail merge labels I would like the 'new record' to go from top to bottom - left to right in grid, as opposed to left to right - top to bottom.

Is this even possible?

Hi,

I would doubt that MS Word would do Newspaper Columns on it's Mail Merge, but you could use a helper column (and an formula) to number your rows and sort over that column before feeding the data to Word.

hth
---

added,

note, a formula like

=INT((ROW()-1)/12)+MOD((ROW()-1),4)/100+INT((ROW()-1)/4)/10000

should re-sequence for 12 down and 3 across, but be sure to copy and Paste Special = Values this sequence before sorting.

----

Originally Posted by lina624

Thanks Bryan..... I'm not sure that'll work for me and what I'm trying to do, but I'll test it out.

If anyone else has any suggestions please let me know!!

Thanks!!

Hi,

well it won't work unless your labels are 3 across and 12 deep.

---