Re: Visio 2003/ EMails
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:name@isp.com?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:name@isp.com?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
"Vicky" wrote in message
news:C0363F05-B279-4ADF-8228-774D143CF2D4@microsoft.com...
>I was wondering if there was a way to send out automatic emails to the
>person
> that is corresponded to the date as changes are made to the calender.
date: Thu, 11 Sep 2008 09:02:53 +0100
author: John Goldsmith \(Visio MVP\)
