Access 2007 send email using FORM record

[itsmythg]

I currently have a 2007 Access db i use to audit VPN user information. At this time i call a module that opens a report running a query tat requests ID# then opens a word doc with user information and instructions. Trying to eliminate some steps.

I would like to after entering my form information into DB just click button that would create outlook email showing form fields without requerying me again. Also would like the MAC# to be in Subject and need to add default text and hyperlinks too in the email.
[red]My Email fields wanted
«Email»
«MAC#»
«VPNUser»
«LastModified»
«NetworkLogon» [/red]

[blue]My current code:
'------------------------------------------------------------
' SendVPN_RemoteDesktopNotice
'
'------------------------------------------------------------
Function SendVPN_RemoteDesktopNotice()
On Error GoTo SendVPN_RemoteDesktopNotice_Err


DoCmd.SetWarnings False
' User Setup Info
DoCmd.OutputTo acOutputReport, "RemoteDestopSetup", "RichTextFormat(*.rtf)", "c:\temp\Access.rtf", True, "", , acExportQualityScreen

DoCmd.SetWarnings True
[/blue]

All the help i found on this was older versions of office and cannot seem to make work.
Any ideas on a better way to do this appreciated.

 

[RuralGuy]

My favorite email link:

http://www.granite.ab.ca/access/email.htm

(RG for short) aka Allan Bunch MS Access MVP acXP, ac07 ac10 - winXP Pro, Win7 Pro
Please respond to this forum so all may benefit