Excel data merge to create and email tax invoice
$30-250 AUD
Paid on delivery
Dear Coders/Excel experts,
We are wanting to create a data merge from Excel to create a pdf (Tax Invoice) which can be emailed to a client. The Excel document contains a range of dates, client business names and $ amounts representing past monthly transfers.
We need to sort the data based on client name and add each row of data as a separate entry in the respective tax invoice for each of the clients. Each row will show the date, a description (this will simply be "Web Services For #Month#") and an amount. The month can be generated using the respective date - that is 16/03/2015 is March and so on.
On the bottom of the invoice, the total for all invoices will be calculated and displayed.
We can easily generate the excel file from the service we use to process the payments and I will supply an example of a simple tax invoice in word for you to follow.
Once the tax invoice is created, we need to generate a pdf and send to the clients via email. Each client will need to have an email address entered and saved for subsequent use as the excel spreadsheet does not contain that information. That is, on the first attempt to send the pdf to a client without an email address in the system, the system will prompt the user to enter an email address. This will then be saved for subsequent use for that client.
I would like to be able to easily edit the tax invoice master copy...preferably in Word.
Doesn't need to be fancy...just needs to work flawlessly.
Suggestions welcome.
Regards,
Simon
Project ID: #7407118
About the project
Awarded to:
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas and macros. Check my reviews. They speak for themselves. Best regards PS: I More
11 freelancers are bidding on average $174 for this job
I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. I plan to complete the project via writing an Excel macro conta More
Hello employer! I'm NOT a indian bot :D Please check my rate & feedback ;) I have good knowledge and experience of CSS/JQUERY/JQUERY UI & MOBILE/HTML/PHP/MYSQL. Please contact me to talk about the project. Best Re More
As A Microsoft Certified System Administrator I am Excellent in word editing, processing , spread sheets I can very quickly help you with any Microsoft Excel problem, formula(s), or task. I look forward to helping you More
i can build this project with visual basic. it can import data from excel.. and help your work to be running automatically.. this project will finish in 5 day