E-Mailing A word attachment using Access

[John Baker]

Hi:

Can someone point me in the right direction please?

I need to use Access to e mail a variable report (in Word) to a number of individuals.
Their names are in a table called Associates, and their e mail addresses are in a field
called "E-Mail". I am not certain how to set this all up so that I can treat the name of
the E-Mail, and the path for the attachment, as variables. In fact I am not certain how
the DoCmd.SendObject command works in this context, not having used it before.

We have Outlook 2000 and Access 2000.

Thanks for any help

Regards

John baker

[Pieter Linden]

John Baker <Ba******@Verizon.net> wrote in message news:<q9********************************@4ax.com>. ..

Hi:

Can someone point me in the right direction please?

I need to use Access to e mail a variable report (in Word) to a number of individuals.
Their names are in a table called Associates, and their e mail addresses are in a field
called "E-Mail". I am not certain how to set this all up so that I can treat the name of
the E-Mail, and the path for the attachment, as variables. In fact I am not certain how
the DoCmd.SendObject command works in this context, not having used it before.

We have Outlook 2000 and Access 2000.

Thanks for any help

Regards

John baker

I don't think SendObject will let you do this very easily. I'd read
up on Tony Toew's site about e-mailing. If all your variable values
are in the table, then you could just automate Outlook, grab the
recipient e-mail address and the attachment path from the table, and
then send...

olkMsg.Attachments.Add(rs.Fields("AttachmentPath") )
olkMsg.Recipients.Add(rs.Fields("EMailAddress"))
olkMsg.Send

[John Baker]

Thanks.

Where can I find out more about the command set you refer to:

olkMsg.Attachments.Add(rs.Fields("AttachmentPath") )
olkMsg.Recipients.Add(rs.Fields("EMailAddress"))
olkMsg.Send

I dont appear to be able to find anything in VBA help or in my documentation about olkMsg.

Thanks

John

[Tony Toews]

John Baker <Ba******@Verizon.net> wrote:

Where can I find out more about the command set you refer to:

See Outlook specific links at the Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

[John Baker]

Thanks

John Baker

Tony Toews <tt****@telusplanet.net> wrote:

John Baker <Ba******@Verizon.net> wrote:

Where can I find out more about the command set you refer to:

See Outlook specific links at the Microsoft Access Email FAQ
http://www.granite.ab.ca/access/email.htm

Tony