Hello everyone,
I have been working on automatically creating a receipt for customers that converts to a PDF then emails it to the customers. This project has been taking me about a year (no joke) and I have been to several excel gurus from mrexcel.com with all the help I could get. I now basically have my project completed and have one small issue. When I run my code, I have the PDF created to a certain path and then have my email code (microsoft outlook) attach it to the email. The problem is, sometimes the PDF does not fully create and is in a "waiting" mode of some sort and then sometimes (completely randomly) it will work correctly. It will print and go out of "waiting" mode when I open the pdf creator up (the icon on my desktop). But within my code it will not print because it is in this waiting mode and the code finishes without printing to pfd. This sometimes is not the case and it works perfectly, but only somtimes!! I tried adding in a 5 second pause to my code to maybe give the pdf some time to create, but it doesnt seem to change much. Any help with why this PDFcreator "sometimes" does not finish the print job would be greatly GREATLY appreciated! Thanks!
Sincerely,
Joe