email command button using contents of separate field

[domk]

I'm trying to make a command button in an Access form which opens Outlook Express with the contents of the field 'email' as the 'to' box on the mail agent. I tried a macro with SendObject and then put in the to: box , but it translated that literally and opened Outlook Express with " [email] " in the to: box!!!

Do you know how I can do a SendObject but referring to the variable contents of the field 'email' ? Can I use a macro or do I have to resort to code?
____

Dom from the UK

 

[braindead2]

if you did this via a macro then I believe you need to refer to the field like
forms!nameofform!