Can Access 2007 generate an email receipt after details entered?

microsoft.public.access.gettingstarted

25 Nov 2007 2:45 AM

Jan Mushroom

I am creating a database for our club using Access 2007 and I am a beginner.
I want to know if I can set up the database to automatically generate an
email receipt when the treasurer enters member details and receipt number.
Any help gratefully received.
Jan

25 Nov 2007 3:01 PM

Rod Plastow

Jan,

Yes you can do this but it will involve some VBA coding using the SendObject
function.

Respond if you want to proceed with this concept.

Rod

25 Nov 2007 7:56 PM

Jan Mushroom

Hello Rod
Thank you for your response. I do want to proceed with this concept because
it will solve a problem we are having.
I do not know anything about VBA coding and the book I have does not mention
it.
Any help will be gratefully received.
Cheers
Jan

Show quote

"Rod Plastow" wrote:

> Jan,
>
> Yes you can do this but it will involve some VBA coding using the SendObject
> function.
>
> Respond if you want to proceed with this concept.
>
> Rod

26 Nov 2007 12:52 AM

Rod Plastow

Hi Jan,

Better if we take this away from this discussion board as it's not the most
suitable medium for developing application with all the back and forth
communication.

I'd be pleased to help so drop me a line at Fe_***@hotmail.com and then I
will know your email. Also we can send pictures and attachments via email.

Rod