How to send email after entry from data access page

I hope this is an easy one, but i am not a programmer.  I got volunteered for this because i built an inventory database.  Access 2003I have a simple referral table that i have linked to an "Input" page for people to enter records (including a drop down list of email addresses).  And an "Output" page where pepole can come and edit.  That part seems to be working fine.I need to have an email sent out when a new record is posted.  Ideally, i would like it to be sent out based on who is selected in that email list, but i would settle for anything at this point.Thank you in advance.
0
Utf
3/16/2007 2:57:00 PM
access 16762 articles. 3 followers. Follow

0 Replies
1310 Views

Similar Articles

[PageSpeed] 4

Reply:

Similar Artilces:

How do I send copies emails without sending attachments?
I send emails with attachments to our bank. My boss wants a copy of the email but not a copy of the attachment. How do I do that? Steve Bramblett wrote: > I send emails with attachments to our bank. My boss wants a copy of the > email but not a copy of the attachment. How do I do that? Each recipient gets the SAME copy of the e-mail. If you want different recipients to get different versions of your e-mail, you have to send different e-mails. ...

Errors accessing shared speadsheet.
I have a group of users who access a shared Excel spreadsheet. The spreadsheet is on a Novell server. Starting out they all could access the spreadsheet fine. Starting recently people have begun to receive memory errors when accessing or saving the spreadsheets. If you log into windows as a different user but still use the same ID in Novell it works fine for a period of time then recieves the same error. This seems to be a microsoft issue as after you recieve the error you can copy the file local and it still errors. logon as a different user in windows and it works fine. any help wou...

Data Security & Flash Drive Formatting
Last week I placed some sensitive files on a flash drive for a brief period (two or three hours) before deleting them. At this point, I'd like to make sure that these deleted files CANNOT be recovered, and I know there are tools out there that *can* restore deleted files. I need to make sure that any such tools will NOT be able to recover the files in question. So, I'm wondering if a "low-level" format operation would flip all the 1's to 0's (so to speak), such that these files would be certainly unrecoverable. Would formatting do the trick? And wo...

Bin and sort a large list of data
I have a large list of data that i need to go through for my job. what i want to do is organize the numbers into bins, then elimintate any numbers that are identical. does anyone have any ideas? Hi, Sort the data into the number order. Let's say that is in column A. Then in the first free column, make the first cell 0, and then do in row 2 =IF (A1=A2,1,0) This will then equal zero on the first line of a new number. Then Copy, Paste Special, Values on this column of ones and zeros, and then sort on it. The data at the top will be a unique list of numbers. You can just the...

No message in outbox
I tried to send a message with 1Mb attachment to 40 recipients in the bcc field. It gave me an error message from the isp's server, the message was NOT sent (I've checked), it did NOT arrive in Sent Items, but neither is it in the Outbox any more. I can send and receive email successfully. Problem is, every few minutes Outlook tells me it's sending message 1 of 1, it fails and gives me the same error message. Yet there is no message in the Outbox. But what happened to the original message when it first failed to send? I guess it's 'stuck' somewhere but I can...

Sending mail from selected email address
Hi All, As I have 4 email accounts set up in Outlook, I understand that I can send mail from each or any account. The accounts are listed under tools / Send and Receive / then each of the accounts. How can I choose which account to send from so that the recipient see's who I want it to be from?? Hope that explains it. Regards Alan On Sat, 16 Apr 2005 21:10:48 -1000, The Fatman <albaxter@optushome.com.au> wrote: > Hi All, > > As I have 4 email accounts set up in Outlook, I understand that I can > send > mail from each or any account. > > The acco...

PowerPoint 2003 to accessible Word 2003 via VBA?
I'd like to extract all content from a Windows PowerPoint 2003 document and place it in a Word 2003 document, as Word to PDF conversion seems to provide better-quality tagging than a PowerPoint to PDF conversion. I know I can save the outline as RTF and open that in Word, but the outline does not include any of the following: - text added on a blank slide layout - text in a text box - tables. - images. Is there any way to copy all content from a PowerPoint presentation to a Word document, such that all text remains text and all tables remain as tables? Charles Belo...

