automatic emails

[blackcat]

I have created a Database in Access 2003 in which I have created a report
that i would like to have automatically emailed - using an email address
field. Does anyone know if this is possible.

 

[Rick B]

Yes, and the button wizard will even walk you right through the steps. Add
a button to your form. When the wizard pops up, select "Report Options",
then "Mail Report". The wizard will walk you through the rest.

 

[blackcat]

this is great, thanks. is there any way i can automatically pick up the email
address from a field on the form to save the user typing it in?

 

[Rick B]

Sure. Here are some previous posts that explains that. In short...

DoCmd.SendObject acSendNoObject, To:= Me.Email



http://groups.google.com/group/micr...ect+from+field&rnum=14&hl=en#831efa6891106e14

http://groups.google.com/group/micr...endobject+form&rnum=13&hl=en#7606b68018d70c3c

http://groups.google.com/group/micr...endobject+form&rnum=23&hl=en#18bb939e2ad43905

 

[blackcat]

this has been a great help so many thanks for this.
i'd now like to be able to set up a button for the user to click that will
email a
report to all email addresses picked up from a query, can this be done as
some sort
loop or do until eof? if so, how? thanks again for all your help

 

[blackcat]

this has been a great help so many thanks for this.
i'd now like to be able to set up a button for the user to click that will
email a
report to all email addresses picked up from a query, can this be done as
some sort
loop or do until eof? if so, how? thanks again for all your help

 

[blackcat]

this has been a great help so many thanks for this.
i'd now like to be able to set up a button for the user to click that will
email a
report to all email addresses picked up from a query, can this be done as
some sort
loop or do until eof? if so, how? thanks again for all your help