Invitation Mailing Lists - Specific Address Types
We wouldn't want to pull only home addresses for our invitations because many people do receive our mailings at their place of work. Can anyone share with me what you have learned, best practices, and/or advice on this? We recently received a request from a couple who own a business to send all invites to their house. I don't want to completely change our system to accomodate a few people, but if our current system is inherently flawed, then I would feel justified in changing our processes.
Thanks!
Jennifer Broadwell
jennifer.broadwell@pbrf.org
225-763-2646
Comments
-
Jennifer -
We created an address attribute for constituents which allows us to essentially 'override' their preferred address. We mostly do this for the situation you're describing, where the preferred address is business but for solicitations or events we want to send mail to the home address and send to the couple jointly.
So we put an address attribute on the Home address of the constituent as well as their spouse.- Then in Address processing, on the 1 Ind Address tab, in Step 2 make sure you choose Preferred Address AND Home (because the address you export may be either of those two types).
- In Step 3, choose Address Attributes and specify the attribute you've created to mark these addresses.
- In Output, I also like to include this attribute so I can see the situations where this attribute is 'toggling' over the address.
It's not perfect and requires some manual maintenance though --- For example, if you have this attribute on the Home address (which is not their preferred) and then you get a change to their Home address, you have to remember to put this attribute on their new Home address (it won't automatically copy over).
2 -
I've dealt with this by using Additional Addressee Types. When exporting the mailing list, I always export Address Type and "Event Addressee" (or another type, depending on what kind of mailing it is) in addition to Primary Address and Primary Addressee. Then in Excel, I sort by type and cut/paste the proper addressee into the Primary Addressee column. It takes a little time to get used to, but once you do, it's a breeze.2
-
I have used something similar to Gina's Address Attribute in the past. Here, we haven't had this issue. However, I gave up using Primary Addressee/Salutation long ago. Too much to keep up with. And I use MS Access to run mailing lists, so I have a series of Additional Addressees/Salutations (added with Default Sets now, initially with a series of Imports). MS Access looks at the Address Type and then chooses the correct Addr/Sal, just like Daniel does with MS Excel.
So if the Address Type is Home (or Seasonal Home) then it uses Home Addressee and either Home Formal Sal or Home Informal Sal (depending on what my instructions are)...or our CEO's Home Sal. It took a while to get my system set up, but now, other than occasionally tweaking, it's pretty smooth and easy. And when changing the Preferred Address from the Home to Business or vice versa, I don't have to even look at the Addressee/Salutation Tab (or trust anyone else to remember to do so).0 -
Thanks everyone for the awesome answers! I really appreciate your input! What we decided to use an address attribute, which we will export when prepping the list to ensure donors who want invites to go to a certain address are accomodated.
In addition, we're also going to use a solicit code of No Dinner Invite to code certain companies whose primary contact is already on the list bc they meet our other criteria. Once we export, I will remove those companies from the list after sorting by solicit code. This way may get a little hairy in terms of keeping it up to date, but I can easily check the last name of the primary contact with the last name of the others on the list through conditional formatting in Excel. If the primary contact shows up as a dup, I can quickly glance through those to verify those companies need to be removed. I can also check No Dinner Invite companies that DONT have a duplicate primary contact. If they don't have a dup, then that likely means the primary contact changed, and I need to update the solicit code. This code is mainly going to be used as a flag for me to help check to make sure we're not mailing a primary contact twice.
If you guys have a better process, please let me know!0 -
In addition, we're also going to use a solicit code of No Dinner Invite to code certain companies whose primary contact is already on the list bc they meet our other criteria. Once we export, I will remove those companies from the list after sorting by solicit code.
Jennifer - I'd just throw a word of caution about this one thing above. What happens when that primary contact changes? If you've now excluded the company based on a certain primary contact, and that contact changes (which they often do) then you may lose track of what's going on here.
You may instead want to investigate the feature available in Mail -- which has a specific feature for the situation where someone is on the list multiple times, as a individual and as a contact at an organzation - and it lets you decide how you want to handle. You can choose to mail to the individual only, mail to them as the contact at the organization, or both.
And this way, it's nothing that really needs to be maintained with a separate coding schema, but would adapt based on their status as a contact at an organization.
1 -
Gina Gerhard:
In addition, we're also going to use a solicit code of No Dinner Invite to code certain companies whose primary contact is already on the list bc they meet our other criteria. Once we export, I will remove those companies from the list after sorting by solicit code.
Jennifer - I'd just throw a word of caution about this one thing above. What happens when that primary contact changes? If you've now excluded the company based on a certain primary contact, and that contact changes (which they often do) then you may lose track of what's going on here.
You may instead want to investigate the feature available in Mail -- which has a specific feature for the situation where someone is on the list multiple times, as a individual and as a contact at an organzation - and it lets you decide how you want to handle. You can choose to mail to the individual only, mail to them as the contact at the organization, or both.
And this way, it's nothing that really needs to be maintained with a separate coding schema, but would adapt based on their status as a contact at an organization.
yep, you pin pointed my exact concern. I must have misunderstood what that feature in Mail actually did. So, I guess then the proper steps to take would be create the query, feed it into mail, set up all of the appropriate filters, etc., create an output query from that, and use THAT query to pull into the export?
0 -
Yes, there have been some prior discussions on the Forum around this feature, and the fact that it is a somewhat hidden feature and only available in Mail (and not Export).
- I seldom use Mail (because it usually isn't quite robust enough) so who would know that this robust feature sits there?
2
Categories
- All Categories
- Shannon parent
- shannon 2
- shannon 1
- 21 Advocacy DC Users Group
- 14 BBCRM PAG Discussions
- 89 High Education Program Advisory Group (HE PAG)
- 28 Luminate CRM DC Users Group
- 8 DC Luminate CRM Users Group
- Luminate PAG
- 5.9K Blackbaud Altru®
- 58 Blackbaud Award Management™ and Blackbaud Stewardship Management™
- 409 bbcon®
- 2.1K Blackbaud CRM™ and Blackbaud Internet Solutions™
- donorCentrics®
- 1.1K Blackbaud eTapestry®
- 2.8K Blackbaud Financial Edge NXT®
- 1.1K Blackbaud Grantmaking™
- 527 Education Management Solutions for Higher Education
- 1 JustGiving® from Blackbaud®
- 4.6K Education Management Solutions for K-12 Schools
- Blackbaud Luminate Online & Blackbaud TeamRaiser
- 16.4K Blackbaud Raiser's Edge NXT®
- 4.1K SKY Developer
- 547 ResearchPoint™
- 151 Blackbaud Tuition Management™
- 61 everydayhero
- 3 Campaign Ideas
- 58 General Discussion
- 115 Blackbaud ID
- 87 K-12 Blackbaud ID
- 6 Admin Console
- 949 Organizational Best Practices
- 353 The Tap (Just for Fun)
- 235 Blackbaud Community Feedback Forum
- 55 Admissions Event Management EAP
- 18 MobilePay Terminal + BBID Canada EAP
- 36 EAP for New Email Campaigns Experience in Blackbaud Luminate Online®
- 109 EAP for 360 Student Profile in Blackbaud Student Information System
- 41 EAP for Assessment Builder in Blackbaud Learning Management System™
- 9 Technical Preview for SKY API for Blackbaud CRM™ and Blackbaud Altru®
- 55 Community Advisory Group
- 46 Blackbaud Community Ideas
- 26 Blackbaud Community Challenges
- 7 Security Testing Forum
- 3 Blackbaud Staff Discussions
- 1 Blackbaud Partners Discussions
- 1 Blackbaud Giving Search™
- 35 EAP Student Assignment Details and Assignment Center
- 39 EAP Core - Roles and Tasks
- 59 Blackbaud Community All-Stars Discussions
- 20 Blackbaud Raiser's Edge NXT® Online Giving EAP
- Diocesan Blackbaud Raiser’s Edge NXT® User’s Group
- 2 Blackbaud Consultant’s Community
- 43 End of Term Grade Entry EAP
- 92 EAP for Query in Blackbaud Raiser's Edge NXT®
- 38 Standard Reports for Blackbaud Raiser's Edge NXT® EAP
- 12 Payments Assistant for Blackbaud Financial Edge NXT® EAP
- 6 Ask an All Star (Austen Brown)
- 8 Ask an All-Star Alex Wong (Blackbaud Raiser's Edge NXT®)
- 1 Ask an All-Star Alex Wong (Blackbaud Financial Edge NXT®)
- 6 Ask an All-Star (Christine Robertson)
- 21 Ask an Expert (Anthony Gallo)
- Blackbaud Francophone Group
- 22 Ask an Expert (David Springer)
- 4 Raiser's Edge NXT PowerUp Challenge #1 (Query)
- 6 Ask an All-Star Sunshine Reinken Watson and Carlene Johnson
- 4 Raiser's Edge NXT PowerUp Challenge: Events
- 14 Ask an All-Star (Elizabeth Johnson)
- 7 Ask an Expert (Stephen Churchill)
- 2025 ARCHIVED FORUM POSTS
- 322 ARCHIVED | Financial Edge® Tips and Tricks
- 164 ARCHIVED | Raiser's Edge® Blog
- 300 ARCHIVED | Raiser's Edge® Blog
- 441 ARCHIVED | Blackbaud Altru® Tips and Tricks
- 66 ARCHIVED | Blackbaud NetCommunity™ Blog
- 211 ARCHIVED | Blackbaud Target Analytics® Tips and Tricks
- 47 Blackbaud CRM Higher Ed Product Advisory Group (HE PAG)
- Luminate CRM DC Users Group
- 225 ARCHIVED | Blackbaud eTapestry® Tips and Tricks
- 1 Blackbaud eTapestry® Know How Blog
- 19 Blackbaud CRM Product Advisory Group (BBCRM PAG)
- 1 Blackbaud K-12 Education Solutions™ Blog
- 280 ARCHIVED | Mixed Community Announcements
- 3 ARCHIVED | Blackbaud Corporations™ & Blackbaud Foundations™ Hosting Status
- 1 npEngage
- 24 ARCHIVED | K-12 Announcements
- 15 ARCHIVED | FIMS Host*Net Hosting Status
- 23 ARCHIVED | Blackbaud Outcomes & Online Applications (IGAM) Hosting Status
- 22 ARCHIVED | Blackbaud DonorCentral Hosting Status
- 14 ARCHIVED | Blackbaud Grantmaking™ UK Hosting Status
- 117 ARCHIVED | Blackbaud CRM™ and Blackbaud Internet Solutions™ Announcements
- 50 Blackbaud NetCommunity™ Blog
- 169 ARCHIVED | Blackbaud Grantmaking™ Tips and Tricks
- Advocacy DC Users Group
- 718 Community News
- Blackbaud Altru® Hosting Status
- 104 ARCHIVED | Member Spotlight
- 145 ARCHIVED | Hosting Blog
- 149 JustGiving® from Blackbaud® Blog
- 97 ARCHIVED | bbcon® Blogs
- 19 ARCHIVED | Blackbaud Luminate CRM™ Announcements
- 161 Luminate Advocacy News
- 187 Organizational Best Practices Blog
- 67 everydayhero Blog
- 52 Blackbaud SKY® Reporting Announcements
- 17 ARCHIVED | Blackbaud SKY® Reporting for K-12 Announcements
- 3 Luminate Online Product Advisory Group (LO PAG)
- 81 ARCHIVED | JustGiving® from Blackbaud® Tips and Tricks
- 1 ARCHIVED | K-12 Conference Blog
- Blackbaud Church Management™ Announcements
- ARCHIVED | Blackbaud Award Management™ and Blackbaud Stewardship Management™ Announcements
- 1 Blackbaud Peer-to-Peer Fundraising™, Powered by JustGiving® Blogs
- 39 Tips, Tricks, and Timesavers!
- 56 Blackbaud Church Management™ Resources
- 154 Blackbaud Church Management™ Announcements
- 1 ARCHIVED | Blackbaud Church Management™ Tips and Tricks
- 11 ARCHIVED | Blackbaud Higher Education Solutions™ Announcements
- 7 ARCHIVED | Blackbaud Guided Fundraising™ Blog
- 2 Blackbaud Fundraiser Performance Management™ Blog
- 9 Foundations Events and Content
- 14 ARCHIVED | Blog Posts
- 2 ARCHIVED | Blackbaud FIMS™ Announcement and Tips
- 59 Blackbaud Partner Announcements
- 10 ARCHIVED | Blackbaud Impact Edge™ EAP Blogs
- 1 Community Help Blogs
- Diocesan Blackbaud Raiser’s Edge NXT® Users' Group
- Blackbaud Consultant’s Community
- Blackbaud Francophone Group
- 1 BLOG ARCHIVE CATEGORY
- Blackbaud Community™ Discussions
- 8.3K Blackbaud Luminate Online® & Blackbaud TeamRaiser® Discussions
- 5.7K Jobs Board