View original (French)

Vertical and Horizontal Text Mail Merge

Solved
hysis1027 Posted messages 2 Status Member -  
hysis1027 Posted messages 2 Status Member -
Hello,

I want to create labels for a binder, with the classification number written horizontally and the label written vertically. Excel database has 2 columns.
I've created a Word file in portrait orientation with 4 columns and 4 rows (rows 1 and 3 for the classification number).
During the merge, the 1st line correctly contains the first 4 numbers from A2 to A5, then everything shifts, the 2nd line contains the label from B6 to B9, the 3rd line the numbers from A10 to A13, and the 4th B14 to B17.

Can someone help me?

1 answer

  1.
    Argitxu Posted messages 5292 Registration date   Status Contributor Last intervention   4 843
     
    Hello

    "I created a portrait Word file with 4 columns and 4 rows (row 1 and 3 for the ranking number).     "

    A Word merge brings the same merge fields onto each label.
    There’s no point in asking Word to alternate every other line.

    If this workaround is intended to integrate horizontal/vertical, you will need to format each label this way. Maybe it’s not simple, but you won’t have a choice

    --
    Argitxu
    0
    1. hysis1027 Posted messages 2 Status Member
       
      I don't understand your answer, but thank you anyway :-)

      I ended up modifying my labels by creating a landscape file, with 4 columns (Title - Number - Title - Number) and the necessary number of rows, and putting "Record Following" at the beginning of the title of the 2nd label from the 1st row to the last.

      And it works!!! :-))))
      0