Keep in touch and stay productive with Teams and Microsoft , even when you're working remotely. Last Updated: January 7, Access or Access installed. This includes the or versions of the Access Runtime. When trying to send mail using DoCmd.

Author:Mucage Nijin
Language:English (Spanish)
Published (Last):10 February 2019
PDF File Size:10.49 Mb
ePub File Size:8.62 Mb
Price:Free* [*Free Regsitration Required]

Welcome to UtterAccess! Active Topics. Search this forum only? More Search Options. Please Wait Site Message. Message will auto close in 2 seconds.

View Member Profile. May 23 , AM. Post 1. I cant seem to find any answers to this Question Does anyone know of a way to specify the sender in an email that is generated from an access command button The computer's being used in my situation will not necessarily have all the users email accounts on it and as far as I understand, with the DoCmd. SendObject, access will only use the default email account on your computer to populate the sender Is there a way to populate the sender based on email addresses in an access table?

Post 2. Is there any particular reason why you would want to do this? Seems quite strange to me. Post 3. I have a DB in which any user from the user table can create an order, but only a user with manager status can approve and send them But l would like to email the order from within access and for it to be sent from the one who created it, not necessarily from a manager And the manager may not have the users email account included in there outlook accounts list that way when there is a problem or query about an order the supplier will be replying to the one who created it, not necessarily the manager.

Post 4. I dont know if what you want to do can be done but I'm assuming that your users log into the database. You could always include the user on the footer of your report so that would show who created it.

May 23 , PM. Post 5. Yes I had that in mind as a backup option But I am surprised that such a simple task like that would be so hard impossible to accomplish I thought that was how a lot of the spam type email sender fields, are created. Post 6. Hi Gab-Hop, if I remember well, it's only possible to set up one outlook sender for one profile on your pc.

So change sender, seems to me impossible, except perhaps if you are an email network administrator!!! It needs confirmation, of course!. May 24 , AM. Post 7. Outlook has no problem establishing multiple accounts, each with their respective "Send As" options. This can also be accomplished within Access with the correct VBA construct s. Post 8. Here are a couple of thoughts. VBA can do this provided outlook has been set up with the account you want to send from, and with the authority.

Using the mail item sendusingaccount. The spam messages you see with all sorts of from names are created with something a bit more sophisticated than sendobject One thing we do do here is we have a shared email account Gmail which three users have set up in their outlook, and we add at the top of the body. So the message itself will start with Sent From whoever is logged on to the PC It may be possible to use 'sentfrom using CDO but I seem to recall that the best you can do with that is to set up a 'reply to'.

Post 9. Are you familiar with the CDO. May 24 , PM. Post May 25 , AM. I think you'll find that sent on behalf of doesn't work unless the other account is set up. It will go into the sent box of the current user I think. If you want to specify reply to you'd need to use CDO to send I'm happy to be found wrong on all of these: I'm working from memory on all the issues I had when trying to do something like this Please let me know if you'd like some sample CDO code, that would do what you want There's still a fair bit of setting up to do though.

Yes thanks my current code is CODE. Hi, I've attached the code we use in our system to send e-mails. This works in Access and , and I believe its the same code I used in at another job.

MoveFirst Do While rst. Update Rem Next record rst. This is more or lest the same as the previous post I think You may need to play with some of the configuration settings to get it to work.

AddAttachment attachment file path an name. Value, 1, 1. May 25 , PM. Just a few questions before I go any farther 1.

Does the computer need administrator rights granted for this code to work 2. Does being 32bit or 64bit effect the code 3. May 26 , AM. I have 32 bit Office on a 64 bit OS. Yes you do need the password or you'd be able to send 'from' any body. Jul 4 , PM. Jul 6 , AM. So this will send the e-mails even if you have a secure e-mail server without a password?

Jul 6 , PM. Yes I can specify the sender as whoever I choose and it will send from Gmail addresses as well,no password needed as long as you are running through a smtp server. Custom Search. Gab-Hop View Member Profile. May 23 , AM Post 1. May 23 , AM Post 2. May 23 , AM Post 3. May 23 , AM Post 4. May 23 , PM Post 5. May 23 , PM Post 6. It needs confirmation, of course!

CyberCow View Member Profile. May 24 , AM Post 7. May 24 , AM Post 8. Posts: 7, Joined: December 10 From: England. May 24 , AM Post 9. May 24 , PM Post Posts: 3 Joined: June May 25 , AM Post May 25 , PM Post May 26 , AM Post Jul 4 , PM Post Jul 6 , AM Post Jul 6 , PM Post


Access & Email

Welcome to UtterAccess! Active Topics. Search this forum only? More Search Options. Please Wait Site Message. Message will auto close in 2 seconds.

8205 SOP8 PDF

Crash occurs when trying to send mail from Access

With internet access possible almost everywhere nowadays, the requirements for database applications quite frequently include the requirement to provide interfaces to internet services. While requirements for direct connections to webservers via HTTP or FTP are increasing, but not yet ubiquitous, a simple interface to send emails from within an application can be considered fairly standard now. There are lots of different approaches to send email messages from an application. On this web page I want to try to provide an overview over different options for a developer to integrate the functionality to send email messages from Microsoft Access applications.

Related Articles