Challenging Problem?!

[revmk]

Hello all,

I have a bit of a challenging issue here.

I need to invoice a lot of my customers. I have the invoices in a .html file (I can create the file name to be setup as required), and I need to have these emailed to my clients. As I send these emails once a month (on the same day), I need to run a routine to do this automatically in one go.

Is this possible using a form with a button to run a macro of some description?

For example; --> lookup client number --->lookup .html file called client number + month + year ----> open outlook ----> attach file ----> auto enter email address -----> send ----> update database to say sent -----> repeat until end.

Any suggestions would be most welcomed.

Thanks.

 

[Pat Hartman]

You can do this easily enough with VBA. I wouldn't even consider a macro. The logic would become too convoluted. Basically, you would open a recordset and using .MoveNext, loop through the recordset and send an email for each customer. The biggest hurdle to overcome will be the Outlook security monster. It is going to prompt you for each email to warn you that someone is tring to send mail on your behalf and do you want to allow it. There are various workarounds for this, none of which I have used. Some people use something called "Click Once" or something like that. It is free/shareware and it is a popup that just clicks the OK button for you automatically. Another solution is sold by www.fmsinc.com and it is a much more sophisticated tool that allows you to automate mailings. I suggest that you download their demo and see if it will help you. It might even be able to solve your problem without any VBA coding.