I have a form with a person's information on it including email address. I need code that will open Outlook and populate the "To" field with the email address on the form automatically.![]()
I have a form with a person's information on it including email address. I need code that will open Outlook and populate the "To" field with the email address on the form automatically.![]()
you should google it. these examples are plentiful on the web. chances you will get a copy/paste literal block of code on this forum are slim.
dim strTo as string
strTo = me!EmailAddressField
Then utilize the sendobject command
docmd.sendobject.....
ie. DoCmd.SendObject , , , strTo, , , "Email Subject...", "Email Text...", False
see help on the SendObject command for more info.