Results 1 to 5 of 5
  1. #1
    Gina Maylone is offline Always learning
    Windows 7 64bit Access 2013
    Join Date
    Jun 2013
    Location
    Afton, MN
    Posts
    544

    Emailing from access issues on client's computers not mine

    Hello all! I am once again banging my head. I have an email function that works perfectly for me, but everytime I try to implement it at my clients location it fails miserably. We both have Access 2013 with a Sharepoint backend and Outlook 2013. ? Code and error message below.


    Click image for larger version. 

Name:	Capture- gina.PNG 
Views:	11 
Size:	43.2 KB 
ID:	20721
    Code:
    Private Sub Command0_Click()
    Dim olApp As Object
    Dim objMail As Object
    Set olApp = CreateObject("Outlook.Application") 'Create a new instance of Outlook
    'Create e-mail item
    'Set objMail = olApp.CreateItem(olMailItem)
    Set objMail = olApp.CreateItem(0)
    With objMail
    'Set body format to HTML
    '.BodyFormat = olFormatHTML
    .bodyformat = 2
    .To = Me.emailaddress
    .SentOnBehalfOfName = "chris@ABCmoving.com"
    .Subject = "Thank you for choosing ABC Moving"
    .HTMLBody = "Testing body of email function "
    .Save
    .send
    End With
    End Sub


  2. #2
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    If you debug and hover over Me.emailaddress, what is its value?

  3. #3
    Gina Maylone is offline Always learning
    Windows 7 64bit Access 2013
    Join Date
    Jun 2013
    Location
    Afton, MN
    Posts
    544
    Quote Originally Posted by ItsMe View Post
    If you debug and hover over Me.emailaddress, what is its value?
    It's my email address as it should be.

  4. #4
    ItsMe's Avatar
    ItsMe is offline Sometimes Helpful
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2013
    Posts
    7,862
    Aparently the client has a full version of Access. Maybe you can see if early binding is working and test Intellisense with the objMail. So after the line where it is instantiated and before "With" ... type the dot operator after objMail and see if you can access its members.

    Beyond that, the only thing I can think of is a security thing. Did you google the error numbers?

  5. #5
    Gina Maylone is offline Always learning
    Windows 7 64bit Access 2013
    Join Date
    Jun 2013
    Location
    Afton, MN
    Posts
    544
    They are running Access the same way I am, on demand, Office 365. I will try what you suggested tomorrow.

    Yes, googled the error numbers with no luck.

    Thank you so much for your input!!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 1
    Last Post: 05-25-2013, 11:19 AM
  2. Replies: 2
    Last Post: 02-06-2013, 12:52 PM
  3. Replies: 7
    Last Post: 10-18-2012, 06:03 AM
  4. Replies: 3
    Last Post: 04-03-2012, 05:27 PM
  5. Replies: 19
    Last Post: 05-13-2011, 12:36 PM

Tags for this Thread

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