Sending out email through Outlook using Access

[Robert Stanke]

I have done multiple searches on the web, but can never get a clear answer to
this...

I have a query in Access 2007 which contains email addresses. I want to
send those records an email using Outlook 2007. Can someone please provide
me the procedure for this?

Thank you so much!

Robert Stanke
http://robertstanke.com

 

[Daniel Pineault]

It depends on your needs and what tools you have at your dispostion.

The simplest method is to use Access' built-in SendObject Method.
Docmd.SendOject ObjectType, ObjectName, OutputFormat, To, Cc, Bcc, Subject,
MessageText, EditMessage, TemplateFile
Check it in the help file for full details and examples.

Then, if you need to include external files as attachments, you need to
upgrade and use Outlook automation. For this look at
http://msdn.microsoft.com/en-us/lib...odc_ac_olauto_sendanoutlookmessageusingaccess

There are other methods if you do not have Outlook....post back if this is
the case and provide some details and we will guide you to an answer for your
situation.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Tony Toews [MVP]]

I have done multiple searches on the web, but can never get a clear answer to
this...

I have a query in Access 2007 which contains email addresses. I want to
send those records an email using Outlook 2007. Can someone please provide
me the procedure for this?

See the Sample Code illustrating looping through a DAO recordset page
at the Access Email FAQ at
http://www.granite.ab.ca/access/email/recordsetloop.htm

As Daniel states if the email is relatively simple you can use
SendObject. But if you want to use HTML format or attachments then
you need to use Automation to send the emails.

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

Ton
--
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
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[a a r o n _ k e m p f]

the best method is to use SQL Server to send email messages for you.

 

[srctr]

I want to send email using email addresses in Access. How do you do this? I
do not know much about VBA so I would need exact step by step directions.
Basically I want to create a message using email addresses from Access that I
could then attach a file to the email. I would like it to include the
subject and message and put everyone in the BCC field.

I have a query that already pulls who to send the email to (yes in a field
"Send Newsletter by email") and their email address.

Thanks for any help