How to send an email from Access

[neilou]

Hi,

I'm doing a CRM database via MS Access and I have several clients with an email address.
I would like to create a command with which I can open a Outlook window. The client's email is already given. I'll just have to write the content of the email.

Please help.
Thanks,
Neila.

BTW: Does anyone know how to send a personnalised mailing from access by email? Do I have to create a report?

 

[vbsgtd]

you can use the docmd.sendobject
you do not need to include any attachment and you can customize the messsage,subject recipients and so forth

accesss help will show you what to use for each parameter

One of the options is to have the message show on the screen or you can set it to send "quietly".

i have some of these set in my code to keep tabs on what the users are doing.