Hello Vicky,
There are a number of ways around this and it depends on how 'automatic' you
want this to be. You could certainly achieve this with code if you familiar
with a little VBA, but a ShapeSheet answer might also work...
Firstly, for some intro information on both the ShapeSheet you might be
interested in this link:
http://visualsignals.typepad.co.uk/vislog/2007/10/just-for-starte.html
For the ShapeSheet open your Appointment master in the Document stencil and
add a User row named 'TimeDateChanged' and then add the following formula:
DEPENDSON(Prop.visStartTime,Prop.visFinishTime,Prop.visBeginDate)+HYPERLINK("mailto:
[email protected]?Subject=Appointment
change")
This uses the DependsOn function to 'watch' the respective time and date
cells and when a change event fires it will also use the Hyperlink function
to send an email via the current mail client.
You could also expand the formula to add the new date and times in the
subject as follows:
DEPENDSON(Prop.visStartTime,Prop.visFinishTime,Prop.visBeginDate)+HYPERLINK("mailto:
[email protected]?Subject=Appointment
change - "&FORMAT(Prop.visBeginDate,Prop.visBeginDate.Format)&"
("&FORMAT(Prop.visStartTime,Prop.visStartTime.Format)&" to
"&FORMAT(Prop.visFinishTime,Prop.visFinishTime.Format)&")")
If you also have a cell containing the email recipients then you could use
the ampersand symbol to concatenate this into the formula as well.
If you decide to go down the code route then I would probably point you
towards Ron de Bruin's web site where he's done a lot of work on this:
http://www.rondebruin.nl/sendmail.htm (albeit from Excel).
Anyway, I hope that helps but let me know if you have any questions.
Best regards
John
John Goldsmith (Visio MVP)
www.visualSignals.typepad.co.uk
www.visualSignals.co.uk