Emailing a report?

[robcvos]

I have a Db for a small home based business. I created an Invoice for them as a report, which they would print and mail. They have asked me to modify the Db so they can email the invoice. Back in the day of Win XP I am sure I did something similar using Outlook express as the client did not use Outlook for their email. Their present OS is Win 7.
Is there an easy way to do this? I right clicked on the report but it wants to use Outlook to generate the email. I am not a seasoned programmer, I get through by trial and lots of errors. Any help would be appreciated.

 

[Ranman256]

In access, have a form with the email and report.
Click a button to
Docmd.sendobject

 

[Eljefegeneo]

If you use Outlook then the simple command will suffice:

DoCmd.SendObject

ObjectType, ObjectName, OutputFormat, To, Cc, Bcc, Subject, MessageText, EditMessage, TemplateFile

If you are not using Outlook, but Gmail or some other email program, then you will have to use more complicate code such as:
http://www.blueclaw-db.com/access_email_gmail.htm
or
https://social.msdn.microsoft.com/F...-from-access-2013-using-gmail?forum=accessdev

 

[Eljefegeneo]

Sorry, the code is:

  [B]DoCmd.SendObject [/B]ObjectType, ObjectName, OutputFormat, To, Cc, Bcc, Subject, MessageText, EditMessage, TemplateFile

 

[robcvos]

Thanks Ranman256 for the reply. I tried the doCmd sendobject, this also seems to open Outlook. I am trying to send the "report" via yahoo or gmail, they have both emial types running on their computer.

Thanks also to Eljefegeneo I will look at the 2 links you sent ..... I will try anything twice sometimes more