Sending file via email.

[BillLin]

I am new to MS Access VBA. I am doing an Access porject with the
function of generating funding files in a required format in a folder
and then attaching it to an email (with the number of transactions and
their totals) and sending it to a number of receipiants. Can anybody
give me a hints on how to use Access VBA to send email with attachment?



Thanks a lot in advance.



Bill Lin


--
Posted via http://dbforums.com

[MacDermott]

Re: Sending file via email.

Assuming that the attachment is an Access report, you may be able to use
SendObject. (See the Help file for details on syntax.)
Otherwise it will take some intermediate to advanced VB coding.

HTH
- Turtle

"BillLin" <member38658@db forums.com> wrote in message
news:3346149.10 63078250@dbforu ms.com...[color=blue]
>
> I am new to MS Access VBA. I am doing an Access porject with the
> function of generating funding files in a required format in a folder
> and then attaching it to an email (with the number of transactions and
> their totals) and sending it to a number of receipiants. Can anybody
> give me a hints on how to use Access VBA to send email with attachment?
>
>
>
> Thanks a lot in advance.
>
>
>
> Bill Lin
>
>
> --
> Posted via http://dbforums.com[/color]