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

Sending emails from Access

P: n/a
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
Apr 20 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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-----
Apr 20 '06 #2

P: n/a
Thank you very much, I will follow your procedure.

Alan
"MGFoster" <me@privacy.com> 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-----

Apr 21 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.