General :: How To Use SendObject To Send Emails
Aug 5, 2012Where can I get a document that explains how to use SendObject to send emails from Access?
View Replies
ADVERTISEMENT
General :: Can SendObject Be Used To Send MDB File
Feb 28, 2014I use SendObject to send automatic emails from my application. Can I attach a table or an MDB file to the email? How do I do that? Or do I attach a table and it sends it as a text file?
View 4 Replies View RelatedGeneral :: Automatically Send Emails At The Beginning Of Every Month
Oct 25, 2013I would like to send an email from Gmail server automatically at the end of every month. I'm currently sending email on button click. But is it possible to do this without user intervention.
View 2 Replies View RelatedGeneral :: Send Emails From Run Time Version With And Without Outlook?
Nov 14, 2012Must Outlook be installed for Access to send emails?
Can I send emails from the Run-Time version of Access? (with and without outlook)
General :: Automated Task - Send Email Address To All Emails In Query
Sep 30, 2013I want to automate a task in access....
I have a query that may have 6 - 7 different records for example each record contains a different email address, i need to get the first email then send and email to that address then go to the next record get that email address send an email to that email address until its gone through all the records...
I use this code to send an email, dont know how to loop through records and get the email...
Code:
Dim appOutLook As Outlook.Application
Dim MailOutLook As Outlook.MailItem
Dim strPath As String
Dim strFileName As String
Set appOutLook = CreateObject("Outlook.Application")
[Code] .....
General :: Send Outlook Email Based On List Of Emails In Access Query?
Sep 15, 2014I've setup a selection form that returns a specific list of email addresses in a query.
What I can't work out is how to press a button and have the email addresses populate the To: field in a blank Outlook email - I don't need any bells or whistles.
Send Multiple Emails
Jun 23, 2006Hi
I am creating a recruitment db for 6 members of staff, I have created a form (add new vacancy). Within the form is a various drop down boxes where you can select each employee and drop down box to pick which company want a vacancy filling. What I wanted to do is when a new vacancy is put on the system, and the administration team select save record is it possible to email the employee to let them know a new vacancy has been added, and also email another administration department to send the employee a suitable candidate list with the information provided on the form.
Or am I asking far to much from access.
The two fields that are most important is who the vacancy belongs and which company want the vacancy.
The db is available if you require a look to have a better insight.
Thanks for all your help.
Send Emails For Data Collection With Attachment
Apr 20, 2012I am trying to send out request-for-quote sheets to vendors and i need to send the image of the product as well. when i send emails for data collection, the attachment is not included. how can i attach images?
View 2 Replies View RelatedModules & VBA :: Send Emails To Defined Array Of Recipients Using CDO
Sep 18, 2013I am trying to send emails using CDO to an array of recipients loaded from a query. I have made this work using Lotus Notes so i know the first part of my code is correct, and the current code I have works when I input an actual email address. But when I try to add the Array name into the 'To' field I get a data mismatch error.
View 3 Replies View RelatedSend Details Of Emails In Outlook To Access Database?
Dec 18, 2013I have a contact form on our website which sends an email to the business dev team saying that the user has requested to be sent product sheets. The email contains the users name, email, phone number, and a few other fields. Is there a way I can send the details of these emails to my access database automatically?
View 9 Replies View RelatedModules & VBA :: Create A Recordset For Multiple Emails And Send One Email
Mar 17, 2014I have some code that takes from a query, an email address and sends out an email.Due the security warning that happens for each individual email, i want to create ONE email for all email address in the query and populate them to the BCC section of the sendobject.Here is the code that I currently use
Code:
Private Sub cmdSendEmail_Click()
Dim MyDB As DAO.Database
Dim rsEmail As DAO.Recordset
Dim sToName As String
Dim sSubject As String
Dim sMessageBody As String
[code]...
I want to populate the BCC field with multiple emails addresses seperated by ":" and send just one email.
General :: Emailing PDF As Attachment With SendObject?
Jun 16, 2015I often output reports as a PDF. I also use SendObject to send emails from my application. But is there a way to send a PDF as an attachment with SendObject? Perhaps not, as the PDF would not be within my application?
View 3 Replies View RelatedGeneral :: SendObject Outlook - How To Stop Getting Warning Messages
Sep 5, 2012I am using SendObject to send Outlook email messages from my application. On my development system, I get two Outlook warning messages each time I send an email. A user tested this on the live system today and said they got no Outlook warning messages.
Is this something that I can set? To not give Outlook warning messages?
General :: Sending Email With SendObject - How To Determine User Name
Apr 27, 2015When I send an email from Access with SendObject, how does it determine the user name, the 'from' name. Is it just the user's Outlook name? Do I have any control over that?
View 1 Replies View RelatedGeneral :: Managing Contact Emails
Sep 11, 2012I work for a firm who have a few thousand clients and we are wanting to go through a process of checking with them that the data we send them is going to the email address they would like it to go to. However in some cases we don't currently hold an address so we are contacting them by phone to get the addresses over the next few weeks.
The way I've chosen to do this is to use the excellent link between Access and Outlook to send an email to the address we have on file (or have gotten) with a very light form they can optionally fill in to update the email address if desired.All seems well in testing this with 2 exceptions:
1) I have 2 email boxes in outlook, my "personal" one and a group mailbox. I'd like the emails access sends to come from the group mailbox but cannot see an option to control this.
2) We're likely to send the emails out in tranches - is there a way to have a single table the drives the email process but some how have it know that we have sent the emails out for certain clients such that when I send a second tranche, it doesn't re-send to clients that have already been contacted?
General :: Storing Emails In Database
Mar 7, 2013I have a need to store client emails in a database. In an ideal world the user would drag and drop the email over the attachment field and it would be attached. I've not been able to find any drag and drop features in Access 2013 so i am guessing this may not be possible?
It is possible to simply attach the email using the attachment field but i find this method slow as the user has to save the email to the drive and then attach it to the attachment field using the dialogue box.
General :: Outlook Emails Fail To Be Sent
Sep 17, 2013I have an Access database update process that is run from the Win7 scheduler. I have attempted to instantiate or reference Outlook and send an email indicating the status of the process.
Outlook fails for some reason, but it works fine interactively regardless of whether Outlook is running or not.
I am now thinking of trying SendObject instead.
General :: Creating Emails Through Word?
Jul 23, 2012is there a way to create an email through word and say your current balance is £1000.
i thought that as this is an office app then it must be possible. could it be something like
=DLookUp("c:UsersChrysalisDesktopDatabase.accd b[LoyaltyPoints]","tblClientDetails","EmailAddress= " & Mail Recipient)
General :: Regularly Run Number Of Reports And Emails?
Oct 16, 2013I want to regularly run a number of reports and emails. But I want them to run automatically at a certain time daily.
View 7 Replies View RelatedGeneral :: Import Error Using Collect Data Emails
Sep 10, 2014I created a form for adding new data to an existing database and it worked just fine.
Today the form has decided to add time to the date field and this clashes with the table it import to.
Why/how it's changed the date format and how to change it back?
General :: Data Collection Emails Based On A Form?
Nov 21, 2012I am trying to send out data collection emails to fill in my records but it will only let me select fields from single access tables, I want to be able to get them to fill out all the fields as entered in my forms, which contain sub-forms and therefore links to multiple tables.
View 1 Replies View RelatedGeneral :: Can Access Generate Emails Based On Record Date
Mar 14, 2014Using Access and Outlook 2010. I have a database that tracks Contracts for our University. One of the fields it tracks is Expiration Date.
Is there a way to have Access prompt Outlook to send an email to my boss when the contract is a month or within a month from expiring?I'm assuming when the database is opened it would have to run a query for expiration dates expiring within one month of today's date (which i know how to do).
I just don't know if it's possible to generate an email or some kind of message with those records/contract numbers displayed? I should also note my boss is the only one who uses this database so even if the email notice isn't possible, is there a way to show a message of what contracts are expiring soon when he opens the DB?
General :: Send SMS From Access
Apr 10, 2014how send SMS to phone by using text from access form.
View 3 Replies View RelatedGeneral :: Get Database To Send Email?
Jun 11, 2015I need a form that will send a email to certain contacts depending on which box is ticked
Have never done this previously would this be possible
General :: Emailing With Send Object
Nov 23, 2012I am using a command button to email an invoice to a customer using the sendobject function, whilst this almost works correctly it is adding an additional mailto:address along with the correct email address.
Example: CorrectEmailAddress and then#mailto:CorrectEmailAddress
The code I am using is:
On Error Resume Next
Dim Cusemail As String
Cusemail = Nz(DLookup("Email", "invoiceemailQ", "orderID=" & OrderID), "")
If Cusemail = "" Then
MsgBox "No email Address"
Exit Sub
[code]....
General :: Opening Email To Send
Nov 7, 2012I found the code below online and added it to a process I already use. It works great for what I need to do right now. The code opens the email with the email address, the file attached, and a message in the body. The only thing that is missing is the subject line, which is the month of the report.
It is a monthly report sent via a text file to another group. The form that I send this from has a table as the Control Source. The month is in that table. I can put it on the form and hide it so that it can be accessed. How to add that below so that the month would show up in the Subject Line of the email?
START OF CODE
Dim objOutl
Set objOutl = CreateObject("Outlook.Application")
Set objMailItem = objOutl.CreateItem(olMailItem)
'comment the next line if you do not want to see the outlook window
objMailItem.Display
[Code] ....