A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » New Users
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Can I make my database notify my customers via email?



 
 
Thread Tools Display Modes
  #1  
Old November 24th, 2005, 08:55 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Can I make my database notify my customers via email?


  #2  
Old November 25th, 2005, 07:50 AM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Can I make my database notify my customers via email?

Yes. Use SendObject Action in a Macro.

TD Akins wrote:

Can I make my database notify my customers via email?


  #3  
Old November 26th, 2005, 01:37 AM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Can I make my database notify my customers via email?

Yes. There are also commerical products you can purchase (if you do not want
to spend the time writing the code). If you are interested in knowing some
suggestions, please let me know.

Rob Mastrostefano

--
FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com


"TD Akins" wrote in message
...



  #4  
Old December 9th, 2005, 01:51 AM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Can I make my database notify my customers via email?

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

"RobFMS" wrote:

Yes. There are also commerical products you can purchase (if you do not want
to spend the time writing the code). If you are interested in knowing some
suggestions, please let me know.

Rob Mastrostefano

--
FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com


"TD Akins" wrote in message
...




  #5  
Old December 9th, 2005, 03:59 AM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Can I make my database notify my customers via email?

On Thu, 8 Dec 2005 16:51:03 -0800, Secret Squirrel
wrote:

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]
  #6  
Old December 9th, 2005, 04:05 AM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Can I make my database notify my customers via email?

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.

"John Vinson" wrote:

On Thu, 8 Dec 2005 16:51:03 -0800, Secret Squirrel
wrote:

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]

  #7  
Old December 9th, 2005, 04:55 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Can I make my database notify my customers via email?

SS

Because you have asked for further information about a commerical product, I
am providing one product that our company produces. A trial version is
available for your review.

Rob Mastrostefano

Total Access Emailer
http://www.fmsinc.com/products/Emailer/index.asp

Total Access Emailer leverages the power of Microsoft Access and email so
you can generate personalized email for everyone in your table or query.
Easily send email from Access in text or HTML format with attachments. Use
field values in your email subject and message to create unique,
personalized emails for each recipient. You can even maintain an audit trail
to know who was contacted when.


--
FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com


"Secret Squirrel" wrote in
message ...
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

"RobFMS" wrote:

Yes. There are also commerical products you can purchase (if you do not
want
to spend the time writing the code). If you are interested in knowing
some
suggestions, please let me know.

Rob Mastrostefano

--
FMS Professional Solutions Group
http://www.fmsinc.com/consulting

Software Tools for .NET, SQL Server, Visual Basic & Access
http://www.fmsinc.com


"TD Akins" wrote in message
...






  #8  
Old December 10th, 2005, 06:28 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Can I make my database notify my customers via email?

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

www.pcdatasheet.com

Over 1050 users have come from the newsgroups trusting me and requesting
help. My fees are very reasonable.




"TD Akins" wrote in message
...



  #9  
Old December 10th, 2005, 07:01 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default Can I make my database notify my customers via email?

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 he http://www.contextmagic.com/express-clickyes/


"Secret Squirrel" wrote in
message ...
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.

"John Vinson" wrote:

On Thu, 8 Dec 2005 16:51:03 -0800, Secret Squirrel
wrote:

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]



  #10  
Old December 10th, 2005, 07:08 PM posted to microsoft.public.access.gettingstarted
external usenet poster
 
Posts: n/a
Default The quiet is over! PCD is blatantly soliciting again.

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



"PC Datasheet" wrote in message
ink.net...
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.




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access Error Message when opening database eah General Discussion 3 January 26th, 2005 11:04 AM
Exclusive access to the database Steve Huff General Discussion 17 December 24th, 2004 07:23 PM
What is MDE Charlie General Discussion 4 August 24th, 2004 04:15 PM
error message - server rejecting recipient Ken Outlook Express 5 August 20th, 2004 06:39 PM


All times are GMT +1. The time now is 08:45 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.