You hadn't previously said you wanted both the name and the address in another location. In that case, you will need to change the code. I see that you have now edited post #32 to say that, but that's not what you asked at the time...



Change:
StrDetails = Replace(.DropdownListEntries(i).Value, "|", Chr(11))
to:
StrDetails = .Range.Text & Chr(11) & Replace(.DropdownListEntries(i).Value, "|", Chr(11))

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]

I appreciate your help. But I must still be doing something wrong. I have changed the code and now I am getting this.
Roundhouse Nurseries
Roundhouse Nurseries
Phone: 08 1111 1111
Fax: 08 2222 2222
Email: sales@roundhousenurseries.com.au

But it is still not going into the second location that I need it to go into. Maybe its not possible or I am missing the whole concept, and that's a for sure possibility. I would like to pick a customer from my dropdown list on page one and have it insert into a section on page 2 without having to go and choose the customer from the dropdown list on page 2. Like I said earlier I can get the address to insert just fine on page 2 just not the name. is this something that is possible?