Page 2 of 2 FirstFirst 12
Results 16 to 22 of 22
  1. #16
    Danzig's Avatar
    Danzig is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2010
    Location
    Socal
    Posts
    29
    Too large, it wont let me.

  2. #17
    Danzig's Avatar
    Danzig is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2010
    Location
    Socal
    Posts
    29
    Is this right?
    This is what the code looks like on the form:

    Again, the red means it was highlighted. This time in yellow with an arrow...

    Option Compare Database
    Option Explicit
    Private Sub cmdContact_Click()
    Call AddContact( _
    Me.Client, Me.LastName, Me.Address, _
    Me.City, Me.State, Me.PostalCode, Me.Email)
    End Sub
    Private Sub cmdEmail_Click()
    Call SendEmail(Me.Email)
    End Sub
    Private Sub Email_Change()
    Call HandleEnabling(Me.Email.Text, Me.Client)
    End Sub
    Private Sub Client_Change()
    Call HandleEnabling(Me.Email, Me.Client.Text)
    End Sub
    Private Sub Form_Current()
    Call HandleEnabling(Me.Email, Me.Client)
    End Sub
    Private Sub HandleEnabling( _
    varEmail As Variant, varClient As Variant)
    cmdEmail.Enabled = Len(varEmail & "") > 0
    ' cmdContact.Enabled = Len(varClient & "") > 0
    End Sub

  3. #18
    Danzig's Avatar
    Danzig is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2010
    Location
    Socal
    Posts
    29
    So I figured out how to get into the the references.

    So it opens outlook, but it emails it to the prospect, not the client.

    How do I change which field I want it to send to?

  4. #19
    Danzig's Avatar
    Danzig is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2010
    Location
    Socal
    Posts
    29
    so i figured out how to get into prefenences.

    It now opens outlook, but it is sending it to the prospect email not client email.

    How do I change which field it send the email to?

  5. #20
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,641
    You're specifying the email here:

    Call SendEmail(Me.Email)

    Perhaps you want to use a different field/control.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  6. #21
    Danzig's Avatar
    Danzig is offline Novice
    Windows XP Access 2007
    Join Date
    Oct 2010
    Location
    Socal
    Posts
    29
    Nice! Thank you! I just changed that to ClientEmail & it worked.

    Last thing I need to do is have it send the form as an attachment when I click the button.

  7. #22
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,641
    This has the code required to send an attachment:

    http://support.microsoft.com/?kbid=161088

    You'd have to have made a PDF or something to attach. You can try SendObject to send the form, though generally you wouldn't send a form. You have a lot more control over the look of a report.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Email button.
    By emccalment in forum Access
    Replies: 3
    Last Post: 02-19-2010, 04:14 PM
  2. Replies: 6
    Last Post: 02-09-2010, 07:53 AM
  3. Access email button messing up numbers
    By ninjafly in forum Reports
    Replies: 3
    Last Post: 08-20-2009, 04:27 AM
  4. email contact button
    By nwalke in forum Programming
    Replies: 3
    Last Post: 07-02-2009, 07:11 AM
  5. email button in form
    By peterinbristol in forum Forms
    Replies: 0
    Last Post: 03-19-2007, 02:25 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums