#1
|
|||
|
|||
Two people in same hotel room, one letter
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 |
#2
|
||||
|
||||
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How to send a letter with customized name/ID for a large number of people | Jacob86 | Word | 3 | 04-28-2021 09:09 AM |
Database for hotel issues | joevda | Excel | 4 | 08-01-2017 05:11 AM |
print different letter for different people | mtwa | Mail Merge | 2 | 04-23-2016 09:04 PM |
Creating an info board for a hotel lobby... | dvinson | PowerPoint | 0 | 12-13-2010 09:11 AM |
How to address a letter to 10,000 different people at once. | Bit of a Trip | Word | 0 | 08-13-2010 08:44 AM |