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 offline 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 offline 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