Access 2010 on Windows10
I am using vba to save a report to pdf and then send it as an email attachment in outlook. My problem is that the pdf is not fully created before the e-mail is sent. Is there a neat way to make sure the pdf creation is completed before the code continues to execute.
On the web there are suggestions such as using Do loops or Wait or executing the pdf creation in a subroutine but none of these help - other suggestions involve using C++ code that is beyond my skill set.
I am using vba to save a report to pdf and then send it as an email attachment in outlook. My problem is that the pdf is not fully created before the e-mail is sent. Is there a neat way to make sure the pdf creation is completed before the code continues to execute.
On the web there are suggestions such as using Do loops or Wait or executing the pdf creation in a subroutine but none of these help - other suggestions involve using C++ code that is beyond my skill set.