A B C
1 10/19/23 Name Favorite Color
2 Joe Doe Yellow
3 John Doe Blue
4 Jane Doe Red
5 Jim Doe Black
How can I merge cell A1 into each recipient of a mailmerge that says, "On this date <cellA1> it is stated <Name>'s favorite color is <Favorite Color>."
without having to copy and paste cell A1 in A2, A3, A4, A5 etc.?
I only want to type the date once but have it appear on every merge. Possible?
1 10/19/23 Name Favorite Color
2 Joe Doe Yellow
3 John Doe Blue
4 Jane Doe Red
5 Jim Doe Black
How can I merge cell A1 into each recipient of a mailmerge that says, "On this date <cellA1> it is stated <Name>'s favorite color is <Favorite Color>."
without having to copy and paste cell A1 in A2, A3, A4, A5 etc.?
I only want to type the date once but have it appear on every merge. Possible?
