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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Can I make my database notify my customers via email?
|
#2
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |