Pop up message in excel (like outlook agenda)

Marliesjuh Posts 1 Registration date Wednesday December 22, 2010 Status Member Last seen December 22, 2010 - Dec 22, 2010 at 04:22 AM
 GeekMako - Feb 5, 2024 at 09:08 PM

I have a big file in Excel with heaps of information about my customers. One of the coloms is telling me when I need to send them a letter. I would like to have a reminder when this date is reached. The best would be that I get it every hour or every day untill I say I did it so I will never forget.

An other solution will be to link excell with outlook and make automatic tasks.

If anyone knows how to do this please let me know! Thanks in advance.



2 responses

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Dec 23, 2010 at 10:29 AM
Hi Marlies,

This is what I have come up with.

Since you didn't provided any sample data I have used the following:

a	b	23-12-2010	23-12-2010
aa	bb	24-12-2010	
aaa	bbb	23-12-2010	

In which column A is first name, Column B is Last name, Column C is reminder date, D1 is today's date using formula: =TODAY().

Open VB and paste the following code under ThisWorkbook:
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Set MR = Range("C1:C3")
For Each cell In MR
If cell.Value = Range("D1").Value Then MsgBox (cell.Offset(0, -2).Value & " " & cell.Offset(0, -1))
End Sub

When you close your workbook now, you will get message box after message box each with first and last name of the people you need to e-mail.

Best regards,

TROWA - awesome mate - question asked - question answered!

Two-thumbs up!!