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

With the data set out as indicated, then provided you have separate fields for title and both parties have the same surname, you could use Merge Many To One to create the letters.
Sort the data on the number field then use

Dear { MERGEFIELD "Title" } { MERGEFIELD Last_Name }
and select Title as the child field and 'and' as the child field separator

It would make it a much simpler process if you modified the data (or derived a new worksheet) to have the occupancy data on a separate line for each room i.e. instead of having separate lines for each occupant, you have separate lines for each room. Then it becomes a simple letter merge with the second occupant optionally inserted into the salutation.

__________________
Graham Mayor - MS MVP (Word) (2002-2019)
Visit my web site for more programming tips and ready made processes www.gmayor.com