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!

Send us sample files to have a look please

"Stephanieo99" wrote in message
...

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!




--
Stephanieo99

I have attached three documents.

Sept = Test month (this comes from our reservation system)
Property addresses = Table where prop information is stored
Final Result = What I need the finished product to look like so I can merge it to our envelope file in word


Thanks for all your help!

Files missing please.

"Stephanieo99" wrote in message
...

I have attached three documents.

Sept = Test month (this comes from our reservation system)
Property addresses = Table where prop information is stored
Final Result = What I need the finished product to look like so I can
merge it to our envelope file in word


Thanks for all your help!

PY & Associates Wrote:
Send us sample files to have a look please

"Stephanieo99" wrote in
message
...-

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!




--
Stephanieo99-


+-------------------------------------------------------------------+
|Filename: SEPT.TXT |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=78|
|Filename: final Result.txt |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=81|
|Filename: Property Addresses.txt |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=80|
+-------------------------------------------------------------------+



--
Stephanieo99

You can't attach files to this newsgroup.

--

JoAnn Paules
MVP Microsoft [Publisher]




"PY & Associates" wrote in message
...
Files missing please.

"Stephanieo99" wrote in message
...

I have attached three documents.

Sept = Test month (this comes from our reservation system)
Property addresses = Table where prop information is stored
Final Result = What I need the finished product to look like so I can
merge it to our envelope file in word


Thanks for all your help!

PY & Associates Wrote:
Send us sample files to have a look please

"Stephanieo99" wrote in
message
...-

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!




--
Stephanieo99-


+-------------------------------------------------------------------+
|Filename: SEPT.TXT |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=78|
|Filename: final Result.txt |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=81|
|Filename: Property Addresses.txt |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=80|
+-------------------------------------------------------------------+



--
Stephanieo99

JoAnn Paules [MVP] wrote:
You can't attach files to this newsgroup.

The files are accessible via Google Groups. Go to the newsgroup
microsoft.public.excel.newusers.

I would open attachments only by logging into a restricted account, not
an administrator account. When I did that and looked at the files, I
saw "raw" text, not Excel files. In one case, the data is completely
unstructured -- obvious in some input format for something. Good luck!

My suggestion to the OP: hire an Excel consultant. "You get what you
pay for!"

We cannot figure out how you assign properties to each "guest".
Perhaps it is done manually each time.

If we may guess, the workflow should be:
read SEPT.TXT with Excel in sheet1;
read Property Address.txt in sheet2;
in a new column in sheet1, key in property id;
use vlookup to pull in property specifies from sheet2;
export relevant fields in text file to Final Result.txt format.

We believe your service provider can automate this with minimum effort.

Regards
PY & Associates

"Stephanieo99" wrote in message
...

I have attached three documents.

Sept = Test month (this comes from our reservation system)
Property addresses = Table where prop information is stored
Final Result = What I need the finished product to look like so I can
merge it to our envelope file in word


Thanks for all your help!

PY & Associates Wrote:
Send us sample files to have a look please

"Stephanieo99" wrote in
message
...-

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!




--
Stephanieo99-


+-------------------------------------------------------------------+
|Filename: SEPT.TXT |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=78|
|Filename: final Result.txt |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=81|
|Filename: Property Addresses.txt |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=80|
+-------------------------------------------------------------------+



--
Stephanieo99

I have not looked at your files but I may??? have an idea of what you are
trying to do. You may contact me privately.

--
Don Guillett
SalesAid Software

"Stephanieo99" wrote in message
...

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!




--
Stephanieo99

Is there any way I can get you to call me or write my personal e-mail address? I can be reached at 800-521-2515 x2004 (I will be here until 6:30 Mountain Time) or you can reach me at my personal e-mail:


Thanks so much for all your help! If you can help me out I can get you a 20% discount to stay in one of our properties here in Sun Valley!

Quote:

Originally Posted by Don Guillett I have not looked at your files but I may??? have an idea of what you are trying to do. You may contact me privately. -- Don Guillett SalesAid Software "Stephanieo99" wrote in message ... 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! -- Stephanieo99

NEVER, NEVER, NVER post your phone number or unmunged email address!

--

JoAnn Paules
MVP Microsoft [Publisher]




"Stephanieo99" wrote in message
...

Is there any way I can get you to call me or write my personal e-mail
address? I can be reached at XXXXXXXXXX (I will be here until
6:30 Mountain Time) or you can reach me at my personal e-mail:
xxxxxxxxxxxxxxxxxxxx


Thanks so much for all your help! If you can help me out I can get you
a 20% discount to stay in one of our properties here in Sun Valley!

Don Guillett Wrote:
I have not looked at your files but I may??? have an idea of what you
are
trying to do. You may contact me privately.

--
Don Guillett
SalesAid Software

"Stephanieo99" wrote in
message
...-

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!




--
Stephanieo99 -


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+



--
Stephanieo99