Using MailTo Protocol in Visio Shapes

A newsgroup question asked whether you can send an email from a Visio shape, so I thought it was time to document an example of just that..

In this example, I have added four Shape Data rows for the Address, Subject, CC and BCC fields…

image

However, I have used the Screen Tip cell for the message body because it is the only out-of-the-box dialog that allows you to enter multi-line text into a Shape Cell.

image

To open the Screen Tip via the right mouse menu, I added the formula =DOCMD(1685) to an Actions row.

To force the Hyperlink.Address cell of the new Hyperlink.Mail row to update whenever any of the values in the four Shape Data rows or the Screen Tip is changed, I added the following formula to a new User-defined cell called, MailToTrigger:

=DEPENDSON(Prop.Address,Prop.Subject,Prop.CC,Prop.BCC,Comment)+SETF(GetRef(Hyperlink.Mail.Address),"=""MailTo:"&Prop.Address&"?Subject="&Prop.Subject&"&CC="&Prop.CC&"&BCC="&Prop.BCC&"&Body="&Comment&"""")

That’s it! Just enter email addresses, a subject and body, then your mail client will be opened pre-filled from the right-mouse menu of the VIsio shape, or, of course, from a SaveAs web page.

You can read about the MailTo protocol here: http://msdn.microsoft.com/en-us/library/aa767737.aspx

Old Trafford in Deep Zoom

Sometimes in life you get opportunities that you just have to take …. and one just came to this old Manchester United supporter … a chance to watch my team play from a corporate box against Arsenal … and I could take my son, Krysh, too!  We only needed a draw to win the Premier League (again) … and a draw is what we got! Like an earlier post, I took lots of photos and patched them together using Microsoft Image Composite Editor.  I love that tool!

Just in case you have never heard of Old Trafford .. it is in Manchester, England … just here:

Map picture

 

I last went to Old Trafford over 20 years ago … it didn’t look like this then …  this is the East Stand.

image

Here is the Deep Zoom version : Old Trafford East Stand

image

Here is the Deep Zoom version : Old Trafford Pre Kick Off

image

Here is the Deep Zoom version : During the match

The match was 0-0, but that was enough to be presented with the Barclay’s Premier League title for the 3rd consecutive year … that’s 18 in total!

ManUtdChampions2009

Thank you to everyone who made it such a great day!

OldTraffordBox 

(PS : You missed a great day, Tim)

An Interview on TechNet about Visio

I was interviewed by Microsoft when I was at the MVP conference in March. I rambled on about some of my experiences with Visio over the years.  It has now been published for all to see at http://edge.technet.com/Media/Visio-Drawing-on-Experience-with-David-Parker/ 

image

In case you are wondering, the shirt was from the 1998 Visio Conference, which was pre-Microsoft.  It’s probably time that I had a new wardrobe!

Seattle Trip May 2009

I went to see the latest version of Visio last week at Microsoft Campus in Redmond, but, as usual, chose to stay in Seattle because it is such a great city.  I love to walk down to Pike Place market in the morning to ponder over which specialist food to select, or to smell the flowers as they are arranged for the day’s pickings.  So, with a piroshky (Russian pastry) and coffee I strolled to the little park at the end to contemplate the day.  The view across Puget Sound is fantastic and I wanted to capture it to share with my friends.  I only have a handy little digital camera, but fortunately, I recently became aware of a handy little application called Microsoft Image Composite Editor (http://research.microsoft.com/en-us/um/redmond/groups/ivm/ICE/ ) .  MICE patches your photos together to make a larger panorama, and then you can export it into many different formats.

I have saved four panoramas for viewing using Deep Zoom in Silverlight 2.

Seattle Trip May 2009
Seattle Trip May 2009

I have shared the collection on Live Maps (I think this only works if you are signed in): http://maps.live.com/default.aspx?v=2&FORM=LMLTCC&cp=47.577559~-122.091288&style=r&lvl=11&tilt=-90&dir=0&alt=-1000&phx=0&phy=0&phscl=1&cid=3350D61BC93733A9!1505&encType=1

I have also used the 3D Map Tour feature in Live Maps to create a short movie showing the location of the panorama positions:

3D tour of panorama placemarks

 

Victor Steinbrueck Park

I didn’t know the name of the little park at the end of Pike Place until I looked it up on Live Maps

VictorSteinbrueckPark

View the panorama here : http://www.bvisual.net/views/VictorSteinbrueckPark.html

The Moore Hotel

As far as I know, this is the only listed hotel in Seattle.

TheMooreHotel

View the panorama here : http://www.bvisual.net/views/TheMooreHotel.html

Snoqualmie Falls

After visiting two wineries on Saturday, I eventually made it to the waterfall that is 100ft higher than Niagara, and featured in David Lynch’s Twin Peaks.

SnoqualmieFalls

View the panorama here : http://www.bvisual.net/views/TheFalls.html

Yellow Lake, Sammamish

I visited my friend Richard Smith and his lovely family out in Sammamish and went for a walk around their local lake.

YellowLake

View the panorama here : http://www.bvisual.net/views/YellowLake.html

Follow

Get every new post delivered to your Inbox.

Join 204 other followers