Hi guys. I have a slight problem, stemming from the fact that I have a little VB experience, but not nearly enough to accomplish this. I was hoping for any ideas/input, with hopefully a little bit of program structure to get me started.
We use Excel to issue quotations to our customers. We want a VB program to identify all quotations that are exactly 2 weeks old, and send a form letter of inquiry (via e-mail) to those customers, based on information in the Excel file. I know enough to get the information I need from the file, but not enough to ID the files that need to be sent, or to actually e-mail them to the customer's e-mail address (which will be in the file comments).
Thanks in advance for any help. Anything at all would be helpful.
We use Excel to issue quotations to our customers. We want a VB program to identify all quotations that are exactly 2 weeks old, and send a form letter of inquiry (via e-mail) to those customers, based on information in the Excel file. I know enough to get the information I need from the file, but not enough to ID the files that need to be sent, or to actually e-mail them to the customer's e-mail address (which will be in the file comments).
Thanks in advance for any help. Anything at all would be helpful.