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.