E-Mailing from Access

[Guest]

Hi Everyone,

I am using Access 2000 to send a trade confirmation to my head office. I use
an input screen to enter all the data required, then I have created an output
/ print screen to put the information into a standard format for H/O and
finally I have created a macro button using the SendOutput command to print
and e-mail the record / trade confirmation to H/O.

My problem is this. How do I get the e-mail to look like the printed
version, and not like a file exported to excel. Also, the e-mailed version
includes ALL the data on the input page, not what was only on the printed
page.

Please help. I have been pulling my hair out for quite a while on this.

Many thanks in advance

Jay

 

[fredg]

Hi Everyone,

I am using Access 2000 to send a trade confirmation to my head office. I use
an input screen to enter all the data required, then I have created an output
/ print screen to put the information into a standard format for H/O and
finally I have created a macro button using the SendOutput command to print
and e-mail the record / trade confirmation to H/O.

My problem is this. How do I get the e-mail to look like the printed
version, and not like a file exported to excel. Also, the e-mailed version
includes ALL the data on the input page, not what was only on the printed
page.

Please help. I have been pulling my hair out for quite a while on this.

Many thanks in advance

Jay

Access does not support graphics when outputting reports,
so I would suppose that is what you are referring to when
you state that it does not match the printed version.

Output the report as acSnapshot. The receiver of the email
must have the Access Snapshot Viewer to read the emailed
report. It's available for free from the Microsoft Download Center.
http://www.microsoft.com/downloads/results.aspx?pocId=&freetext=snapshot viewer&DisplayLang=en

As for the second question regarding All data being exported,
remember, you're there and we are not. You'll have to post
back with more details as to what you would like sent,
what actually is sent, and any code you are using to open, and
then send the report.

 

[Guest]

Hi Fred,

Many thanks for your response but I had already thought of that. The problem
being that I need to be able to create a report for a single record from many
that may not be unique and so using a query would pull the wrong or too many
records. I also need to be able to send the email at a click of button from
the screen.

The way I have tried to get around this, is to produce the output page as
the 'viewable print page' from the input screen. Sounds awkward I know.
Basically all the input fields and text boxes are only viewable on the screen
and the output page is sitting behind all that, but is not viewable on the
screen only on the print.

This gives me 'on a printer' exactly what I want. But, as per my original
question, when I come to email it or produce an email from it, things go
wrong.

Is there a way of transfering the information from the input screen for the
specific record to a pre-created report by clicking a button on the input
screen that runs a simple macro which then takes a screen snap of the report
and creates the email.

The people I am working with, do not like long winded ways of doing things
as it means they will probably make a hash of it. Simple stupid is the catch
phrase around here. Plus when everyone get busy, they do not want to be
bothered with going through a long winded process to send confirmations.

The fields that are being output on the email in xls format are all the
fields (26) in a table called 'History', which is the table, the input form
adds records to. For the Confirmation, I only require about half of them.
Plus, the Confirmation must be in a standard format (my output page) and not
in xls format. There are no graphics, only text and label boxes, plus the odd
line here and there.

Do you have any suggentions as to what I could try from here?

Kind regards

Jay