Generate a formatted Email

[asolell]

Hi All, I'm in need for a way to create a formatted email.

Sounds simple,. but in a minute u'll see why I am facing a difficult moment.

When I use OutlookExpress, I copy a SubForm and paste it into the msg body.
this is a simple spreadsheet/grid like subform table.

When I paste it into the Outlook Express Mail msg, the format of the tables stays with no problem.
You can then see a simple table with rows and columns and clear lines that form the table itself.

Since the table itself cannot be copied here,. I've attached a jpg so you can see what I'm looking to have in the Email.

The table that you see is simple placing my cursor in the the subform fields, doing CTRL-A then CTRL-C, going over to the Email msg, and CTRL-V.
I then edited the Header to say "John Dow Account" instead of the subform name.

Can anyone suggest on how to do that?

This is the Order_Detail table and as you can see it has multiple lines.

Please let me know if you know how to accomplish this.

Thanks,

-Alon.
alon@malabi.com

 

[Sergeant]

A word of caution:
Outlook tables don't survive very well when emailed to people not using Outlook. You may want to generate something that is more universal...
i.e...body of email:
Please pay <total> by <duedate>. See attachment for details of your order. (And attach a .txt or .rtf doc created on the fly from a report in your db. The .rtf will maintain the basic formatting (positioning), but not shapes (dividing lines, etc...).
Good Luck.

 

[asolell]

I agree with you that tables in Outlook/Outlook Express http://www.access-programmers.co.uk/forums/images/editor/separator.gif
http://www.access-programmers.co.uk/forums/images/editor/separator.gifsometimes are lost.
That really annoys me too .

I don't want to use attachments as they are cumbersome and seem a bit silly with regards to the quantity and amount of information that I'm attaching.
But hey.. I've got an idea:

How about HTML ?
Would that work?
I guess I can format a report to look even graphically nice.

What is your opinion of this option? is that a doable option?

Thanks,

-Alon.

 

[Hayley Baxter]

The only way to extract a report as it is seen in access is snp format. Not everyone who you wish to send this to will have this on their machine and therefore able to view it. You can extract a report via HTML, however this will not keep diving lines and other graphics etc. I posted a sample some time ago of generating a word document that has some VBA which will keep the format as it is in access, if you do a search here on the forum you should be able to find it. If not I can find it for you.

Hay

 

[Sergeant]

How about HTML ?
Would that work?

You can do that, but you'd have the same problem with people that view their mail in plain text...they'll see all the HTML markup.