Generating a Report and emailing it

[serviceenvoy]

I need to be able to set up a button on my form so I can send an email
that contains certain fields from the specific record I'm currently
on. It will need to combine with some standard text that will be on
all the emails. How do I begin this process?

 

[Dale Fye]

Take a look at the SendObject method.

You can compose your message using the standard text and pull the values
form the controls on your form. Unfortunately, if you are using Outlook as
your mail handler, this will popup a security warning message after you hit
your "Send" button, but if you are only doing these one at a time, it isn't a
big headache.

If you want to do this you can find ways around the security problem by
Googling on "SendObject +Security +Workaround".

Dale