I would imagine this is quite simple to do, providing your not a complete Access novice...

What Im after is adding a button to one of my forms that says "email this record and save" kind of thing. It's a support desk database and Im just wanting to send the completed record and its contents to the user that has logged the fault.

Any thoughts please?

Cheers

Depends on how your pc is set up. If you work for a big organisation, chances are you won't be able to get access to automate sending of e-mails as mail server will not be on your pc. If you work for a small company / at home, then a command button can be set up to email a report very simply. Use the command button wizard

Have a look at this - none of my work - but this looks interesting Version 2000 - this has a button that does this I have another that runns through all emails in a table as well (again none of my work )
but hope this helps

gbp

automating the sending of an email is not the issue, regardless of company size its a local send to email command, nothing to do with the server...

the report is the main problem...alls i want is to email one particular record that has just been filled and set to complete....then press a button that will email the user and close the record

oops wrong one - try sendemail
one does 1 email the other does all emails in a table - again none of my work - just trying to help
gp

ah got it now...

the sending of the mail isnt a problem, ive got another report which actually does that at the moment when the record is created

its the next stage that is proving a problem

the attached zip files - both of them show different approaches - I just tried one and it works sending an email (via outlook) to myself - Only found this aboutr 1/2 hour ago

Cheers Gary.

That's kind of the route I want to go down, already got something similar set up. The main problem being I have a full form/page that I want to be included with the report and I'm having no end of trouble just making that one page/form the report.

i am just about to start looking at this myself (this was a project I put on hold as their were more important area I needed for my d/base) however as I'm zstuck on these , i will look at what I've sent you and see if I can digest what they are doing, once done , I try and explian what it is i've done

what i wanted was for this to output a quotation into this format etc

and i have various type of quotes - so it will be interesting to say the least 0 couple of ideas floating around in my head

so will revert later on (may be a couple of days )
gbp

cool mate

nice one