Creating automatic invoices

[PRIYANSHU97]

Hi Members,

I want to create about 100 invoices each month using a single button.
So my sales are being recorded at a day level in excel. At the end of the month, I want to create the invoice for the sales without much effort. Currently, my team copies the data for each client one by one. Is there a method by which I can automate this?
I am familiar with excel and I have used SQL in the past so I think I will be able to write queries.

 

[arthurbr]

Hi
why not use Excel's Mail Merge functionalities ? One of many articles on the subject Introduction to Mail Merge - How to use mail merge to create custom letters, invoices, labels and more from