473,499 Members | 1,724 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

automating email from Access 2.0

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
1 1962
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

12
3189
by: Jerry Weinstein | last post by:
Hi, I know about stored procedures and that they can speed up data entry via the SQL 'insert ' statement. However, one drawback to this method is that using the stored procedure still requires...
6
4315
by: Charles Banas | last post by:
weird subject - i hope more than just one curious regular will hear me out. :) ok, i've got a bit of a big problem, and i need answers as soon as possible. i know this forum is meant for web...
7
2612
by: xzzy | last post by:
I need to automate a report in a different database (and thank yous to Terry Kreft for pointing me in the right direction). below is the code with the one line that does not work, marked: 'Does...
3
1474
by: Lauren Wilson | last post by:
Hi folks, We have an Access 2000 app that is highly integrated with Outlook 2000 or later. The app allows the user to send predefined emails that are created through an Access form and stored...
4
3214
by: Supa Hoopsa | last post by:
I am in the process of rewriting an MS Access application (access front end with SQL 2k database) in VB.NET and one of the things I would like to do is link in to the compiled Access ADE so that I...
0
1184
by: NYShai | last post by:
I am using Access to analyze data in a remote SQL server. I cannot "link" these tables, because Access doesn't like the SQL's replication ID, so I need to import these table each time I run a...
8
1788
by: Liam.M | last post by:
Hey guys.... I need to find a way to loop through all of my records in the database ( so essentially query the database) based on a Date Field ("DueDate") and if any record falls within 2 months...
4
1616
by: access-newb | last post by:
Just started working in Access, and while I'm fairly confident in the basics, or so I think, anything advanced doesn't work too well. I've got a task I know should be easy to automate, but I don't...
4
3180
by: attachmatey | last post by:
Greetings: I'm looking for some help in automating (what I thought would be) a simple procedure in Internet Explorer. I'm trying to put the following operation under a button click in an MS...
0
7134
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
7012
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7225
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
7392
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5479
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
0
4605
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
3105
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
3101
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
667
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.