Exporting Report to Outlook - Embed in Body of Message

[Edtheredhead]

Hey all,



I'm new here. I'm pretty much an advanced-intermediate user (i.e. know enough to be dangerous).

Here's what I'm working on. I need to generate a report and then email it to employees within the body of an email. If it's a PDF file, they won't look at it (trust me on that one). The report is designed to show them the status of a single "order" and what documents are still missing from it. Ideally it would look like this:


Order Number: 1234567
Customer Name: John Smith

The following documents are still needed to allow us to continue to process this order:

X Document A
X Document D
X Document G

Thank you.

I can create the report, however when I try to copy it over to Outlook, it ends up just being a datasheet view and has ALL of the fields, not just those that are checked off.

Any suggestions?

Thanks.

[ranman256]

I would send just as you have:
Order Number: 1234567
Customer Name: John Smith

The following documents are still needed to allow us to continue to process this order:

but with your attached pdf. (a single OUTPUT command)
Your co-workers cannot be so lazy that they cannot click 1 finger to view the document.

[June7]

The alternatives:

1. if data from multiple records, then in looping structure concatenate desired data into a continuous string with embedded CrLf to be part of the email body - email can be sent with SendObject method

2. somehow export report to jpg image and then embed that image into email with HTML code tags - cannot use SendObject method, requires Outlook automation

3. maybe programmatically manipulate copy/paste - it is possible to manually select records/fields from table or query then copy and paste into email as an embedded table

[Edtheredhead]

I would send just as you have:
Order Number: 1234567
Customer Name: John Smith

The following documents are still needed to allow us to continue to process this order:

but with your attached pdf. (a single OUTPUT command)
Your co-workers cannot be so lazy that they cannot click 1 finger to view the document.

Thank you everyone. I spoke to my boss about it and he's approved of using the PDF format. He said, "Yea, there's some that are so #*#) lazy that they'll never click on it, but it comes out of their paycheck, not ours." LOL

Thanks again!

[June7]

Are you using SendObject method?