email with Acccess

[Samuel]

Hi

What are the general options that exists in regards to sending an email with
Access?

Thank you,
Samuel

 

[Dale Fye]

Read up on SendObjects in the Access Help.

There is more on this, and with the current security environment,
SendObjects will generate a message every time you send out a message,
confirming that you actually want to do it (it's a security thing). If you
Google on Access +email you will probably get a couple of explainations on
how to do it without generating a message.

HTH
Dale

 

[Guest]

ther seem to be two ways. Simplest is using SendObject method in VBA Access
2003. DoCmd.SendObject(ObjectType, ObjectName, OutputFormat, To, Cc, Bcc,
Subject, MessageText, EditMessage, TemplateField). Denise Gosnell's
brilliant book "Beginning Access 2003 VBA" (ISBN0-7645-56592) page 202.
MikeB