Report Embedded in Body of E-mail

[BrianB75]

I have searched through the various means of adding an Access object in the body of an e-mail but I cannot seem to find something that works. What I am trying to do is embed an existing, formatted report from Access into the body of an e-mail.

I tried exporting the report as a .html file but I could not get it to display correctly in the body of the e-mail.

Any suggestions or pointers would be greatly appreciated.

 

[OlcayM]

if you have frontpage or any other html editor;
- Prepare the report in that editor
- Copy it to a table field (note field) If needed, divide the html different fields
- Then....

Better send me the report output. Tell me which parts are changing and which parts are constant. I will send you the mdb as a sample. I had the same problem and solved it that way. It is difficult for me to explain, I will better send you the sample.

olcaym

 

[GaryPanic]

that will be interesting - same issue - so would like to see this (mind you my reports a bitch ) but i'll see what you ahve done and hack it to fit if poss

regards

 

[OlcayM]

sorry but my english is not so good and ı could not understand what you wrote. Is that mean you are going to send me a sample of your report?

olcaym

 

[OlcayM]

Here is the sample mdb

First of all, please note that I have no knowledge of HTML. I just copied the HTML code which forntpage 2000 created.

- The pdf attached, is the code created by fp2000. I first created the report at fp2000 then switch to HTML tab, and copied the code to 4 different fields which are fixed on every report.
- What I need is to fill the name of the customer, date, part description, quantity and price. I add them with code as you may see in mdb file (attached)

I know it is a bit tricky but I found it very comfortable. You design it once then the rest is easy.

olcaym

 

[BrianB75]

Thanks for the responses. I do not have the report formatted yet as I wanted to make sure I could get this to work. I do not have Front Page and I am not familiar with HTML coding. When I spoke of HTML in my original post I was just using the OutputTo in VB to create the HTML file based on a sample report. This way I could just import the file.

I had seen other threads here that talked about embedding the file as the body as opposed to recreating the report in the body.

I hope this wasn't confusing. I haven't had my morning coffee yet.