I have been working for good number of days on this "project" and still can't figure it out.
I work for a property management company and we print check in enevelopes for our arriving guests. A prior employee had a convoluted way of performing this using about four different programs... no one in IT can figure it out. I think there is a way to just use excel but my IT dept has given up on us.

Basically, I have a list of properties with their addresses and phone numbers and other property specifics. Each property is assigned a row in this table.

Bi-weekly, I would import the guest information to excel. Each guest is assigned a row in this table.

This is where it is getting tricky for me.

Here's what I would like the result to be:

I would like one field (property code) in the arriving guests table to trigger an auto fill of the next 5 or so boxes in that row with information from the property information table.

I can then easily plug that table into a mail merge file to create our check in envelopes in word. (I know how to do this part already.)

I have tried a number of methods to no avail. Can someone please help? I would like to keep this in excel if possibe but I have also experimented with Access. Since I am the only one in the office with Access on my computer, that will make it tougher for the rest of the employees here.

Thanks in advance for your help!