Code for sending reminder emails by approaching deadline

[maximm11]

Hi there,

I am starting my business and have created an excel task list. To simplify the management, I would like to get a reminder Email at the due date.
This is how the points look:


A B C D E F G H I K M N O P
"Prio" "Topic" "Country" "Task" "Info" "R.Pers" "From" "Start Task" "Last discussion" "Progress" "in report" "Status" "Deadline" "email"

Now I would like to receive the following information in an email that will be send to P (email) at the date of the deadline (O):
B = Topic
D = Task
E = Info

Can you provide me with the formula so I can only copy it?


Thank you so much and have a wonderful day.
Max

[chin67326]

Read and experiment with the two links below:

http://www.excelforum.com/excel-prog...d-in-file.html

http://www.rondebruin.nl/win/s1/outlook/bmail9.htm

Those should get you going; perhaps start a workbook (without personal information) with the columns laid out how you want them, include any buttons etc. and upload it here. Someone may be able to assist further then. Help us by doing some leg-work and upload something so we can try to help you!

[maximm11]

Thank you for your help.

I will try it,

Best regards,
Max