Emailing current record/screen, if poss?

[fedupwithaccess]

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]

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]

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]

Emailing current record/screen

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]

Sorry about that, I have attached a copy.

 

[sudhirhinduja]

Dummy check

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]

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]

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.