Posts by bperigo

    making duplicate labels with excel and mailmerge


    Thank you Jindon. That formula works fine. Someday I hope to figure out how :) BTW, it seems one needs to put the formula in the 2nd row in order to have a blank in the top position which the Word data file needs to properly feed the merge. I wonder how one could automate the fill down?


    I’d like to paste into one column a set of data e.g.
    F43
    E54
    R22
    F33
    and then enter the number of duplications, e.g. 3, in to a cell which would produce a new column containing for this example,
    F43
    F43
    F43
    E54
    E54
    E54
    R22 etc.
    I’d then copy this new column into Word in order to save as a .dat file to be used to merge print the labels used to store these items.

    Thanks for any help or advise.