Hi Experts, i have developed an access database and coverted it to a runtime version in runtime 2007. The database includes some VBA code to automate the sending of a PDF attachment in an email and works fine on a number of PC's in our office which run XP. As soon as i tried to run this code on a friends machine that is running Vista it didn't work. It opens the report and then just stops......no error message. Any ideas why this is hapenning?
Dim stDocName As String
stDocName = "repInvoiceReport"
DoCmd.OpenReport stDocName, acPreview
DoCmd.SendObject acSendReport, "repInvoiceReport", acFormatPDF, To:=[CustEmail], Subject:="Invoice - " & " " & [CustLName] & " " & [CustSub], MessageText:=[EmailComment]