Creating a task in Outlook from a date in Excel
 

Not sure you can do this but what I have is a list of potential customers and
next action follow up dates in an excel spreadsheet. Can I apply a task
(within excel) to provide me a reminder to follow that enquiry up on that
specific date. A bit convoluted I know but it's how I am working.
Thanks for now
Jamie

Creating a task in Outlook from a date in Excel
 

Hi Jamie

I think that this is possible, having played with oulook a fair bit. Sadly I
dont run Outlook at work so cannot provide any solid direction. The following
sites have some info on Outlook, that whilst not exactly topical may point
you in the right direction.

http://www.excelkb.com/?cNode=5V1C8G&pNodes=0U7Q0Q
http://www.rondebruin.nl/
http://www.cpearson.com/excel/mainpage.aspx
http://www.mcgimpsey.com/index.html
http://www.contextures.com/tiptech.html

Hope these help

"Jamie@Wildcard" wrote:

Not sure you can do this but what I have is a list of potential customers and
next action follow up dates in an excel spreadsheet. Can I apply a task
(within excel) to provide me a reminder to follow that enquiry up on that
specific date. A bit convoluted I know but it's how I am working.
Thanks for now
Jamie

Creating a task in Outlook from a date in Excel
 

Sorry, I completely misread your question


--
Regards,

Peo Sjoblom



"Peo Sjoblom" wrote in message
...
=IF(cell_with_follow_up_date=TODAY(),"Time to follow up","")

now of course if you are not at the office/workplace etc during that day
it will go blank again the day after, so you might want to use


=IF(cell_with_follow_up_date<=TODAY(),"Time to follow up","")



you can also use conditional formatting and change the colour of the dates
that are due


=cell_with_follow_up_date<=TODAY()



--
Regards,

Peo Sjoblom



"Jamie@Wildcard" wrote in
message ...
Not sure you can do this but what I have is a list of potential customers
and
next action follow up dates in an excel spreadsheet. Can I apply a task
(within excel) to provide me a reminder to follow that enquiry up on that
specific date. A bit convoluted I know but it's how I am working.
Thanks for now
Jamie

Creating a task in Outlook from a date in Excel
 

Thanks for the links I will try and do some more digging. Any chance you
could play around and see if it is possible outside of your office hours.
It's cheeky I know but hey, if you don't ask.....
thanks anyway

"steve_doc" wrote:


Hi Jamie

I think that this is possible, having played with oulook a fair bit. Sadly I
dont run Outlook at work so cannot provide any solid direction. The following
sites have some info on Outlook, that whilst not exactly topical may point
you in the right direction.

http://www.excelkb.com/?cNode=5V1C8G&pNodes=0U7Q0Q
http://www.rondebruin.nl/
http://www.cpearson.com/excel/mainpage.aspx
http://www.mcgimpsey.com/index.html
http://www.contextures.com/tiptech.html

Hope these help

"Jamie@Wildcard" wrote:

Not sure you can do this but what I have is a list of potential customers and
next action follow up dates in an excel spreadsheet. Can I apply a task
(within excel) to provide me a reminder to follow that enquiry up on that
specific date. A bit convoluted I know but it's how I am working.
Thanks for now
Jamie