Open outlook after add

Opening Outlook automatically is not possible. Just imagine all those spammy websites launching your outlook when you visit them.

Good point
Is it possible to have a link/button for the mailto on the add page so after you add your data you can press email and then submit the data?

Yes, it's possible.
Your code should work.

I tried to set it up on the add page so after you type in the data into the form you can press email, then submit the data for the DB and i am getting an error:
This is on the AddOnLoad event and only occurs when clicking Add to get to the Add screen.
Error number -2147217900

Error description [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near '='.

URL /Dispatch_add.asp
The code is:

[codebox]str = "select * from Dispatch where DispatchID = " & Request("addid1")

Set rsTemp = server.CreateObject("ADODB.Recordset")

rsTemp.open str, dbConnection

Response.write "<a href=""mailto:" & dict("Employee") & "?subject=Yoursubject&body=yourbody "">Click to send record info!</a>"[/codebox]
any idea where the error is generating from?

There is no such thing as Request("addid1").
I recommend you to check the following article:

http://www.xlinesoft.com/asprunner/docs/pa...le_overview.htm
This can help you pick correct event for this purpose.

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=23075&image=1&table=forumreplies' class='bbc_emoticon' alt=':D' /> Ok Sergey thank's for pointing me in the right direction!
I think i have a better understanding now.
Basicly i want to put

[codebox]Response.write "<a href=""mailto:" & rs("Employee") & "?subject=Yoursubject&body=yourbody "">Click to send record info!</a>"[/codebox]
(not necesairly that exact code)
On the add page for the convience of my users. I'm thinking the Response.Write <a href...... is good upto the rs("Employee"). Since there is no recordset it being the add page i'm looking for a way to pull the field data and throw it in outlook. Is there a way other than rs("field") to grab the data?
I just tried value_Employee inplace of rs("Employee") and the mailto works it just has that field blank

Use AfterAdd event that have everything you need.

Use AfterAdd event that have everything you need.

Worked Great Thanks!
I do have another small problum, when having the Subject & body be a variable i get a "Expected end of statement" error pointing at the " before >Click to send record info!</a>"
The full code is:
Response.write "<a href=""mailto:" & Dict("Employee") & "?subject=Account:"& Dict("Client")& "&body=test " & Dict("Instruct")">Click to send record info!</a>"
The number of "" seems even any idea whats throwing this error?

All fixed proper syntax is:
[codebox]Response.write "<a href=""mailto:"& Dict("Employee")& "?subject=Account:"& Dict("Client")& "&body=test "& Dict("Instruct")& """>Click to send record info!</a>"[/codebox]
Thanks for your help!