We currently create our donor research profiles in Word and attach them as Files to Account records. The profile contains Contact info (name, email, phone, mailing address), some giving history, and data from external sources. We would like to transition this to Salesforce. My preliminary idea is a custom object with fields for data that doesn't already live somewhere else, then some sort of mail merge tool (we have Apsona) that merges it all together in one document. Has anyone built anything like this,or used a third party tool they recommend?
We are on NPSP with no immediate plans to move to NPC.
@Nonprofit Success Pack #Nonprofit Success PackThis was one of the first things I set up at my current role when I joined, and we admittedly haven't used it in years, but I went the Visualforce render as PDF route. Link from Account, pulls in Household fields and a couple related lists. A mail merge template definitely seems like a more sustainable approach esp since you have the tools already!
