Sending email via outlook through a Form

[RickSonea]

I want to create a command button in a form that once pushed opens up outlook
and has the email already adressed to my contact list that resides in a
table. I don't want a subject, text or attachment...just the adresses. Can
anyone help??

 

[Carl Rapson]

I want to create a command button in a form that once pushed opens up
outlook
and has the email already adressed to my contact list that resides in a
table. I don't want a subject, text or attachment...just the adresses.
Can
anyone help??

Create an instance of Outlook and populate the address line:

Dim Outlook_Object As Object
Dim Outlook_Message As Object
Dim Message_Recipient As Object

Set Outlook_Object = CreateObject("Outlook.Application")
Set Outlook_Message = Outlook_Object.CreateItem(0)
Set Message_Recipient = Outlook_Message.Recipients.Add("your recipient
list here")

Outlook_Message.Display (True)

Carl Rapson