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

Using a Recordset to Send Emails in Outlook

P: n/a
Hi,

I've attempted to make use of the Microsoft Knowledge Base Article
"ACC97: How to Use a Recordset to Send Outlook E-Mail to Multiple
Recipients - 318881" but I can't get it to completely work. I have
been continually receiving two error messages.

The first message states that it cannot find the Form "frmMail" which
I made sure to create.

Or it highlights the following line
Set objOutlookRecip = .Recipients.Add(Forms!frmMail!CCAddress)
and says this property is unavailable in design view.

I am currently using Access 2003 and am wondering if the difference in
version could be the problem.

Thanks,
Jonny
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
DFS
Haven't seen that article, but what I've done is iterated through a
recordset, built up a string variable with the recipients (or cc, or
subject, or body) names, and added it to the DoCmd.SendObject command,
thusly:
DoCmd.SendObject acSendNoObject, , , recipientString, ccString, ,
subjectString, bodyString, True

or get the recipient from a form:

DoCmd.SendObject acSendNoObject, , , frm.listRecipients.Column(0, i),
ccString, , subjectString, bodyString, True

"Cameron" <jo**************@hotmail.com> wrote in message
news:32**************************@posting.google.c om...
Hi,

I've attempted to make use of the Microsoft Knowledge Base Article
"ACC97: How to Use a Recordset to Send Outlook E-Mail to Multiple
Recipients - 318881" but I can't get it to completely work. I have
been continually receiving two error messages.

The first message states that it cannot find the Form "frmMail" which
I made sure to create.

Or it highlights the following line
Set objOutlookRecip = .Recipients.Add(Forms!frmMail!CCAddress)
and says this property is unavailable in design view.

I am currently using Access 2003 and am wondering if the difference in
version could be the problem.

Thanks,
Jonny

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.