Email function works perfectly for me - but not on another computer

[Gina Maylone]

Hello all,



The email code below works perfectly for me, but not on my clients' computers. What am I missing? All references are set correctly. Using Windows 7 and 8, Office 365 (Access 13). Sorry for the lack of indenting. TIA.

Dim stDocName As String
Dim MyPath As String
MyPath = "C:\abc moving\documents\" & Me.reportname
stDocName = "ConfirmationReport"
DoCmd.OutputTo acReport, stDocName, acFormatPDF, MyPath, True
 
Dim db As DAO.Database
Dim MyOutlook As Outlook.Application
Dim MyMail As Outlook.MailItem
Dim Subjectline As String
 
Set appOutLook = CreateObject("Outlook.Application")
Set MailOutLook = appOutLook.CreateItem(olMailItem)
With MailOutLook
 
Subjectline$ = "Thank you for choosing ABC Moving"
Set db = CurrentDb()
 .To = Forms!moveinformation!EmailAddress
.SentOnBehalfOfName = "chris@abcmoving.com"
If Me.EmailAddress2 <> "" Then
.BCC = Forms!moveinformation!EmailAddress2
End If
.Subject = Subjectline$
If Me.TravelMove = True Then
MyMail.HTMLBody = DLookup("travelmessage", "emailmessages")
Else
MyMail.HTMLBody = DLookup("morningmessage", "emailmessages")
End If
 
.Attachments.Add ("c:\abc moving\documents\Boxes and Packing Supplies.pdf")
.Attachments.Add ("c:\abc moving\documents\Home Packing Tips.pdf")
.Attachments.Add ("c:\abc moving\documents\insurance and agreement.pdf")
.Attachments.Add MyPath
 
.Display
End With

End Sub

[CJ_London]

Not clear what you mean by 'The email code below works perfectly for me, but not on my clients' computers'?

do you get an error message?, nothing happens? system freezes?

what happens when you step through the code on your client's computer?

Are they also using Office 365? If not, you either need to use late binding or set a reference to their version, not yours

do they have the directory "C:\abc moving\documents\"?

[NTC]

perhaps they do not have: MyPath = "C:\abc moving\documents\"

and their outlook client is identical?

[Gina Maylone]

Not clear what you mean by 'The email code below works perfectly for me, but not on my clients' computers'?

do you get an error message?, nothing happens? system freezes?

what happens when you step through the code on your client's computer?

Are they also using Office 365? If not, you either need to use late binding or set a reference to their version, not yours

do they have the directory "C:\abc moving\documents\"?

Sorry - took a bit to collect this information. Yes, they are on Office 365. Yes they have the appropriate directory. Nothing happens following output of the letter. Outlook does not open.

Thank you for taking time to respond!

[Gina Maylone]

they have the correct directory. The only difference in their email vs. mine is they use Exchange. (Still Outlook though).