Print database records in template

Copper Contributor
We have a customer database in excel and I am looking to print each new record added to the database using certain column headings in a template (for job bags to accompany each product we have in). I have no idea how to do this and if indeed this can be done? Any help greatly appreciated!
1 Reply

Hello @Miranda1560 ,

 

your question is a little broad and hard to answer without seeing the data structure.

 

I suggest looking into Word and the Mailings functionality. You could set up a Word document with a Labels setup, then populate the labels with the data from the Excel workbook. In the Excel workbook you can have a column that you use to indicate if a record has been printed with Word yet.

 

You can then use the filter settings in the Word Mailing for the data source to only use records that have not been printed. After each print run you set all the records to "printed" before adding new records.

 

Let me know if that approach helps.