I have a column in my database which was pulled from an AS/400 database and the date is in the form of "Friday,December 10th,2003" which is unreadable to Access and Excel. I have figured out that ...

This issue occurs when Microsoft Access does not trust the database from which the macro is run. Recent versions of Access open databases that are not trusted in Disabled mode.

Excel can send alerts based on spreadsheet data, but you'll need to write a macro to do it. We'll show you how.