VBA to Send email from Access

[ped]

Hi I need help with VBA to Send email from Access.



I want to be able to send email and in the body i want the my table be pasted in email body...

Is that possible?

Thanks in advance.

[TheShabz]

Access itself will not send an email. What you can do is control Outlook to do it for you. See if this helps you.

https://www.accessforums.net/code-re...mple-7550.html

[ped]

TheShabz, thanks for quick reply...
I have several codes to send email though access using outlook...
I want to know if we can make some kind of HTML table in the email body using my recordsets

Thanks.

[TheShabz]

It would probably be done as an OLE object but I'm not very familiar with them. Hopefully someone else can chime in.

Although, it might be simpler to export your recordset to excel and attach the xls.