a way to export organizations' contact addr. data and constituent primary AddrImpID?

Lee Newcomb · May 2018

I get mail updates from the mail service every newsletter. When available, active contacts of organizations are sent the mailing instead of the org. However, when the org. has relocated, I currently do an export of ConsIDs (always included in exports) & each org's primary address AddrImpIDs, copy the output .csv to the mailed .csv, & use MSExcel's VLOOKUP to have both the org's & contact's AddrImpIDs.

Is there a way to get BOTH of these in the initial export & save at least a half hour of time?

Thanks in advance, Lee

Stephanie Crawley · May 2018

Lee Newcomb:

I get mail updates from the mail service every newsletter. When available, active contacts of organizations are sent the mailing instead of the org. However, when the org. has relocated, I currently do an export of ConsIDs (always included in exports) & each org's primary address AddrImpIDs, copy the output .csv to the mailed .csv, & use MSExcel's VLOOKUP to have both the org's & contact's AddrImpIDs.

Is there a way to get BOTH of these in the initial export & save at least a half hour of time?

Thanks in advance, Lee

I assume when you say primary address you mean "Preferred Address," yes? If so, then in a Constituent Export, I believe you simply go to Address>Preferred Address>Import ID to export the Constituents' AddrImpIDs. Have you tried that and it didn't work?

Lee Newcomb · May 2018

So obvious

By exporting the contacts' addr.'s, I thought the Pref. Addr. would also just give the contact addr. No so!

Thank you for your help! Lee

Stephanie Crawley · May 2018

Glad I could point you in the right direction.

a way to export organizations' contact addr. data and constituent primary AddrImpID?

Comments

Categories