If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
E-Mailing from Access
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 |
#2
|
|||
|
|||
E-Mailing from Access
On Tue, 28 Aug 2007 05:20:02 -0700, Jay wrote:
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/r...s playLang=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. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#3
|
|||
|
|||
E-Mailing from Access
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 "fredg" wrote: On Tue, 28 Aug 2007 05:20:02 -0700, Jay wrote: 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/r...s playLang=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. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
Thread Tools | |
Display Modes | |
|
|