Sending emails automatically fron access 2003

[Lorraine]

Hi, im relatively new to access,and was wondering if there was anyway i could
at a click of a button automatically send an e-mail containing an access
report directly to my inbox???

regards
Lorraine

 

[Wayne-I-M]

Place a button on your form and use this OnClick


Private Sub InsertButtonNameHere_Click()
DoCmd.SendObject acReport, "Insert Name of Report Here", _
"", "Insert E Mail Address Here", "", "", "Insert E Mail Subject Here", _
"Insert E Mail text here", False, ""
End Sub

 

[John... Visio MVP]

If you need help with this, I could set it up for you. I provide help with
Access applications for a resonable fee. Contact me if you need help. My
fee would be very modest.

Steve

These newsgroups are provided by Microsoft for FREE peer to peer support.
Stevie's help is a waste of time and money.

There are many talented Access wizards who gladly help for free. Stevie is
no where near there level of expertise.

John... Visio MVP


PS: So stevie, have you figured out how to convert from landscape to
portrait or that a mailing list is a mailing list and does not need to be
converted to an Access database at a modest fee?

 

[Wayne-I-M]

Hi

Steve the modest fee you wll charge - will this include telling Lorraine
there is a macro wizard in access 2007 to create PDFs and send them as
attachments. Also, in 2003 there is also a "free" macro that she can use.

Loraine, if you want to use the services of someone to set this up for you
thats fine. Many, many people in this forum make their living from
developing access databases o there is nothing wrong with that. I don't
object to Steve's looking for work - thats fine. But this forum is for
gaining free advice and swopping information that you feel other access users
will find interesting. I personally have asked lots of questions and
answered some, this is baically what the forum is about.

But as with most things, have a look around to see if you can do it yourself
1st. If you have a try and are having problems you can always post here and
get advice for free.

It's up to you.

Oh by the way, that advice from me will cost you one cake. Please send it
to me ASAP.
PS. I prefer cream cakes but jam will do as this is my 1st cakevoice to you.

 

[troy23]

If you want to email the report you will probably need the report
snapshot viewer available for free at the Microsoft site.


For FREE Access ebook and videos click here
http://access-databases.com/ebook

 

[Wayne-I-M]

The reader will not be needed.
If she can create the report then she can read/open it. - provided it opened
on the sam machine, but even if not she could send it as a RTF - most
machines have Word.

send an e-mail containing an access report directly to "my" inbox

 

[Keith Wilby]

"Reasonable" *and* "modest"? Time to consult that dictionary again Stevie
boy.

OP beware:
http://home.tiscali.nl/arracom/whoissteve.html

 

[Wayne-I-M]

You can write you own code or jut download ClickYes
http://www.contextmagic.com/express-clickyes/

I tried it and it really does work fine - I use to send weekly report to
clients

BUT

The warnings are there for a reason also disable them if you are SURE that
you clients will not get upset if you send them a virus

The reports I send are pdf to a fax machine
I may be wrong but I don't think I can send a fax a virus - someone will
come up with one - one day

 

[Wayne-I-M]

No - don't think the macro will create a pdf -


--
Wayne
Trentino, Italia.

I am currently using Lebans code to convert Access 2003 reports to PDF format.
I understand that Wayne-I-M says there is a free Access 2003 macro that will
do this also. Can you tell me how to obtain the free macro? What I
currently do is determine what the path and filename of the report are when I
convert it. Does the free macro allow me to do that? Thanks!

Hi

Steve the modest fee you wll charge - will this include telling Lorraine
there is a macro wizard in access 2007 to create PDFs and send them as
attachments. Also, in 2003 there is also a "free" macro that she can use.

Loraine, if you want to use the services of someone to set this up for you
thats fine. Many, many people in this forum make their living from
developing access databases o there is nothing wrong with that. I don't
object to Steve's looking for work - thats fine. But this forum is for
gaining free advice and swopping information that you feel other access users
will find interesting. I personally have asked lots of questions and
answered some, this is baically what the forum is about.

But as with most things, have a look around to see if you can do it yourself
1st. If you have a try and are having problems you can always post here and
get advice for free.

It's up to you.

Oh by the way, that advice from me will cost you one cake. Please send it
to me ASAP.
PS. I prefer cream cakes but jam will do as this is my 1st cakevoice to you.

Besides Wayne's suggestion you could go to Lebans.com and use his Report to
PDF to convert your report to a PDF document and then send it as an

[quoted text clipped - 14 lines]

regards
Lorraine

 

[Lorraine]

Hi, thanks for your advice, i have had a play around with access and have
sorted out my first problem, i created an output macro and inserted my e-mail
address, and set up the system scheduler to automatically run the database
every week, but my new problem is the database i have set up has weekly and
monthly reports and the output macro runs everyweek resulting in me recieving
e-mails for both Monthly reports and weekly reports every week, i do believe
there is a way i can automate it so i can run the weekly reports on a weekly
basis and the monthly ones once a month but not quite sure on how to do that,
i have been told i may need to set up a separate querie for each one with a
criteria of ww and mm but not sure on how to do it.

hope this all makes sense.