Hello Rick:
This is an Access Newsgroup, but since you asked, Alpha Five is a
phenomenal
product that actually writes the code for the user after he/she makes
their
choices from a feature called "Action Scripting". One just answers a
series
of questions such as do you want "Plain Text" or "HTML". Sending email
isn't
the only area where Alpha Five excels, it makes Access look complicated
because the program automates almost everything while still giving you the
option to write custom code using Xbasic, their version of Visual Basic.
Anyway, to answer your question, yes I did copy some code and have it
working in plain text. However, the text doesn't line up, and for other
reasons, we want and need HTML formatting. So Rick, that's where the big
hang
up is, getting a standard response saying you are registered for the
following class, but doing it in an HTML formatted message so that
everything
lines up and we can add a hyperlink.
Robert
Robert T wrote:
Hello Rick:
[All versions of Access from Access 95 on up have allowed you to send
an Email without writing any code. What exactly are your Email
requirements that Access is not meeting?]
That's news to me, but it would make my life much easier. I would
truly appreciate it if you could show me how to do it without writing
code. I would even be happy if I had the code to such because we need
this functionality.
Okay, but realize that there is a big difference between "sending an
Email
without code" and "sending the specific Email that you require without
code". Any object in an Access file can be sent as an Email attachment
by
using the Send... option on the main menu.
Here at work I've developed an Access application that registers
students in the classes we teach [typcial Many to Many application].
When we bring up a class, it shows all of the students registered for
the class in a One to Many view. Some of the fields in the child
table are the student's ID and email address.
I want to click a button on the form that will send an HTML formatted
email message, via Outlook, to each student that captures the
following information.
StudentID & Student_LastName & Student_FirstName & Student_MI
Class Subject
Class Date
Class Time
Class Location
In sum, we want to send the same message [in HTML] to each student
that essentially says you are registered for the following class and
capture the information described above. We would be happy sending
the email one at a time, or even better, sending all them
simultaneously with one click.
Did I adequately explain what we need?
Yes. For that you would need to use code to automate Outlook. Just how
exactly would this other database program you spoke of accomplish the
requirements above without any code or macros required? I find that
rather
hard to beleive.
The complexities of using code to automate Outlook or CDO is mostly in
setting up the classes or modules that provide the interface to the
external
library. Once that is set up, actually USING that code for individual
Email
messages is fairly simple. Have you investigated the code samples
available
on the web that allow this? It is mostly a copy and paste operation.