email notification with proper format

[joshynaresh]

Hi,



I am using

    DoCmd.SendObject acQuery, "InsuranceTable Query", "Excel97-Excel2003Workbook(*.xls)", Me.E_mail.Value, "", "", "Insurance Renewal List", "Dear Sir,     Plz renewal the attached list    Thanks and Regareds LoanAPP  ", False, ""

and i got 2 problem.
1. msgbox appear to acess or deny to send email.
2. Email massage sent in one line rather then proper formate i.e
"Dear Sir, Plz renewal the attached list Thanks and Regareds LoanAPP"
but i needed
"Dear Sir,

Plz renewal the attached list

Thanks and Regareds
LoanAPP"

[June7]

1. I don't get this warning message. Had to go into Outlook: File > Options > Programmatic Access > Never warn me about suspicious activity.

2. Try: "Dear Sir," & vbCrLf & vbCrLf & "Please renew the attached list." & vbCrLf & vbCrLf & "Thanks and Regards" & vbCrLf "LoanAPP"

[joshynaresh]

Thank You june7. 2nd problem solved but 1st problem has not solved.
I have tried but same problem exist.

[June7]

Got to office and double-checked that setting in my Outlook. Has "Warn me about suspicious activity when my antivirus software is inactive or out-of-date (recommended)" selected.

Bing: Access VBA Outlook warning

http://msdn.microsoft.com/en-us/libr...ffice.10).aspx

http://www.everythingaccess.com/tuto...curity-Warning

[joshynaresh]

Is there any other way to send e-mail with attachment of Access Object like as Sendobject do?

[June7]

Just realized I don't use the SendObject method. Maybe that's why I don't get the warning.

I use code that opens an Outlook object and manipulates the object. https://www.accessforums.net/program...ook-21903.html
Email is common topic. Search forum for more examples.

If you want to avoid Outlook use CDO (Collaboration Data Object). Review https://www.accessforums.net/access/...nding-216.html

Would have to save the query as PDF or Excel file then attach the external file. Use OutputTo method to save file.