I am trying to find the best way to send emails to our clients and attach an inspection report that been generated as a PDF.
I have a CSV file that contains our client details and I want to set something up that does an email merge with the attachment. It is something I want to be able to schedule if possible.
Is there any programs that are reliable?
The only way I have thought of is the sending emails from excel using VBA. Then scheduling an script to run an macro in the spreadsheet to send the emails.
This process works but you need to have outlook open on the server and sometimes the spreadsheet gets locked and then hangs.
I am open to suggestion...