Email Command Button

[cardgunner]

I searched the forums, I downloaded sample datbases EmailA2K, example, and PrintCurrentRecord_Update however I cannot get my command button to fill the TO: with my customer email address. I have gotten lost in the code so I went with a send object macro. Maybe it's my internet service. I use Compu Serv which is a by-product of AOL. Can that be the problem? Anyway I don't understand code, I wish I did. I select send object as my action in my macro. I leave the object type and object name blank as well as the output format. In the To: I put = [email address]. In the subject I put "From CG" and the Edit Message is set as "no". When I click on the button it opens up my email provider but nothing is in the To:. I first tried to fill in the Object name and type and format and it attached the records in the form, I DO NOt want to do that. All I want is to have the Email Address be filled in the To: by clicking a button. I'm about 8 hours on this and a little on edge. I would like to get a good nights rest and not think asbout this anymore. Any Macro help would be great.

 

[Smart]

RE : Email Command Button

You can try this

stDocName = "Queryname"
DoCmd.OpenQuery stDocName, acNormal, acEdit
DoCmd.SendObject acSendQuery, "Queryname", acFormatXLS, "j.blogs@home.com",”CC”,”BCC”, "Subject " & Date, "message text", False

you can use a query or report and vary your output format

 

[cardgunner]

Not sure if it will. I don't know how hwere to put the code. But on a good note, I tried how I have it set up now at work with a different email server and it worked just fine. Thank you for your help. For anyone reading this looking to do the same. I set my on Click event in the command button to a macro. The action in the macro set to SendObject.Then in action arguemnts it went:
Object Type:
Object Name:
Output Format: = [Email Address]
Cc:
Bcc:
Subject: From CG to you
Message Text:
Edit Message: Yes
Template File:

This worked good when using Outlook but I could not get it to use my AOL or Compu Serv email provider.