Devam Ediyor

MS Access Invoicing automatization

Dear Jay,

Few months ago, you held me thru Freelancer to create a MS Access 2007 solution called

MS Access 2007MacroVBA- Export data from query and create Excel books per each customer

where VBA code extracted from a Table data to create a set of MS Excel Book, one book per customer

Each MS Excel book had inside two Sheets with pertinent data for Customer.

Now , is necessary to develop solution a bit more to :

a. Automatically, create one Windows Folder per Customer and name that folder with Customer's name.

b. Put inside each Windows Folder MS Excel books generated from previous solution you made for me.

c. Run a MS Access 2007 Report [ this report is an INVOICE template]

d. Per each customer on Report INVOICE create a PDF file and stored into appropriate Windows Folder .

In short words, solution will make a Folder then put one Excel and one PDF per each Customer

After above process is completed is necessary to create a ZIP file per each customer.

Then using Customers data table which contains email addresses, solution will compose one email and will attach pertinent ZIP file.

To compose email, BCC field is going to be used.

Read Receipt feature for all outgoing emails.

I know Access can create emails and put then into an Outlook 2007 folder ready for dispatch.

Beceriler: Excel, Microsoft Access, Uygulamalar için Visual Basic

Daha fazlasını görün: vba freelancer excel, ms access excel vba, in which field i can freelancer, freelancer zip file, freelancer vba access excel, freelancer's invoice template, freelancer receipt, freelancer read book, freelancer in excel sheets, freelancer folder, freelancer export, customer data excel template, 2007 freelancer, vba create folder, MS Excel 2007, create folder vba, invoice template in excel, invoice for freelancer, export freelancer, excel invoice template , vba freelancer, vba excel pdf, vba access excel, name jay, ms excel template

İşveren Hakkında:
( 77 değerlendirme ) Heredia, Costa Rica

Proje NO: #4400348

Seçilen:

gatsu58

Hired by the Employer

10 gün içinde 130$ USD
(47 Değerlendirme)
4.3