Home

Print database records in template

%3CLINGO-SUB%20id%3D%22lingo-sub-745764%22%20slang%3D%22en-US%22%3EPrint%20database%20records%20in%20template%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-745764%22%20slang%3D%22en-US%22%3EWe%20have%20a%20customer%20database%20in%20excel%20and%20I%20am%20looking%20to%20print%20each%20new%20record%20added%20to%20the%20database%20using%20certain%20column%20headings%20in%20a%20template%20(for%20job%20bags%20to%20accompany%20each%20product%20we%20have%20in).%20I%20have%20no%20idea%20how%20to%20do%20this%20and%20if%20indeed%20this%20can%20be%20done%3F%20Any%20help%20greatly%20appreciated!%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-745764%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-746349%22%20slang%3D%22en-US%22%3ERe%3A%20Print%20database%20records%20in%20template%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-746349%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F373579%22%20target%3D%22_blank%22%3E%40Miranda1560%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Eyour%20question%20is%20a%20little%20broad%20and%20hard%20to%20answer%20without%20seeing%20the%20data%20structure.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20suggest%20looking%20into%20Word%20and%20the%20Mailings%20functionality.%20You%20could%20set%20up%20a%20Word%20document%20with%20a%20Labels%20setup%2C%20then%20populate%20the%20labels%20with%20the%20data%20from%20the%20Excel%20workbook.%20In%20the%20Excel%20workbook%20you%20can%20have%20a%20column%20that%20you%20use%20to%20indicate%20if%20a%20record%20has%20been%20printed%20with%20Word%20yet.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20then%20use%20the%20filter%20settings%20in%20the%20Word%20Mailing%20for%20the%20data%20source%20to%20only%20use%20records%20that%20have%20not%20been%20printed.%20After%20each%20print%20run%20you%20set%20all%20the%20records%20to%20%22printed%22%20before%20adding%20new%20records.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELet%20me%20know%20if%20that%20approach%20helps.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Miranda1560
Occasional Visitor
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.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies