V
Vincent Johns
Yes. Use SendObject Action in a Macro.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
S
Secret Squirrel
Hi Rob,
I have a question about these commercial products for emailing from Access.
Can you have automated emails sent out when new records are created in a
specific table? If so, can you point in the direction of a product that has
this capability?
Thanks
I have a question about these commercial products for emailing from Access.
Can you have automated emails sent out when new records are created in a
specific table? If so, can you point in the direction of a product that has
this capability?
Thanks
J
John Vinson
Hi Rob,
I have a question about these commercial products for emailing from Access.
Can you have automated emails sent out when new records are created in a
specific table? If so, can you point in the direction of a product that has
this capability?
PMFJI but... you could do so if the new record is entered via a Form;
but Access tables don't have events, so if the user enters directly
into the table datasheet or populates the table using an append query
or VBA code, the answer is no. On a Form you can use the Form's
AfterInsert event to call the email software.
John W. Vinson[MVP]
S
Secret Squirrel
Hi John,
They would be entering a new record via a form. Could a code be written in
VBA to do this without addin software? As you can tell I'm new to VBA and I
wouldn't even know where to begin. I'm in a crunch for time also.
They would be entering a new record via a form. Could a code be written in
VBA to do this without addin software? As you can tell I'm new to VBA and I
wouldn't even know where to begin. I'm in a crunch for time also.
P
PC Datasheet
I ca implement what you want for a very reasonable fee. It will all be in
native Access (no-add-ins). Send me an email to my email address below.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com
Over 1050 users have come from the newsgroups trusting me and requesting
help. My fees are very reasonable.
native Access (no-add-ins). Send me an email to my email address below.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com
Over 1050 users have come from the newsgroups trusting me and requesting
help. My fees are very reasonable.
R
Rob Oldfield
A useful resource for all mail related Access issues...
http://www.granite.ab.ca/access/email.htm
There is one issue with sending mail via Outlook 2003 that I don't see
mentioned in there - where you attempt to send and Outlook pops up a
question warning about security issues. I get around that by using (free)
software from here: http://www.contextmagic.com/express-clickyes/
http://www.granite.ab.ca/access/email.htm
There is one issue with sending mail via Outlook 2003 that I don't see
mentioned in there - where you attempt to send and Outlook pops up a
question warning about security issues. I get around that by using (free)
software from here: http://www.contextmagic.com/express-clickyes/
J
John Marshall, MVP
Here we go again. These newsgroups are for FREE user to user support.
Unfortunately, steve AKA PCD believes that these newsgroups are here so that
he can prey on unsuspecting uers.
John... Visio MVP
Unfortunately, steve AKA PCD believes that these newsgroups are here so that
he can prey on unsuspecting uers.
John... Visio MVP
R
Randy Harris
PC Datasheet said:I ca implement what you want for a very reasonable fee. It will all be in
native Access (no-add-ins). Send me an email to my email address below.
And if you would like to know something about the character of this spammer,
check this link:
http://home.tiscali.nl/arracom/whoissteve.html
R
Rob Oldfield
Though I think he's probably picked on this one so that, when he gets
attacked again, he can have a whine about "...but why is it OK for RobFMS to
post links to commercial software...." Before you do that Steve, could I
suggest that you try thinking about it. The difference should be clear to
anyone with half a brain cell.
attacked again, he can have a whine about "...but why is it OK for RobFMS to
post links to commercial software...." Before you do that Steve, could I
suggest that you try thinking about it. The difference should be clear to
anyone with half a brain cell.
P
PC Datasheet
TD,
My offer to help you is sincere! If you don't know where to start and are in
a time crunch, I can help you. Numerous newsgroup readers keep coming to me
for help after posting to the newsgroups. here are some comments made by
people from the newsgroups that came to
me and paid me to help them ---
I like it a lot. It does exactly what I want, very good job. Thankyou and I
repeat GOOD JOB
OK, Perfect, well done. See you when I need something more.
Your very helpful email speaks volumes about your level of professionalism.
I will definitely keep your contact information for anyone who needs these
types of services - we very frequently get local businesses
contacting us looking for exactly the type of service you provide.
One word: Wow. I had no clue it could be such an "aesthetically pleasing"
interface. I figured it'd just be a big chart. That's amazing. You've really
helped me cause out a lot, and you've done a tremendous job with this demo.
With this, I can more easily explain how a database could help us out.
Thanks for looking ahead. That is the reason I really feel safe working with
you. couple of the programmers who do work for me, need to be checked to
told to do every step of the way. With you, I just need to tell you what I
need to be done, and you will think ahead of all the problems that might
occur in the process.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com
Over 1050 users have come from the newsgroups trusting me and requesting
help. My fees are very reasonable.
My offer to help you is sincere! If you don't know where to start and are in
a time crunch, I can help you. Numerous newsgroup readers keep coming to me
for help after posting to the newsgroups. here are some comments made by
people from the newsgroups that came to
me and paid me to help them ---
I like it a lot. It does exactly what I want, very good job. Thankyou and I
repeat GOOD JOB
OK, Perfect, well done. See you when I need something more.
Your very helpful email speaks volumes about your level of professionalism.
I will definitely keep your contact information for anyone who needs these
types of services - we very frequently get local businesses
contacting us looking for exactly the type of service you provide.
One word: Wow. I had no clue it could be such an "aesthetically pleasing"
interface. I figured it'd just be a big chart. That's amazing. You've really
helped me cause out a lot, and you've done a tremendous job with this demo.
With this, I can more easily explain how a database could help us out.
Thanks for looking ahead. That is the reason I really feel safe working with
you. couple of the programmers who do work for me, need to be checked to
told to do every step of the way. With you, I just need to tell you what I
need to be done, and you will think ahead of all the problems that might
occur in the process.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com
Over 1050 users have come from the newsgroups trusting me and requesting
help. My fees are very reasonable.
P
PC Datasheet
My offer to help TD was very sincere. He said he did not know where to start
and is in a time crunch. And yes I am in business to provide customers a
resource for help llike this and I expect to be paid for the help. In the
past numerous newsgroup readers have come to me for help like this and have
paid me for my help. I continue to get newsgroup readers coming to me for
help. I have also provided innumerable responses of free help to posters in
the newsgroups.
Now that you bring it up, why don't you explain why it is OK for RobFMS to
clearly advertise software by FMS. It is pure product advertisement.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com
I have a calendar form and calendar report module which can be used to
display different data in each day of the calendar. As the name implies,
both look like pages torn from a calendar. The year and month for the
calendar are selectable from a menu at the top of the screen. My calendar
module has been used by many customers in scheduling applications. I also
have a 7 - Day form and report module that can display different data in
each day. The first day in the 7 Day period is selectable and can be any day
of the week. The 7 - Day form and report look like a week from a calendar.
and is in a time crunch. And yes I am in business to provide customers a
resource for help llike this and I expect to be paid for the help. In the
past numerous newsgroup readers have come to me for help like this and have
paid me for my help. I continue to get newsgroup readers coming to me for
help. I have also provided innumerable responses of free help to posters in
the newsgroups.
Now that you bring it up, why don't you explain why it is OK for RobFMS to
clearly advertise software by FMS. It is pure product advertisement.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com
I have a calendar form and calendar report module which can be used to
display different data in each day of the calendar. As the name implies,
both look like pages torn from a calendar. The year and month for the
calendar are selectable from a menu at the top of the screen. My calendar
module has been used by many customers in scheduling applications. I also
have a 7 - Day form and report module that can display different data in
each day. The first day in the 7 Day period is selectable and can be any day
of the week. The 7 - Day form and report look like a week from a calendar.
R
Randy Harris
If you feel that this sort of advertising in a newsgroup that is intended
for Access users to provide help for one another on a no charge basis, I
suggest you report this to (e-mail address removed)
Note: It's important to include the entire header from the message when you
do so.
Randy Harris
for Access users to provide help for one another on a no charge basis, I
suggest you report this to (e-mail address removed)
Note: It's important to include the entire header from the message when you
do so.
Randy Harris
R
Randy Harris
PC Datasheet said:My offer to help TD was very sincere. He said he did not know where to start
and is in a time crunch.
Yet another lie from the unscrupulous spammer.
The sum total of his post was the subject:
"Can I make my database notify my customers via email?"
J
John Marshall, MVP
PC Datasheet said:My offer to help TD was very sincere.
Sincerity has nothing to do with it. Free support is FREE.
So how many burglars get off by saying they were "sincere" about liberating
their victims from their possessions?
He said he did not know where to start and is in a time crunch.
For a message that only had a subject line of "Can I make my database notify
my customers via email?" and no message,
that is a very interesting interpretation.
<More lame excuses to justify bad behaviour removed>
Now that you bring it up, why don't you explain why it is OK for RobFMS to
clearly advertise software by FMS. It is pure product advertisement.
No one said it was okay. You are the worst and most persistent offender, so
it makes more sense to concentrate on bringing you in line. Besides, not
complaining about your solicitations would give RobFMS the impression that
solicitation is allowed.
I have a calendar ... <more blatant advertising removed>
((You can now start your childish rant with the usual offensive language
(but blaming someone else for saying it), innuendoes and tired misquotes, ))
John... Visio MVP
P
PC Datasheet
Here's a direct quote from TD ---
" As you can tell I'm new to VBA and I wouldn't even know where to begin.
I'm in a crunch for time also."
Randy, you're nothing but an unscrupulous liar!!!!!!!!!!!!!!!
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com
Over 1050 users have come from the newsgroups trusting me and requesting
help.
My fees are very reasonable.
" As you can tell I'm new to VBA and I wouldn't even know where to begin.
I'm in a crunch for time also."
Randy, you're nothing but an unscrupulous liar!!!!!!!!!!!!!!!
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com
Over 1050 users have come from the newsgroups trusting me and requesting
help.
My fees are very reasonable.
P
PC Datasheet
And I suppose RobFMS is going to give away FMS software for free!!!!!!!!!!
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com
Over 1050 users have come from the newsgroups trusting me and requesting
help.
My fees are very reasonable.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com
Over 1050 users have come from the newsgroups trusting me and requesting
help.
My fees are very reasonable.
R
Randy Harris
PC Datasheet said:Here's a direct quote from TD ---
" As you can tell I'm new to VBA and I wouldn't even know where to begin.
I'm in a crunch for time also."
Randy, you're nothing but an unscrupulous liar!!!!!!!!!!!!!!!
Well, anyone that is interested in learning who is lying can simply go back
and look at the original post. What you say is in there, ain't in there.
R
Randy Harris
No, but enough complaints to your ISP might put an end to PC Datasheet
adverstising.
(e-mail address removed)
adverstising.
(e-mail address removed)
P
PC Datasheet
You're saying it is okay for RobFMS to advertise and John Marshall below
says it is not okay. Which one of you doesn't have half a brain cell???
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com
Over 1050 users have come from the newsgroups trusting me and requesting
help.
My fees are very reasonable.
says it is not okay. Which one of you doesn't have half a brain cell???
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com
Over 1050 users have come from the newsgroups trusting me and requesting
help.
My fees are very reasonable.
J
John Marshall, MVP
PC Datasheet said:Here's a direct quote from TD ---
That's actually a quote from Secret Squirrel not TD.
John... Visio MVP
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.