I have an excel sheet with a list of people in hotel rooms. There are 2 people per room. I want to send a letter using mail merge, but only one. Each person in the room is on a seperate row. the first column is room number. I want the letter to address both individuals. Dear mr. and mrs. smith. Instead of a seperate letter for each. How can i do this easily. I say easily as my skill set is lacking in both excel and word mail merge.

Thank you


Lance