Formula Help

macropod · #7 01-08-2015, 08:49 PM

Quote:

Originally Posted by odonnest

Yes the code works fine, however I want it to distinguish new records from old records that have already been notified.

That's all very well but, as I have already said:

Quote:

Unless you actually add something to the workbook to flag which records have been included in an email, then test the flag state, there is no way your macro can differentiate between those records for which an email has been sent and those for which one hasn't. Of course, if the macro is run periodically (e.g. every 28 days), you could add logic to the code to exclude records for which the expiry date has passed - but that's still not going to resolve everything if the macro is run early and will create other problems if it's run late...

Unless you take either or those approaches, you won't be able to exclude anything.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Formula	Excel	Excel	1	08-14-2014 05:11 PM
Formula Help	withersd46260	Excel	2	04-30-2014 08:33 AM
Formula	muhu	Excel	1	04-14-2014 08:19 AM
What formula should I use?	TotalONE	Excel	3	11-26-2013 01:30 PM
Help with Formula	Corca	Excel	6	02-22-2010 09:40 PM