--- title: Multi-Item Document Merge Solution slug: reports/multi-item-document-merge-solution description: Merge multiple items into one document with Unaric Reports multi-item document merge solution. createdAt: 2026-01-30T04:17:11.638Z --- This feature allows you to use a *Burst* report to merge in data from multiple *Source* reports into a personalised document template. For this example, you're going to make a document template called *Account Summary* that will include three merged reports: one for account opportunities, one for account cases, and a list of contacts for all accounts. After that you will make a report with your list of accounts that you will use as your burst report. :::::WorkflowBlock :::WorkflowBlockItem ## Report setup Before creating the Document Merge solution, you have to set up the source reports you want to merge in to the document template. First, create the opportunities report. ![](https://api.archbee.com/api/optimize/10Nod6Ww95R3dPr0k0TCJ/a4vqwPDAS9C3D-yDoCUTg_multi-item-docmerge-schedule-example-opportunity-report.png) Next, create the cases report. ::Image[]{src="https://api.archbee.com/api/optimize/10Nod6Ww95R3dPr0k0TCJ/Che1gyEfQ9uvqIHtipF5a_multi-item-docmerge-schedule-example-case-report.png" size="54" width="679" height="660" position="center" showCaption="false"} After that, create a report that has a list of contacts on it. ::Image[]{src="https://api.archbee.com/api/optimize/10Nod6Ww95R3dPr0k0TCJ/7M9pOAjupN4ctqmMs9uN6_multi-item-docmerge-schedule-example-contact-report.png" size="64" width="304" height="158" position="center" showCaption="false"} Last, make a report that has a list of accounts on it. This is what you will be using as* burst* report. ::Image[]{src="https://api.archbee.com/api/optimize/10Nod6Ww95R3dPr0k0TCJ/8_Ajbtfv3OeaRbnWnw3BA_multi-item-docmerge-schedule-example-account-report.png" size="68" width="600" height="107" position="center" showCaption="false"} ::: ::::WorkflowBlockItem ## Document template setup The second thing we want to do in preparation of making this Solution is to make a document template. The *Account Summary* document will include all three *Source* reports on it. The document template will include 3 key components: Type 2 Tables, Aliased Variables, Burst Variables. For more info on creating Document Templates and what variables to use, see [Templates](docId\:eZsN8KN8JYKpFxKYeV0iZ). ![](https://api.archbee.com/api/optimize/10Nod6Ww95R3dPr0k0TCJ/7SpjKWFo-dx0uEuuY7oO9_multi-item-docmerge-schedule-example-document-template1.png) ![](https://api.archbee.com/api/optimize/10Nod6Ww95R3dPr0k0TCJ/tFn5YGBz6ZmydMfb4g4s7_multi-item-docmerge-schedule-example-document-template2.png) :::CtaButton{label="Download example document template" externalHref="https://reportbuilder.cloud4j.com/Account%20Summary%20Template.docx" openInNewTab="true"} ::: Next you will need to upload your new template to Unaric Reports. 1. Navigate to **Templates > Document.** 2. Click the **Add **button. ![](https://api.archbee.com/api/optimize/10Nod6Ww95R3dPr0k0TCJ/_z7E0-ty4h0okXatiKxVG_add-new-document-template.png) :::: ::::WorkflowBlockItem ## Solution creation Now that we have completed the setup, you're ready to create the Solution. 1. Navigate to **Solutions **and click the **Add **button. ![](https://api.archbee.com/api/optimize/10Nod6Ww95R3dPr0k0TCJ/EV7XO6E9USbkk5ssSuPIu_simple-burst-schedule-add.png) 2. Provide a name for the Solution and preserve the default for** Running User**. ::Image[]{src="https://api.archbee.com/api/optimize/10Nod6Ww95R3dPr0k0TCJ/InSfVLApPHT1zhyzF4c_l_multi-item-docmerge-schedule-example-general-info.png" size="58" width="1100" height="363" position="center" showCaption="false"} 3. On **Items**, you will need to add the following items from the reports and the template previously created: - ***Accounts Report*** as a *Burst *report type. In **Filter Value Field**, select *Account ID*, and *Account Name *as **Name Value Field**. ::Image[]{src="https://api.archbee.com/api/optimize/10Nod6Ww95R3dPr0k0TCJ/rTWCUvF9KeAn_dHpP2G-f_multi-item-docmerge-schedule-example-burst-item.png" size="74" width="1100" height="283" position="center" showCaption="false"} :::Paragraph{listStyleType="disc" indent="2"} ***Opportunities Report*** as a* Source* report type. In **Filter Value Field**, select *Account ID.* ::: ::Image[]{src="https://api.archbee.com/api/optimize/10Nod6Ww95R3dPr0k0TCJ/TNVJtY5F2GRxssVebYaDr_multi-item-docmerge-schedule-example-opportunity-item.png" size="60" width="1100" height="383" position="center" darkWidth="1100" darkHeight="383" showCaption="false"} :::Paragraph{listStyleType="disc" indent="2"} ***Cases Report*** as a *Source* report type. In **Filter Value Field**, select *Account ID. * ::: ::Image[]{src="https://api.archbee.com/api/optimize/10Nod6Ww95R3dPr0k0TCJ/DylmEuEZUBYjVR3ksR0bA_multi-item-docmerge-schedule-example-cases-item.png" size="68" width="1100" height="388" position="center" darkWidth="1100" darkHeight="388" showCaption="false"} :::Paragraph{listStyleType="disc" indent="2"} ***Contacts Report*** as a *Source *report type. In **Filter Value Field**, select *Account ID*. ::: ::Image[]{src="https://api.archbee.com/api/optimize/10Nod6Ww95R3dPr0k0TCJ/UsscSUWgx7C_QdzARIbHF_multi-item-docmerge-schedule-example-contact-item.png" size="70" width="1100" height="371" position="center" darkWidth="1100" darkHeight="371" showCaption="false"} :::Paragraph{listStyleType="disc" indent="2"} ***Account Summary Template*** as a *Document Template. C*hoose **PDF** and** Word** as **File Type**, which defines attachment file output. You can use variables from the **Burst** report in the file name. ::: ::Image[]{src="https://api.archbee.com/api/optimize/10Nod6Ww95R3dPr0k0TCJ/4agJci2ltqfKixjrwSxGU_multi-item-docmerge-schedule-example-document-template-item.png" size="66" width="1100" height="359" position="center" darkWidth="1100" darkHeight="359" showCaption="false"} 4. After setting up all required items, select *No* under ***Add more items?*** and click **Next**. 5. On the** Send** step, select *Email* as delivery option and click** Next**. ::Image[]{src="https://api.archbee.com/api/optimize/10Nod6Ww95R3dPr0k0TCJ/_jgW69E3O0Kalp70ztuGF_burst-scenario-send-options-help.png" size="68" width="1033" height="416" position="center" darkWidth="1033" darkHeight="416" showCaption="false"} 6. On the **Email** step, in **To Fields** select *Account Email* from the dropdown list. For the email itself, make everything static except for the subject line. You can use variables from the *burst* here too. On the right side of the page, you will see available variables for email composition. ::Image[]{src="https://api.archbee.com/api/optimize/10Nod6Ww95R3dPr0k0TCJ/wWT58BdEVZMjB8qRG3bxQ_multi-item-docmerge-schedule-example-email-step.png" size="64" width="1200" height="708" position="center" darkWidth="1200" darkHeight="708" showCaption="false"} 7. After finishing, click **Save **and **Next**. 8. On **Schedule**, to set up this Solution to be sent only once, uncheck the box next to **Schedule **and click **Next**. ::Image[]{src="https://api.archbee.com/api/optimize/10Nod6Ww95R3dPr0k0TCJ/T1tVanAe0JcP_Lm1QZ1wF_marketing-email-schedule-example-schedule.png" size="54" width="550" height="159" position="center" darkWidth="550" darkHeight="159" showCaption="false"} 9. Lastly, on the **Options** step, leave default values and click **Finish**. :::: ::::WorkflowBlockItem ## Solution preview On the Solution's page, click **Preview **to see how the email document will look like for each recipient after merging everything into the template. ::Image[]{src="https://api.archbee.com/api/optimize/10Nod6Ww95R3dPr0k0TCJ/sovvNEIFSvRf9552SC2WH_multi-item-docmerge-schedule-example-preview-hint.png" size="44" width="1100" height="512" darkWidth="1100" darkHeight="512" position="center" showCaption="false"} ::Image[]{src="https://api.archbee.com/api/optimize/10Nod6Ww95R3dPr0k0TCJ/CrFNir0pV-XEgjCruUr2d_multi-item-docmerge-schedule-example-preview-help.png" size="52" width="1100" height="810" position="center" darkWidth="1100" darkHeight="810" showCaption="false"} :::hint{type="success"} If previously added to the email subject, the `{{ACCOUNT.NAME}}` variable will show the name of the account in its place. ::: Here is what the final document looks like with all dynamically populated report data. ::Image[]{src="https://api.archbee.com/api/optimize/10Nod6Ww95R3dPr0k0TCJ/U0uRJqlaj1x-TYbhKBGE2_multi-item-docmerge-schedule-example-final-document-template1.png" size="54" width="1100" height="700" position="center" showCaption="false"} ::Image[]{src="https://api.archbee.com/api/optimize/10Nod6Ww95R3dPr0k0TCJ/SA9m3-ykLa5eCCNdGBYpi_multi-item-docmerge-schedule-example-final-document-template2.png" size="54" width="1100" height="705" position="center" showCaption="false"} :::: :::WorkflowBlockItem ## Run the solution After previewing the Solution and confirming everything looks correct, run the Solution once by clicking the **Run Now**. ::Image[]{src="https://api.archbee.com/api/optimize/10Nod6Ww95R3dPr0k0TCJ/SdOGSobhimdXv5XvlexQ9_multi-item-docmerge-schedule-example-run-now-hint.png" size="52" width="1100" height="512" position="center" showCaption="false"} Once the Solution has run, you can review the Activity to see if there were any issues. To navigate here, scroll down to the bottom of the Solution details page and click the **See All** button on the **Recent Activity** section. ![](https://api.archbee.com/api/optimize/10Nod6Ww95R3dPr0k0TCJ/7j5jcyUb9fEgZlz1EKVRl_marketing-email-schedule-example-activity-hint.png) ::: :::::