Sending email!

[jakoBAlmqvist]

Hi!

I got a question about emailing.... I don't think this is possible but I thought why not ask....

Is it possible to have a button on a form, that when it's pushed, it sends an email with a report included to a certain email adress?

thanks!

-jake

 

[ansentry]

Below is a link to a sample post of mine:


Click Here

Go down until you see PrintCurrentRecord_Update.zip. It has email and other things in it, you can sent an e-mail to a client or attach a report and send it to a client.

Any problems with it PM me.

 

[jakoBAlmqvist]

Hi John!

I've taken a look at the sample but I can't see how you've done it. It's only letting me use the form ... but I can't look at any codes or so...? It says that it's "read only" when I open it?

 

[Jibbadiah]

Sounds like you are new to access.

The easy way is to create a macro and look at the sendobject action.

It has easy dropdowns to navigate and understand.

A a command button to your form that calls the macro.

J

 

[ColinEssex]

or search these forums, there are many examples posted as this question crops up regularly

Col

 

[ansentry]

I have attached it directly to this thread, when you open it with win zip make sure that you extract it , to your desktop for example.




Let me know how you go with it.

 

[jakoBAlmqvist]

Hi John!

Thanks for the help, I'm new with access so I don't know that much...
especially not when it comes to codes...

I've been trying to put something together but it just doesn't work... I want it to work exactly the way your sample does! (By the way, the reason to why I couldn't see the codes where because I always click on the icon at the upper left to go to "Design View", but with your sample you had to "right click" on the mouse and so on..) I have even tried to copy your sample into my database, but that didn't work either.( Well actually it worked but it was saying something about "PrintClose"??)

I've got the textboxes, I've got the "Email report button" but how do I do to Email the report directly to the Email adress that is in one of those boxes? Sorry for my english, hope you understand and that I'm not beeing to much of a pain.

Thanks again!

-jake

 

[Jibbadiah]

Jake - I spotted that you were new... and hence offered you the easiest solution above.

Goto Macros tab and click new.
Select Sendobject from the drop-down menu.
Select the relevant action arguments from the bottom of the macro form.
In this case your object type would be report, choose your report name.
Put your full email address in the "to" line.

When you add a command button to your form you can get it to run your macro. choose miscellaneous - run macro, and choose your new macro name from the drop-down list.

It is that easy.

No need to jump straight into vb until you understand the basics.

James

 

[Jibbadiah]

p.s. the reason you are inputting your own email address at this stage is to see that it works and to test it. Obviously you would replace it with recipients address when you are happy.

 

[jakoBAlmqvist]

Hi James!

Thank you so much for your help! I only got one last step now... it works, just as you said when I put an email directly in "To:". But I want it to check up the email-adress in a combobox on a form...

I tried with [Forms]![Myform]![MyCombo] but that didn't work. I will continue trying to solve this but if you have a quick response then it would me be apriciated!=)

However thanks for the fast lesson in how to do Macros, i get the "principle" now=)

-jake

 

[jakoBAlmqvist]

well that took about 5 seconds=)...

it had to be like this: =[Forms]![Myform]![MyCombo]

Thanks anyway=)

 

[DanG]

I too was following along..
This doesn't work for Lotus Notes does it?
I got an error

thanks