Email a Receipt

  • Thread starter Thread starter Bald Eagle
  • Start date Start date
B

Bald Eagle

I have a button on a form used for inputting information about money received
(by a small charity) which will print a receipt by going to the 'last'
record. An alternative option which I have is a split screen form (showing
the receipt at the top and the datasheet at the bottom)which allows a
particular record to be selected and printed.

Is there any way that I could automatically attach the receipt to an
Access-generated email (in Outlook Express)? If I select the Email option it
attaches all the receipts in the datasheet! I'm a novice at VB so I would
need some guidance - I can cut & paste!!
 
You could do receipts in various ways:

Use sendobject with a filter, here's an article.
http://www.eggheadcafe.com/software/aspnet/32999926/sendobject-report-with-a.aspx

You could export the report as a pdf file and then build the email in code
and attach it.

You could use word merging to generate receipts in Microsoft Word.

You could make the receipt in the body of the email itself. Just construct
a string and use that string for the body of the email.

Hope this helps,
Perhaps you might have an interest in my donation software (free eval if you
want to take a look).
It's a very low cost package that will be growing in features to compete
with the big guys that charge the high prices,

Mark Andrews
RPT Software
http://www.rptsoftware.com
http://www.donationmanagementsoftware.com
 
Thanks for the suggestions, Mark. It looks like sendobject would be the
route to take for me. As a first stage I have seen how this can produce an
email (but so far I have not inserted email addresses) with a seperate HTML
page for each receipt all attached to the one email. I can use the email
address field in my datasheet to insert the email address.
But can you help me with a filter? How can I get a series of emails each
with the one associated receipt attached to it? Will I have to get into VB
to do this? And is it possible to select only a few receipts out of the
datasheet to send? How?
As I said before I am a novice as far as VB is concerned so I would
appreciate some further guidance if possible.
 
Back
Top