create report for e-mails

[Robert Blackwell]

Is there a way to make a txt template for reports? When I e-mail I have to
create a pdf first by printing to pdfwritter save filename as invoice
number,, create a new e-mail copy and paste generic reply and attach the
pdf. This is okay but it's extra work that I'd like to streamline if
possible.

I tried a couple things, exporting or sending to, basically they are the
same except send to automatically attaches the file to an e-mail. The
problem though is that the report we have shows the credit card number, and
on our report we have some x's masking the first 3 groups of numbers. If you
export to txt or anything else it types out the x's alongside the full
credit card number.

What I'd like to do is to make a template for a simplified txt document that
instead of attaching, I could just copy and paste into the body of an
e-mail, and that would only include certain specified things from the
report. I just wanna do something really simple like what you get when you
order something online. Like, if access could make a report similar to what
I have below that doesn't have to create an actual txt file. I could just
highlight it all onscreen copy, and paste inside an e-mail and then close
the report. That would be perfect for me.


Customer#: 123456
Order#: 123456
---------------------------------------------------------------------
item: 12345 Description: Stuff Qty: 1 Price (each): $1
item: 23456 Description: Stuff Qty: 1 Price (each): $2

Product Total: $3
Tax: $.24
Shipping: $0

Grand Total: $3.24

----------------------------------------------------------------------


Billing Address:
info


Shipping Address:
info

 

[Tony Toews]

What I'd like to do is to make a template for a simplified txt document that
instead of attaching, I could just copy and paste into the body of an
e-mail, and that would only include certain specified things from the
report. I just wanna do something really simple like what you get when you
order something online.

To create a formatted document to send as an email you will need to
use VBA code to create a largish string. This string will then be
passed to the SendObject command or other method as the body of the
email. For more details including sample air code see my Tips page
on this topic at http://www.granite.ab.ca/access/email/formatted.htm.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm