vba

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

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA

VBA

resolvedResolved · High Priority · Version 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:

The Easiest Way to See a Sum or Average in Excel 2010

Did you know the quickest and most simple way of working out the average or sum of a set of numbers?

Highlight numbers in cells or type some numbers in cells and then look at the status bar at the bottom of the window. Here you will see a display of the average of the numbers, as well as a count of the cells and the sum of these cells.

View all Excel hints and tips


Server loaded in 0.09 secs.