Sending a macro to another PC-how?
How do you send a macro you've written to another PC so that they can save it in their Personal.xls file (at Program Files\Microsoft Office\Office\XLStart)? You can export a macro and save it, to do this from your workbook, right-click the workbook's icon and pick View Code. This icon is to the left of the "File" menu this will open the VBA editor, click on the module you want to save and go to file and export file, then save it to a floppy or what ever you backup to, then import it to the new workbook. -- Paul B Always backup your data before trying something new Using ...

Sending mail from remote location
my mail works great while at home. when I go on the road I can receive ail but not send. I get the following error message: Subject 'SKIDOO MACH Z 800LT (long track / long tunnel) (Jackson)', Account: 'Jeff', Server: 'smtp.charter.net', Protocol: SMTP, Server Response: '571 imp11 smtp.charter.net OTcuMTQ3LjE2LjIzMA== You must connect from Charter IP space. E1110', Port: 25, Secure(SSL): No, Server Error: 571, Error Number: 0x800CCC61 It worked on my last laptop and I have not been able to figure it out on this one. I can't remember what I...

Send and Recieve Fix
For a long time I had a problem with my Send/Recieve function in Outlook. This happended in both Outlook 2000 and my current version - 2007. I found I had to re-boot my computer to perform a Send/Recieve in Outlook. Otherwise the sequence would start then stop and say it could not perform due to an error. After extensive Internet and News Group research I decided it was time to run a check on disk errors. This Windows XP facility seemed to have fixed my Outlook problem. I did this about a few months ago now and I have since had no problems with my send and recieve. Unfortunately I do have ...

can't download pop3 email
This is my error message Task Receiving reported error 0x800CCC0F The connection to the server was interrupted If this problem continues contact your server administrator or your ISP The server responded +OK How do I fix this? What did your ISP say? --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the (insert latest virus name here) virus, all mail sent to my personal account will be deleted without reading. After scratching one's head, M Pond <anonymous@discussions.microsoft.com> asked this group: | This is my error mes...

Forwarding email to Blackberry to a remote server
I have Blackberry with an email address on a server in NYC that runs BES 4 and exchange 2000. And I want to have people email to an address on an exchange 2000 server in Albany, NY and have exchange forward the emails to the person's mailbox and to the Blackberry in NYC. I have setup the forwarding system as prescribed by MS, but when people on the NYC domain email the Albany address they get this error message: From: System Administrator Sent: Friday, February 11, 2005 1:57 PM To: Gary Subject: Undeliverable:RE: Delivery Status Notification (Failure) Your message ...

.EMAIL ATTACHMENTS #2
I have received emails lately that have an attachment with the extension of .email. I can't get these attachments to open. When I double click, it appears to start to open, but really nothing happens. Any advice? Please respond to email address above. Thanks! The closest "legal" file extension would be .eml , which is the Outlook Express default file extension. Regardless of the file name, extension type, you should be very careful with any file attachments if they are unexpected from people you do not know. If the message is from someone you are expecting a file att...

Is there a workaround for Access 2007 failure with a control recordsource =SubformControl.Form.RecordsetClone.RecordCount?
After spending hours fighting this problem in a newly upgraded database, I found Allen Browne's documentation that Access 2007 introduced a new bug where a control recordsource like this fails: =iif(SubformControl.Form.RecordsetClone.RecordCount=0, 0, SubformControl.Form.txtSubformTotal). Thank you to Allen for nailing the problem. Since I'm using SP1 and seeing the same problem, I gather it has not been fixed yet. Has anyone come up with a good workaround? I have avoided the issue for now by using =SubformControl.Form.NewRecord, but that only worked by allowing additions in the...

Unable to send?
Hi, I've got MOOL, and i"m usign ti with outlook. The emails that I'm sending are just "stuck" in the outbox? Can anyone give me an idea of what's going on? Rex Did it ever work? Are you able to receive? -- Aloha, -Ben- Ben M. Schorr, OneNote-MVP Roland Schorr & Tower http://www.rolandschorr.com Microsoft OneNote FAQ: http://www.factplace.com/onenotefaq.htm **I apologize but I am unable to respond to direct requests for assistance. Please post questions and replies here in the newsgroup. Mahalo! "Rekks" <rex_flynn@hotmail.com> wrote ...

