VBA

Resolved · High Priority · Version 2003

Thu 17 Jul 2008, 16:38 Delegate Andrew said...

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?

Fri 25 Jul 2008, 15:08 Trainer Jacob said...

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

	98.7 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

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