Access 97 and Outlook

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

I want to put a command button on a form that will open Outlook or Outlook
Expres, populate the To, CC and Subject with addresses contained within a
prepopulated table, also to pick up some values from the form and annotate
them in the email body, can anyone help, all I can do at the moment is to
open the email, without any information or data being picked up.

Some helpful information

Command Button is "Btn_Email"

Form Name is "Main_Menu"
(this is based on a table "Tbl_Main_Data")
(Fields for email body = "Qty", "Matl_Number" and "Ref_Number")

Table containing email addresses is "Tbl_E_Address"
(Fields = "Send_TO" and "CC_TO")

I am relevantly new to Access and would really appreciate some help as I
have tried to code this myself many times but have unfortunately failed.


Thanks in advance


Joe
 
you can use the SendObject action in a macro, or DoCmd.SendObject in VBA.
read up on the topic in Access Help to understand how the arguments work.

hth
 
Back
Top