Delen via


Document Merge

SharePoint Document and Mail Merge is the simple, fast and clean way to merge SharePoint list data into predefined Word, Excel and PowerPoint document templates with NO CODE!

This connector is available in the following products and regions:

Service Class Regions
Logic Apps Standard All Logic Apps regions except the following:
     -   Azure Government regions
     -   Azure China regions
     -   US Department of Defense (DoD)
Power Automate Premium All Power Automate regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Power Apps Premium All Power Apps regions except the following:
     -   US Government (GCC)
     -   US Government (GCC High)
     -   China Cloud operated by 21Vianet
     -   US Department of Defense (DoD)
Contact
Name APPS 365 LTD
URL https://apps365ltd.com/support
Email support@apps365ltd.com
Connector Metadata
Publisher CIRRUS SOFT LTD
Website https://sharepointdocumentmerge.com/
Privacy Policy https://sharepointdocumentmerge.com/privacy.php
Categories Content and Files;Productivity

SharePoint Document and Mail Merge is the simple, fast and clean way to merge SharePoint list data into predefined Word, Excel and PowerPoint document templates with NO CODE!

Prerequisites

To use Document Merge, you need to have a valid license with Document Merge. Please visit Document Merge and acquire required license.

How to get credentials

To get credentials, you need to subscribe for a valid license of Document Merge from Sharepoint Document Merge.

Get started with your connector

Acquire license from the Document Merge website and start to merge SharePoint list data into predefined MS Office document templates with NO CODE!

Known issues and limitations

No known issues or limitations

Common errors and remedies

None has been identified yet.

FAQ

Question: How does SharePoint Document Merge Work? Answer: After you have added the SharePoint Document Merge Solution, the Document Merge Option will now be available for all list items and Word documents within document libraries.

Create your Word, Excel or PowerPoint document template/s with the layout as required. Use the List Column Internal Name as Merge Field Name (Word) or Place holder (Excel, PowerPoint) where you want the list data to appear in the document template.

With SharePoint Document Merge you can now automatically create documents from any list for any predefined document template directly from the Ribbon Menu (SharePoint Document Merge) or list items Context Menu.

Create a selection of merged Documents by selecting multiple list items and clicking on the 'Merge Selected Items' option from the Ribbon Menu or utilise the 'Bulk List Merge' to automatically generate a document for the entire list.

Select multiple Word documents to merge to a single Word document from within a document library. The selected documents will be automatically appended in the order selected.

Customise the file name and specify the SharePoint document library to store the automatically generated merged documents.

Question: What are the SharePoint Document Merge Uses? Answer: Do you collect customer records, financial data, order information, or any other important business data in SharePoint lists? With SharePoint Document Merge you can swiftly merge this data into Word and Excel document templates with absolutely no coding!

Generate contracts, personalised letters to prospects, marketing materials, personalised policies, quotes, invoices, financial reports, project status reports, Presentations and get your SharePoint list data in Word, Excel or PowerPoint where you can really work with your data.

Question: What are the Benefits of SharePoint Document Merge? Answer: Merge any SharePoint list data into Word, Excel and PowerPoint Templates with NO CODING! Fast, save data entry time and increase productivity. Very easy to install. Very easy to use, no training required. Tightly integrated into SharePoint. Easy access via Ribbon Menu and Items Context Menu. Simple Template Creation using Merge Field (Word) or Placeholders (Excel, PowerPoint).

Question: Do I get free support in case stuck anywhere while configuring the connector? Answer: Yes, you can log a ticket to APPS 365 Support

Throttling Limits

Name Calls Renewal Period
API calls per connection 100 60 seconds

Actions

Document Merge

Document Merge

Document Merge

Document Merge

Parameters

Name Key Required Type Description
Link To Item
LinkToItem True string

Select the Link to item option from Dynamic content - see manual for help - www.documentmerge.com

Pre-Config Template
PreConfigTemplate string

Available when the Document and Mail Merge Add-In is installed - www.documentmerge.com

Source
Source string

Set the path to the source document Template e.g. "LibraryName\TemaplateName.docx"

Destination
Destination string

The Library name to store generated document

Save as PDF
SaveAsPDF boolean

Set to save an accompany PDF file

Save as PDF only
SaveAsPDFOnly boolean

Set to save only a PDF file no accompanying document

Save as PDF/A
SaveAsPDFA boolean

Set to save PDF file as PDF\A format

Display Image
DisplayImage boolean

Will display Image instead of hyperlink of image

Output file name
OutputFileName string

The name to save the file - can include list internal column names - see manual www.documentmerge.com

Overwrite
OverWrite boolean

Overwrite the document if same name

Send mail
SendMail boolean

Available when the Document and Mail Merge Add-In is installed

Mail template
MailTemplate string

Specify if Send Mail Option selected e.g. "TemplateTitleName"

Returns

Name Path Type Description
message
message string

message

URL
URL string

URL