Emailing current record/screen, if poss?

fedupwithaccess · Feb 1, 2007

I'm not sure this is possible, so I suppose I'm just wanting it confirmed.

Is there any way that I can automatically email the current screen from within Access.

i.e. call outlook along the lines of

Dim x
x = fHandleFile("mailto:" & Me!EMailAdd, WIN_NORMAL) ' me!ContactEmail

and then add the current record/form which is on the screen as an attachment?

I'm guessing not and that I'll have to run it as a report in snapshot format, but thought I'd ask.

KernelK · Feb 1, 2007

It is definitely possible to email out the information. You could simply email the record information in the body of the email message you send out, or if you want an attachment, you could create a text file of the record information, attach and email it, or you could export the record information (especially if it is for multiple records) to an excel spreadsheet and attach it. All of these things can be done programmatically through access. Now if you just want a screenshot of the form? I dunno about that, but you can definitely email the INFORMATION.

ansentry · Feb 1, 2007

Is there any way that I can automatically email the current screen from within Access.

In my opinion you should not print or email forms you should use reports.

If you want to e-mail a report which show the data from the current record then have a look at my sample posted >>Here<< it will e-mail the current record

fedupwithaccess · Feb 2, 2007

Emailing current record/screen

ansentry said:
If you want to e-mail a report which show the data from the current record then have a look at my sample posted >>Here<< it will e-mail the current record

John,

Thanks for your reply and it sort of confirms what I was expecting, as in I'll have to go via reports.

I was hoping to take a look at your sample, but unfortunate your database link no longer exists on that previous thread. Could you repost this at all?

Thanks,
Iain

ansentry · Feb 2, 2007

Sorry about that, I have attached a copy.

sudhirhinduja · Feb 21, 2007

Dummy check

fedupwithaccess said:
I'm not sure this is possible, so I suppose I'm just wanting it confirmed.

Is there any way that I can automatically email the current screen from within Access.

i.e. call outlook along the lines of

Dim x
x = fHandleFile("mailto:" & Me!EMailAdd, WIN_NORMAL) ' me!ContactEmail

and then add the current record/form which is on the screen as an attachment?

I'm guessing not and that I'll have to run it as a report in snapshot format, but thought I'd ask.

Hi fedupwithaccess...
I just implemented something really simple.
See if it works for you.
Add a field Dummy which is a Yes/No field in the underlying table.
You know the underlying query of the report. Save it as a new query called qryDumyReport.
In the old as well as new query add the new Dummy field.
Now base the report on the new qryDummyReport which has a true condition for the Dummy check mark.
Open the form in design view. On the OnCurrent event type
Me.Dummy=True
On the OnClose as well as AfterUpdate events type
Me.Dummy=False
Then add a new button on the form. The command button wizard will provide you with report operations. Choose mail report from in there.
Boom.
Next you know it - with the current form open on screen you can email the current record.
I also struggled a lot with it
HTH.
Suds.

ansentry · Feb 21, 2007

sudhirhinduja said:
Hi fedupwithaccess...
I just implemented something really simple.
See if it works for you.
Add a field Dummy which is a Yes/No field in the underlying table.
You know the underlying query of the report. Save it as a new query called qryDumyReport.
In the old as well as new query add the new Dummy field.
Now base the report on the new qryDummyReport which has a true condition for the Dummy check mark.
Open the form in design view. On the OnCurrent event type
Me.Dummy=True
On the OnClose as well as AfterUpdate events type
Me.Dummy=False
Then add a new button on the form. The command button wizard will provide you with report operations. Choose mail report from in there.
Boom.
Next you know it - with the current form open on screen you can email the current record.
I also struggled a lot with it
HTH.
Suds.

Why go to all that trouble when you can have code do it for you?

billie66 · Apr 14, 2010

Thank you very much. Your database is extremely beneficial to my users for who I plan to incorporate this module. Keep up the good work.

Joe.

Emailing current record/screen, if poss?

fedupwithaccess

Registered User.

KernelK

Registered User.

ansentry

Access amateur

fedupwithaccess

Registered User.

ansentry

Access amateur

Attachments

sudhirhinduja

Registered User.

ansentry

Access amateur

billie66

New member

Similar threads

Users who are viewing this thread