Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

vba

ResolvedVersion 2003

Andrew has attended:
Excel VBA Intro Intermediate course

VBA

I am using VBA to send automatic emails to a list of clients however I need to open the workbook and run this macro only if the corresponding date allocated to these clients has already passed depending on what day the workbook has been opened.
For example I open the workbook and it is 01/07/08 and I have joe bloggs with 30/06/08 next to him so he needs the macro allocated to him, but jane bloggs has 03/07/08 next to her.
How do I choose who should be sent these emails by putting them into a list?

RE: VBA

Hi Andrew

Thanks for your enquiry. This is beyond the scope of being addressed by the forum, however we may be able to assist in a consultative process.

If you can provide more detail, sample files and key objectives you want to acheive we can review and if we can help then provide you with a quote.

Let us know if you wish to further this.

Regards

Jacob

 

Training courses

Training information:

Welcome. Please choose your application (eg. Excel) and then post your question.

Our Microsoft Qualified trainers will then respond within 24 hours (working days).

Frequently Asked Questions
What does 'Resolved' mean?

Any suggestions, questions or comments? Please post in the Improve the forum thread.

Excel tip:

Apply Autosum with keyboard shortcut

If you press Alt and = at the same time, it applies autosum.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.