now it gets complicated, at least for me.
My pdfPrint() macro uses the free program Pdfcreator to copy the INVOICE
worksheet to the tow invoices directory as a pdf file the same time as the
invoice is printed.
I have a macro from the net that will email an excel
but i have not tested it and would much rather email the pdf version instead.
the idea is the the user pushes "print" and an invoice is printed, copied to a database,
and then emailed to my bosses computer at home.
All this without the user knowing or having to press any additional
buttons to make it happen.
so far i am two for three
the saving the excel sheet as pdf and to a folder works fine.
the saving to a database works fine thanks to you.
The reason to send the pdf file is for the unchangible nature of it.
the email subject line could be blank or the invoice number.
the email is "[email protected]
the worksheet i would like to send is the INVOICE2, since it has only one copy
of the invoice on it.