Use Excel for simple merged letter

Reuben Schmitz

I am trying to use an Excel document rather than an NXT list to merge letters. Is it better/easier to use an .XLSX or .CSV file for this purpose? And is there a sample flow somewhere that I could use as reference?

Heather McLean

@Dan Snyder - you build most of your flows with Excel instead of SharePoint or NXT Lists, right? Do you have good advice for Reuben or code you can share?

Hallie Guiseppe

I would also be interested in seeing a flow that builds out from an excel file.

Rachel Bailey

Hi @Reuben Schmitz and Community friends. I have posted my organization's “nested if" conditional merge documents (Excel export template with example gifts, Word merge letter template with {IF} coding, and instructions) here if they are helpful to you:

https://community.blackbaud.com/forums/viewtopic/143/57565#p228431

Dan Snyder

@Reuben Schmitz I am sorry to not be able to provide a sample for you or much advice, but if you go the .xlsx route you will likely have to create a table as I believe most actions ask you to identify the table before getting access to any fields. Sorry to not be much help.