Advanced Find - use columns from parent customer?

I'd like to set up a query that pulls a list of contacts and their parent
customer's address information. Logically this is so I could send a mailing
out to all employees of certain accounts but send it to the account's mailing
address, not the address of the contact.

Is this possible?

The reason I need to do this is because we store the contact's *personal*
address in their record and the company address in the parent customer's
record. If it is not possible to do the above, how are other people handling
this situation? Duplicating the account address in the contact's record and
storing the personal address under more addresses?

imumar
Thu Aug 30 11:34:01 PDT 2007

Hi Chris,
Yes, it is possible. You need to write a new SRS Report for this purpose.
Remember to use only Filtered Views during the development of Report.

You may contact me directly at my email address if you need any help in this
regard.
--
PLEASE do click on Yes or No button if this post was helpful or not for our
feedback.

uMar Khan
Email for direct contact: imumar at gmail dot com


"Chris" wrote:

> I'd like to set up a query that pulls a list of contacts and their parent
> customer's address information. Logically this is so I could send a mailing
> out to all employees of certain accounts but send it to the account's mailing
> address, not the address of the contact.
>
> Is this possible?
>
> The reason I need to do this is because we store the contact's *personal*
> address in their record and the company address in the parent customer's
> record. If it is not possible to do the above, how are other people handling
> this situation? Duplicating the account address in the contact's record and
> storing the personal address under more addresses?