Can Outlook alert me when dates in Excel spreadsheet become curren

S

sue2uk

I have a couple of rental properties abroad and have a simple Excel
spreadsheet with details of the booking, client, deposit paid, date balance
due etc. Is there any way that this can be linked to Outlook as a task or in
the calendar to alert me on the due date to remind me to chase the client for
payment of their balance?
 
S

sue2uk

Thnaks for your reply. I have Excel 2003 SP3, part of Office Professional
2003. I have Business Manager too but haven't had time to see what it does,
but wonder if that would help?
 
D

Diane Poremsky

BCM would give you reminders but its not going to replace the functionality
of Excel (IMHO). I think I'd go with a VBA solution in Excel.
 
S

sue2uk

Ok Many thanks. This is a steep learning curve for me, but I used to be in IT
(pre-children!!) so I think I can cope. I've done a quick google on VBA and
see that it is Visual Basic used in macros in Excel. Have found
http://www.neng.usu.edu/cee/faculty/gurro/VBA&Excel.htm which looks useful
but any info you can give me on how I can get up to speed with this quickly
so I can programme something useful would be much appreciated. Can I do it
within Excel? If so where do I start?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can dates entered Excel be flagged up in Outlook? 7
Can I get Outlook to prompt when dates in Excel files become curre 2
Can I learn VBA quickly and how? 3
Alert on my Desktop or outlook from Excel worksheet on due dates 0
Alert on my outlook from worksheet 0
Triggering an Outlook alert from a date on an Excel Spreadsheet 1
Alert in Microsoft Excel 2
Problem with Excel Dates 21

Top