Sending emails from Access

[F6GGR]

Hello,

Here is my problem. I use Access 2000. The data base is simple : one table
(Customers : with Id, Name, etc and e-mail address). Whay I want to realise
: send a e-mail to each customer with a report showing his datas. My
solution : 1) create a report for each customer, 2) sending them by the
SendObject function.

Is it the right way ?. Should I use the CreateObject function to create the
differents reports ?

Thank you for your help.

Alan

[MGFoster]

F6GGR wrote:

Hello,

Here is my problem. I use Access 2000. The data base is simple : one table
(Customers : with Id, Name, etc and e-mail address). Whay I want to realise
: send a e-mail to each customer with a report showing his datas. My
solution : 1) create a report for each customer, 2) sending them by the
SendObject function.

Is it the right way ?. Should I use the CreateObject function to create the
differents reports ?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Create ONE report for all customers. Filter that report for just the
customer you want to send to. Send the report using SendObject.

If you have a list of customers you'll be sending reports to use a VBA
loop to generate the report for each customer & email it, one customer
at a time.

Read the Access Help article on Filtering forms & reports.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA+AwUBREfUq4echKqOuFEgEQK4qwCeOBT943AQEiabeiknQf Db5m7dQucAmO1Q
RuFvkBk6vU23Yq+zUYvAFro=
=tG+Q
-----END PGP SIGNATURE-----

[F6GGR]

Thank you very much, I will follow your procedure.

Alan
"MGFoster" <[e-mail]> a écrit dans le message de news:
Kw**************@newsread4.news.pas.earthlink.net. ..

F6GGR wrote:

Hello,

Here is my problem. I use Access 2000. The data base is simple : one
table (Customers : with Id, Name, etc and e-mail address). Whay I want to
realise : send a e-mail to each customer with a report showing his datas.
My solution : 1) create a report for each customer, 2) sending them by
the SendObject function.

Is it the right way ?. Should I use the CreateObject function to create
the differents reports ?

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Create ONE report for all customers. Filter that report for just the
customer you want to send to. Send the report using SendObject.

If you have a list of customers you'll be sending reports to use a VBA
loop to generate the report for each customer & email it, one customer
at a time.

Read the Access Help article on Filtering forms & reports.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA+AwUBREfUq4echKqOuFEgEQK4qwCeOBT943AQEiabeiknQf Db5m7dQucAmO1Q
RuFvkBk6vU23Yq+zUYvAFro=
=tG+Q
-----END PGP SIGNATURE-----