469,609 Members | 1,687 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,609 developers. It's quick & easy.

Sending file via email.


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
Nov 12 '05 #1
1 5110
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" <me*********@dbforums.com> wrote in message
news:33****************@dbforums.com...

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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Paul Lamonby | last post: by
3 posts views Thread by Serge Myrand | last post: by
1 post views Thread by festivalman | last post: by
5 posts views Thread by Kun | last post: by
7 posts views Thread by bleachie | last post: by
31 posts views Thread by happyse27 | last post: by
reply views Thread by devrayhaan | last post: by
reply views Thread by gheharukoh7 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.