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?

Version of Excel? Generally, not without VBA programming.

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
dailytips-subscribe-(E-Mail Removed)

Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:
EMO-NEWSLETTER-SUBSCRIBE-(E-Mail Removed)


"sue2uk" <(E-Mail Removed)> wrote in message
news:0B3B924A-A7FC-4C35-B278-(E-Mail Removed)...
> 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?
>

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?

"Diane Poremsky" wrote:

> Version of Excel? Generally, not without VBA programming.
>
> --
> Diane Poremsky [MVP - Outlook]
> Author, Teach Yourself Outlook 2003 in 24 Hours
> Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
> Outlook 2007: http://www.slipstick.com/outlook/ol2007/
>
> Outlook Tips by email:
> dailytips-subscribe-(E-Mail Removed)
>
> Outlook Tips: http://www.outlook-tips.net/
> Outlook & Exchange Solutions Center: http://www.slipstick.com
> Subscribe to Exchange Messaging Outlook newsletter:
> EMO-NEWSLETTER-SUBSCRIBE-(E-Mail Removed)
>
>
> "sue2uk" <(E-Mail Removed)> wrote in message
> news:0B3B924A-A7FC-4C35-B278-(E-Mail Removed)...
> > 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?
> >

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.

--
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
Outlook 2007: http://www.slipstick.com/outlook/ol2007/

Outlook Tips by email:
dailytips-subscribe-(E-Mail Removed)

Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com
Subscribe to Exchange Messaging Outlook newsletter:
EMO-NEWSLETTER-SUBSCRIBE-(E-Mail Removed)


"sue2uk" <(E-Mail Removed)> wrote in message
news:629DE430-D08B-4C90-B115-(E-Mail Removed)...
> 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?
>
> "Diane Poremsky" wrote:
>
>> Version of Excel? Generally, not without VBA programming.
>>
>> --
>> Diane Poremsky [MVP - Outlook]
>> Author, Teach Yourself Outlook 2003 in 24 Hours
>> Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
>> Outlook 2007: http://www.slipstick.com/outlook/ol2007/
>>
>> Outlook Tips by email:
>> dailytips-subscribe-(E-Mail Removed)
>>
>> Outlook Tips: http://www.outlook-tips.net/
>> Outlook & Exchange Solutions Center: http://www.slipstick.com
>> Subscribe to Exchange Messaging Outlook newsletter:
>> EMO-NEWSLETTER-SUBSCRIBE-(E-Mail Removed)
>>
>>
>> "sue2uk" <(E-Mail Removed)> wrote in message
>> news:0B3B924A-A7FC-4C35-B278-(E-Mail Removed)...
>> > 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?
>> >

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?

"Diane Poremsky" wrote:

> 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.
>
> --
> Diane Poremsky [MVP - Outlook]
> Author, Teach Yourself Outlook 2003 in 24 Hours
> Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
> Outlook 2007: http://www.slipstick.com/outlook/ol2007/
>
> Outlook Tips by email:
> dailytips-subscribe-(E-Mail Removed)
>
> Outlook Tips: http://www.outlook-tips.net/
> Outlook & Exchange Solutions Center: http://www.slipstick.com
> Subscribe to Exchange Messaging Outlook newsletter:
> EMO-NEWSLETTER-SUBSCRIBE-(E-Mail Removed)
>
>
> "sue2uk" <(E-Mail Removed)> wrote in message
> news:629DE430-D08B-4C90-B115-(E-Mail Removed)...
> > 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?
> >
> > "Diane Poremsky" wrote:
> >
> >> Version of Excel? Generally, not without VBA programming.
> >>
> >> --
> >> Diane Poremsky [MVP - Outlook]
> >> Author, Teach Yourself Outlook 2003 in 24 Hours
> >> Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
> >> Outlook 2007: http://www.slipstick.com/outlook/ol2007/
> >>
> >> Outlook Tips by email:
> >> dailytips-subscribe-(E-Mail Removed)
> >>
> >> Outlook Tips: http://www.outlook-tips.net/
> >> Outlook & Exchange Solutions Center: http://www.slipstick.com
> >> Subscribe to Exchange Messaging Outlook newsletter:
> >> EMO-NEWSLETTER-SUBSCRIBE-(E-Mail Removed)
> >>
> >>
> >> "sue2uk" <(E-Mail Removed)> wrote in message
> >> news:0B3B924A-A7FC-4C35-B278-(E-Mail Removed)...
> >> > 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?
> >> >