By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,234 Members | 1,832 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,234 IT Pros & Developers. It's quick & easy.

automating email from Access 2.0

P: n/a
MLH
I'm looking for Access Basic code I can use with Access 2.0
to automate sending email using Outlook Express.
The body text will always be "Your invoice is attached."
The Attachment control on the form in which you compose
your email will get a different string value for each email,
pointing to pdf file containing customer invoice (full path 'n
filespec). Any old code out there you care to share?
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
MLH
Good point, Larry. I don't have more than 20 customers and
they ALL know me - have my phone number memorized & all
that junk. I don't think it will be a prob. But if they all stop
paying me, then I'll know you were right!

I'm using the SendObject Action in Access 2.0 (Method in 97).
That should take care of the attachment - but, as you can see
in my later postings this evening - it isn't. It really should work.
I don't understand why it's not.

Maybe it's more reliably implemented through OutLook rather
than OutLook Express. However, I can't find any help for "DDE"
in either of the two programs. I don't even know the name of
the executable that launches MS OutLook. I have a long way
to go here.

Good to hear from you again.

xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx xxxxxxxxxx
On Tue, 16 Sep 2003 00:45:06 GMT, "Larry Linson"
<la**********@ntpcug.org> wrote:
I can tell you that you'd better use more than that text, as it is almost
identical to the text in e-mails that is being used to spread worms and
viruses. I remember using MAPI at a customer site, about ten years ago, with
Access 2.0 to send e-mail, but I don't think OE was involved, and I never
had my own copy of the code. Sorry.

Larry Linson
Microsoft Access MVP

"MLH" <CR**@NorthState.net> wrote in message
news:6t********************************@4ax.com.. .
I'm looking for Access Basic code I can use with Access 2.0
to automate sending email using Outlook Express.
The body text will always be "Your invoice is attached."
The Attachment control on the form in which you compose
your email will get a different string value for each email,
pointing to pdf file containing customer invoice (full path 'n
filespec). Any old code out there you care to share?


Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.