Dear
Steve, Thank you once again for responsding to my post. Please accept my
apologies for not responsing sooner.
What I am wanting to do is to send emails from an Access 2000.
From Access 2000 becuase I want to use this and other linked Access
databases to generate the email send lists and define and document the
messages etc.
I have come accross this site
http://www.freeaccess.de/downloaddetails.asp?ID=19
which provides examples of 'how to send emails using various incarnations of
Access which I have been working on.
[this as an alternative to the VB example at the site
http://www.jsware.net/jsware/vbcode.php5 which I had been working on because
it seemed more straight forward as a system to modify for my needs - though
I then came up against the issue I orriginally posted]
As you may have guessed - what I am trying to do is use prewritten code
modified to suit may purpose understanding it just to the point where I can
modify it for my own use.
I have now managed to do some mods to the example at
http://www.freeaccess.de/downloaddetails.asp?ID=19 to accept HTML as body
text which it wasn't doing and am about to grasp the nettle and import
'what's necessary' from it into my main application in Access 2000. I'm
anticipating that this will not involve overcoming the problem of making a
vb written user control available in Access 2000 - which was the issue in my
original posting.
I've included the links to the code I'm modifying as I thought you might
find them a useful resource at some time.
Thanks again
Jim Bunton
[Ah - when/if I get the system working I will post again with any issues
which seem appropriate]
PS - along the lines of offering what have been to me significant
discoveries - I had awful problems with handling the Winsock Control to
commumicate with the outside world resulting from the time it takes to close
an already opened port - as I want to send to longish lists of recipients.
Came accross the solution - "allocate to Port 0" detailed here
http://support.microsoft.com/kb/173619
Steve said:
Hi Jim,
Why don't you describe in fetail what you are looking for and we'll see if
we can come up with a way to do it in Access.
Steve
Jim Bunton said:
Dear Steve,
Thank you for your response to my posting.
had a look at the send objects function - I can't see that it will do
what I
am looking for.
The object is one that is currently in a VB application and I am looking
to
use it in an Access application.
Seems more like an 'import object' scenario - had alook at that and don't
find anything that seems to do what I need.
Jim
Steve said:
Jim,
Look at the SendObject function in Access Help to see if that helps you.
Steve
(e-mail address removed)
I have a vb project which sends emails.
[This is on the site
http://www.jsware.net/jsware/vbcode.php5
Ref Email Sending UserControl]
The Project has a form (Form1) which provides the relevant info
eg. recipient, sender, content, smtp provider etc
This data is processed by a "User Control" Module (MailUC)
The control consists of a simple form with one textbox on it and a good
deal of code.
The control is on Form1 and named MUC
The code for Form1 can reference the control like:-
ThisVariable = MUC.SomeFunction()
or
MUC.some_MUCvariable = "this"
The vb project file for the User Control is MailUC.ctl
?? how can I get this control into my Access2000 database and place it
on a form there??
