Need help creating and emailing individual reports

[Erick C]

Hi everybody.
I have a problem that I hope someone will be able to help me out
with. I am trying to automate some functionality in my Access 2003
database, I am looking to create individualized customer reports that
Acess can email out. I basically have a report that lists a customer
and all accounts belonging to the customer. When I view the report now
I get a page for each customer that is listed in the source table. I
am afraid that emailing this would send a copy of everyones report
out, not just that particular customer. Also, not everyone receives
emails, so I am thinking of creating a separate table to get the data
belonging to customers receiving emails away from the rest of the
data.
I have a separate table of customer information, including email
addresses. I have never emailed anything from Access, and I am not
the best at writing VBA code, so any assstance that I can get with
this problem would be greatly appreciated.

Thanks.
Erick

 

[Gina Whipp]

Erick,

Here you go, specifically the last two...

http://www.candace-tripp.com/Pages/SearchResults.aspx?query=outlook

http://www.devhut.net/index.php?lang=en&id=0000000007

http://www.granite.ab.ca/access/email/outlook.htm

http://www.blueclaw-db.com/access_email_send_outlook.htm

Code to sent Multiple eMails:
http://www.datastrat.com/Code/MultipleEmail.txt

Download sample database EmalSenate2K (PLEASE do not send eMail from this
database to the eMails shown. This is for demonstration purposes only!):
http://www.datastrat.com/DataStrat2.html

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Erick C]

Gina -
Thank you for the information. I have a question, is Access only able
to email via Outlook? We use Lotus Notes at work, I am hoping that
could still use the email functionality.

 

[Gina Whipp]

Erick,

Oh... well... have a look here...

http://www.granite.ab.ca/access/email/lotusnotes.htm

http://www.granite.ab.ca/access/email.htm

http://www.fabalou.com/VBandVBA/lotusnotesmail.asp

I don't use Lotus Notes so my help here is limited.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Gina -
Thank you for the information. I have a question, is Access only able
to email via Outlook? We use Lotus Notes at work, I am hoping that
could still use the email functionality.