Receive email from POP3 server with Access!
Connecting to Email Server
Why does it take between one and two minutes for me to access the server of my email provider (WOW) through Outloook 2003?
Recently, it takes me 1-2 minutes to get access to the server from which my email comes. Prior to that, access occurred virtually instantaneously. Don't understand what has changed and why the delay. My provider (WOW) says the problem is not theirs.
Selecting email account from exchange server for automated email
Is it possible to set which email account from the exchange server is used when sending automated email from access.
Also is it possible to avoid the security warning from outlook without a paid add in or dll, as I have a multuser environment.
Can Access email via Yahoo or PowerShell ?
Forum, Access 2000 on XP sp3
We are emailing direct from Access and very pleased with.
Our Outlook Express screen pops up when Access wants to send an email.
Outlook Express holds our dns server info.
Have just got PowerShell to work so it tidies up some of our filing from the Access .pdf files saved with our Stephen Lebans code - great stuff.
PowerShell also forwards our incoming faxes by email - the code refers to our DNS Server.
Now the Problem.
We want to travel over Xmas and do work with our database on a notebook.
So can we use Yahoo for emailing from Access?
Yahoo of course is web based and we won't be taking our dns server with us.
Powershell is supposed to be able to send mail via Yahoo but can Access also do this?
It would need to hold our login name and password plus the smtp server name.
Or would it be easier to get an email address in New Zealand and use that?
Trust the post makes sence and appreciate any advice etc
CDO Gmail Email Failure
We are using MS Access database to send email to a recipient. We have designed it in Visual Basic that is supplemented with any Access application. Each user has to give its gmail email address and password.
Suddenly, some users can't send email now. On clicking the 'send' button, after a while, the database displays this message "The message could not be sent to the SMTP server. The transport error code was 0x80040217. The server response was not available".
But some users can send email. What is the reason for this message and how can it be solved
Email using contacts in Access 2010
How do you send and receive emails using contacts in your database through Access 2010, also file/lookup email history by contact
Resume Parsing into Access
I work for a recruiting agency and use Access to manage applicants. I receive tons of resumes via email and have to manually enter candidates' information (name, phone number, email, etc.). Is there a way I can import a resume from a file and have Access parse information into a form to help eliminate the manual entry
Automated import from daily email
I am curious to know if I can run sql on the back end of a access database and grab an excel attachment from a daily email I receive and put it into a linked table into my database.
automatic import of data
We are building a database to keep track of safety observations.
Everyday, excel files will be emailed to me with observation material (20 items).
I would like access to automatically ping my email, see the excel file and add to, not overwrite data in a table.
This would save tons of data entry as I may receive up to 50 email a day with the file. Also, would each file that comes in as an email attachment have to be named the same
Automate Emails from Query - SendObject
I have a Access 2000 DB where we would like to send emails to recipients from our data base with an accompanying letter. We had hoped that we could create and run a query to filter recipients, then using that data send a word document to all recipients listed in the query (in groups (50) emails at a time to the server. Our server blocks any more as spam). We have up to groups of 250 to send. Also, the mailserver will not accept the bulk email if there is a mistake in any of the email address destined for a local recipient (on the same mail server). In other words I have to trap the error and correct the incorrect email address before the job will complete thru the mail server.
It is a bit beyond my expertise to program. And maybe it's a bit of pie in the sky.
Would someone from the forum would have had this challenge
Looking for some assistance regarding encrypting/protecting forms before distributing to a goup for edits/additions. I know how to encrypt the entire database but need to protect just the form before sending.
Ideally, the individual would receive an email, be prompted to input a password before openning, and then be able to edit the form fields (all within the body of the email) as needed before submitting back to me. Once I receive the completed form, I would be able to review the edits, accept all changes, and automatically input the new information into the original database
Select Outlook account for sending mails
I need to select a specific IMAP-account in Outlook 2007 for each mail, when sending mails from Access 2007 via Outlook.
This code can select an account, but the mails are nevertheless sent from the default account. Scouring the web implies that non-POP3 accounts, like IMAP, can perhaps be tricky.
I have only occasional access to the client for testing, so would like to turn up with a bunch of options.
There seems to be very little info out there, and the .SendUsingAccount is poorly documented. For Outlook 2010 there is some suggested trickery, involving setting up phony POP3-accounts with the same data as the IMAPs, but I really really don't want to go there. Redemption might be a last-stop solution, perhaps.
Does anyone know how to select a specific Outlook 2007 IMAP account from Access
Re-create joins after DBO change in SQL Server
I have been given the task of modifying MS Access queries which have been running for 12 years against an MS SQL Server database.
There are hundreds of linked tables and now I have to re-link and modify the joins. Is there a simple method to do this? When I modified the prefix from the original BGGT_ to DBO_ all the tables were successfully modified.
However, when I attempt to open the queries to re-establish the joins, I receive errors. Some of the queries I was able to modify in Query view. Others I can not. I receive errors such as query too complex.
Access 2007 vs. Access 2010
My computers were recently upgraded from Windows XP and Office 2007 to Windows 7 and Office 2010. I am responsible for three Access databases that are used by some of our affiliates. I recently made changes to those files in Access 2010, and now our affiliates are receiving error messages when they use the files.
The files will not compact - they receive an error message that they do not have the correct version of Access to do that.
I had Access 2007 installed on one of my computers and receive the same error when I try to compact the databases. Thechanges I made included modifying queries, relinking a table from a SQL Server database, and changing a couple of macros.
They also receive a warning that the files are incompatible.
I made new files using Office 2007, imported the objects from the files I'd worked on in 2010, and asked one of our affiliates to test the file. Same issues except he did not receive the compatibility warning.
VBA Code to report syntax errors via email
I was curious if there was such code that will allow any users to report any syntax errors via email for troubleshooting? For example, I have an access database and the user might change the layout of an form when importing a file.
Therefore, the user will receive an error dialog box at this point I will like for the user to be able to click on a button that will send out an automatic email to the database admin to report the error message.
Send Email To Contacts from a Table
I am doing a payroll and leave database for an office for free. I am asked to create a button on the payroll form to send an email and an attached snapshot of their respective payroll to each employee separately. List and email address of people who should receive the email is in a table. I can do it to send it to a single staff member only after each click. But I can't figure out any way to send emails to all staff members individually through a single click.
Looking forward for you
Email from Access From
I am using the code below to email information directly from an Access form. Everything is working fine but I would like to improve in one area if possible. There are many people who will be entering data and emailing it so I would like to be able to change the senders email credentials to a group email address.
An example would be if *** Email address is removed for privacy *** or *** Email address is removed for privacy *** sent an email from the form I want the sender to see if come from *** Email address is removed for privacy ***.
Schedule event - auto generate a report and send out
I need to send a weekly report at 11pm every Friday night to someones email.
I think there are 2 things I need:
1. automatically generate a report at that time.
2. automatically send an email with that report attached.
(maybe 3. attach the report to email, I've never done it)
Right now all my data is located on an SQL server, I'm just using Access as a front-end, and I know how to send emails from Access ( semi-auto - click a button, it will send an email to a pointed person with some data on the current form).
VBA Solutions for email without knowledge of email program
I am developing a database to be installed on computers used by let's say unsofisticated users who work for any of 20 some odd companies. They need to send an email back with a generated multi-sheet excel spreadsheet that I create through access. From all the MAPI and CDO posts I have seen my libraries don't have those objects or methods or I get the send using configuration value is invalid error. I do not know that they all have outlook and the .send method seems to just leave the message in the outbox anyway, making us rely on the user to hit send and receive. Which though simple might be too hard for these people. So I need some suggestions and if they rely on CDO or MAPI then I need a link to where I can download the library and how to register it. I am using access 2003 from an office enterprise edition.
Compile Error : Expected Array
I am trying to select all of the e-mail addresses in a table and display them without duplicates. The table name is "Signed Leases", the column name is "Email" and I am trying to place it in "text4".
I receive an error message "Compile Error : Expected Array" at the "emails(count) =" line.
I am not sure why I receive this error as the array is defined and I receive the error as it tries to populate the first array.
How to embed record content into access database generated email?
I have customised the free template for 'Issue Tracking' available free from the Microsoft Site.
I would like to be able to have the contents of the 'comments' box print in the body of the email that is generated automatically by the database but I can't figure out how to do this?
I would also like to automatically insert a hyperlink in the body of the email that the email recipient can click that will take them automatically into that record in the database. The database is stored on a central server at out office, and will only be used internally.