Email a Receipt

[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!!

 

[Mark Andrews]

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

 

[Bald Eagle]

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.

 

[Mark Andrews]

You need to get into VB to make some of these things happen.

If for example you want a multi-select list box where the user selects which
people/receipts to send emails on, see this article for an example of the
code:
http://allenbrowne.com/ser-50.html

This would help build the filter to for example send emails to the 4 people
selected.

Mark Andrews
RPT Software
http://www.rptsoftware.com
http://www.donationmanagementsoftware.com