By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,327 Members | 1,806 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,327 IT Pros & Developers. It's quick & easy.

E-Mailing A word attachment using Access

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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
Nov 13 '05 #2

P: n/a
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
Nov 13 '05 #3

P: n/a
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
Nov 13 '05 #4

P: n/a
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


Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.