Emailing from a form

[Alfie]

I've got a form, and I'm trying to set up a way of emailing from it.

Does anyone know, if I've got an email address in a field called
[Phone Number], is there a way that I could create a command button
which, when clicked, would open up an email, with the value from the
phone number field dropped into the To field of the email? It would
only be for phone numbers with a [Phone Type] of 'Email Address'.

I know next to nothing about SQL, so would rather do something using
wizards, but don't know where to start.

I'm working with Office XP Professional, MS Access 2003 and Outlook
2003.

Can anyone help, set me off in the right direction?

[celtic_kiwi]

Have a look at the help for
DoCmd.SendObject

There will be examples in the help file.

If you want to do something more complex search in this group for
Outlook Email Access. This page may be of help.
http://groups-beta.google.com/group/...b4b4eae30437ef

Have fun.

Celtic_Kiwi