how can I send an email in VBA

[totomalas]

I want to automate the sending of an email in Access 2007, this email will also carry an attachment of PDF or word document...or instead of that automate the sending of a report to an email address...

can you please help..I need it badly...

[Echidna]

Hi Totomlas,

Sending a report from Access is relatively simple, if you want to send an email with an attachment, you will need to code the function calls to your email application.

if you want to send a report to an email address:

docmd.SendObject acSendReport, rpttest, acformatPDF,
[e-mail], ccemail, bccemail, subject,Email message,
<Edit message True/False>
 

if you want to send report as PDF, you will need to install the addon from microsoft.
goto www.microsoft.com and search for the following
SaveAsPDFandXPS.exe

Edit message set to False will not allow the message to be altered before your default email application sends off the mail, if set to true, the email application will prompt for you to send the mail.

hope this helps

Leon

[totomalas]

thanks for the code you provided this is exactly what i am looking for...but I have a question......where shall i put the SMTP/POP3 details so the application can actually connect to the internet and send the email?

[Echidna]

As far as I know, MS access does not have an inbuilt Email service (as SQL server does with SQL mail)
the code will place a message into your default email application's outbox, ie Outlook (Express), Thunderbird, Groupwise etc

Cheers

Leon

[totomalas]

I am tryin the method you mentioned, but I keep getting an error...it says "Microsot Access Cannot send this message" ... :(.. I dont seem to be able to solve it,, please help....

[Echidna]

Do you have an email application (Thunderbird, Outlook etc) on the machine you are using the Access app on?

Cheers

Leon