Excel to Email
Hi Our sales people need to send to our sales manager on a daily basis a list of the sales orders that they created for that day. I created a private view named 'Daily Sales Orders' and showed each person to export to Excel. I was wondering if anyone knows of an easier way to do this. I would ideally like to mail merge or email template something similar. Ideally it would be nice for a sales people to create an email an insert their list for that day. Appreciate any suggestions. Thanks Mark As a thought, SQL Reporting can be configured to send a report, by email automatical...

MS Access Filter question
I have a column that gives me the results; /dir/dir/customer name I want to filter out the /dir/dir/ so the column results just show the customer name, I think a substr() might work but I am not sure how the syntax would look. Any suggestions? -- Neall Use InstrRev() to find the last / in the string. Then use Mid() to get the remainder from there. (You can also use Dir() around the file name to lose the path.) -- Allen Browne - Microsoft MVP. Perth, Western Australia Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. &q...

Sending messages in Outlook
We have a user that everytime that she sends an email she will get booted out of Outlook. The email does go through, but she will have to get out of Outlook. When she goes back into Outlook, everything is fine until she sends another message. Any help would be appreciated. ...

No Permission to Send/Receive Email???
I just replaced our server hardware, upgraded to WS 2k3 Enterprise and created a new domain. I transferred the client files and desktop on our desk/laptop computers over to the new domain. We do NOT have Exchange installed yet, but use Outlook 2002 with the email etc. saved on the client. One one client machine (mine), the email, calendar, etc are there, but when I hit the Send/Receive button, I get a message saying that I don't have permission to perform this operation. Also when I try and change the automatic check for email option it tells me I don't have permission. ...

Web Access #2
Hey guys, I cannot user Outlook Web Access anymore, where can I troubleshoot this? You haven't said what version, and given very little information to go on, so this reply may be way off. You could start with the OWA troubleshooting guide: http://www.microsoft.com/technet/prodtechnol/exchange/2000/support/troubowa.mspx -- Neil Hobson Exchange MVP For Exchange news, links and tips, check: http://www.msexchangeblog.com "Melvin" <mrodriguez@nyas.org> wrote in message news:eh61ZzrWEHA.808@tk2msftngp13.phx.gbl... > Hey guys, I cannot user Outlook Web Access anymore,...

Automatic Data Changes
I have a work sheet that I use to monitor dates. I need to track up to 5 dates at a time. I would like my worksheet to update automaticaly when I change the dates. Let me explain. The data in A4 through A12 never changes. The data in B4 through B12 changes weekly. I need to track the last 5 changes made to B4 through B12. ex. Lets say B4=10/20/09. I then change B4 to 11/2/09. I want the data from B4 to go to C15. so C15 will be 10/20/09. Then when I change B4 to 11/16/09, I want C15 to automatically update to 11/2/09 and C16 to update to 10/20/09. and so on for 5 dates....

Clicking on new mail notification does not open email
This is a multi-part message in MIME format. ------=_NextPart_000_0053_01CACB73.FC871830 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I finally upgraded from WLM 2 to 3 (14.0.8089.0726) this afternoon (Win = XP SP2). When I get a new mail notification via Messenger and click on = it the email does not open. I have to go to the inbox to open it. Any = ideas? Kevin ------=_NextPart_000_0053_01CACB73.FC871830 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTY...

Send Do Not Send
When I attempt to email via a print server - OutLook Express displays the message "A program is attempting to email on your behalf" Send or Do Not Send - How do you prevent this from happening? And just automatically send? ...

Sending on behalf... Exchange 2003
Hi everyone, Is there a better way to give a few users the ability to send mails also from the info@domain.com mailbox without having them logout and login to a different Outlook 2003 profile... Or without the text sending on behalf of... So my question is, Is there an easy way that a user can select another e-mail address and send mails out...? Thanks a lot in advance!! Regards, BY On Thu, 05 Oct 2006 12:57:12 GMT, "BY" <nospam@mail.com> wrote: >Hi everyone, > >Is there a better way to give a few users the ability to send mails also >from the info@dom...

Emails from Outlook to Hotmail accounts
I have just change my email client from Outlook Express to Outlook 2002. Messages sent to Hotmail addresses are not getting through and produce a message: 550 Recipient Not Authorised [recipient rejected due to no authorised destination groups] If anyone can tell me how to overcome this I should be most grateful. You may need to set up authentication to your outgoing server, which can be done on the "Outgoing Server" tab for your account (press the "More Settings..." button on the account page). -- Jeff Stephenson Outlook Development This posting is provided &quo...