cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Mail Merge 2k + letters

Is it possible with Nintex Drawloop to create a mail merge of over 2k contact records to send membership letters out via a Salesforce report? What would be the steps? 

Labels: (1)
0 Kudos
Reply
1 Reply
Workflow Hero

Re: Mail Merge 2k + letters

Bev,

Do you mean to use a Salesforce report as the underlying data source in lieu of a database table or SharePoint list?  From my initial test it does not seem possible to use a Salesforce Report as the datasource.  You should check with Nintex support about this to be certain.

However, you could use the Salesforce "Query Record" and "Retrieve Record" actions to accomplish a mail merge using Salesforce data.  Use the Query Record action to fetch which records you wish to work with.  (You will need to specify the API names for the objects (e.g. Contact or Account) and for the field names that you wish to filter on.)  The Query Record action will return a collection of Record IDs.

You can then iterate on each Record ID in Collection variable using a For Each action.  Within the For Each action, do the following:

  1. Use the "Retrieve Record" action to specify the current RecordID value, as this can return all field names and values for that record within collection variables.  
  2. Assign the specific field values that you want in the document from the collection into unique variables.  
  3. Use the Document Generation action to format your document template.  This action will allow you to open the document template in MS Word and insert tokens for the variables that you configure in step 2.

Which SharePoint platform are you using (Office 365 or SharePoint 2013/2016)?  Note that the specific configuration of the Salesforce actions and the Document Generation action is different for Nintex for O365 compared to the on-prem editions. If you are using N4O365, you'll need the Saleforce Security Token, which is not needed for On-prem.

Hope this helps.

0 Kudos
Accept as Solution Reply