Hi Mark,

You could try the following to start:

Place a button on a form and place the following behind the on click event

Dim objApp as New Outlook.Application
Dim objMail as Outlook.MailItem
Dim objRecipient as Object

Set objApp =CreateObject(“Outlook.Application”)
Set objMail = objApp.CreateItem(olMailItem)

With objApp.CreateItem(olMailItem)
   .recipients.add ([Your field here]) '-> could be the textbox on the form
   .cc=”[your field here]” '-> in case of multiple like this "a;b;c" where
a = name of
                                         cc, b=name of cc and so on
   .subject=[Your field here] '-> or subject between " "
   .body = “bodytext of mail” '-> or [your field]
   .attachments.add etc……
   .display ‘-> If you want to see it
   .send ‘-> if you want to send it.

End With

Remember when using Outlook automation from Access when trying to send mail
you will get a warning stating someone is trying to send mail do you wis to
continue. This is an Outlook security issue and must be solved with
redemption. Look for the thread in this NG where this has been discussed
before.

hth