Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002
    wakefield, ri

    Cool Unanswered: Email using field data

    I have email addresses in a field. I would like to be able to click the field and Outlook open with the email address filled in the To: line and if possible be able to auto fill the subject and message with boilerplate text.

    Any assistance here will be much appreciated.

  2. #2
    Join Date
    Sep 2003
    Try the following,

    Dim stDocName As String

    stDocName = "test Report"
    DoCmd.SendObject acSendReport, stDocName, acFormatRTF,'to name','cc name', , "title of report on subjectline of email", " add message text here"

    refer the sendobject Method for more details:
    DoCmd.SendObject [objecttype][, objectname][, outputformat][, to][, cc][, bcc][, subject][, messagetext][, editmessage][, templatefile]

    You can write the above code on the click event of the command button.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts