I want to 'save' certain emails from a linked inbox folder. the folder takes its info from a IMAP email account and I want to be able to archive old messages from this to the database so the are not removed from the database if they are deleted from the IMAP account.So here's what I have got:
Code:
strSQL = "INSERT INTO SavedEmails ([Sender Name], [Subject], [Received], [Content]) SELECT [Sender Name], [Subject], [Received], [Contents] FROM Inbox WHERE [Sender Name] ='" & Forms![assignEmail].OpenArgs & "'"
When I execute this code, it gives me an error: Runtime Error 3001 - invalid argument. When I select debug it just points to the execution of the SQL and gives me no further information. The openArgs for the form is basically just a name
I need a way of saving a copy of an email in Access. I am using Outlook for an email client. I have heard I can create a command or procedure in Outlook that will open a window (combo box?) with case numbers linked to an existing Access database. By selecting the case number a copy of the opened email will be created that can later be accessed (no pun intended) through Access. Is this possible?
Hi all, Anyone else having trouble with the inbox time in their outlook after this new time change? ive updated the hell outta the computer and the timezone change settings, but i cant seem to figure it out. time settings within outlook are right, but recieved emails are an hour ahead. Anyone else getting this?
I have attached an image of the 2 tables concerning my question.
The main "transaction" table is the tblAssessments and a linked table tblRisks drives a subform - showing multiple Risks per assessment.
The field "OccupantID" identifies the facility where Assessments are done (there are other tables, of course).
I am using an OccupantID "00000" to store templates - pre-filled assessments with most common options selected.
I am trying to develop code and/or query or SQL that would do this:
copy all templates (records from OccupantID 00000) and corresponding sub-records from tblRisks into the same tables, but under a different (selected by user) OccupantID.
I have no problem just using an Append Query (actually a SQL statement in VBA with variable parameters), but that only lets me copy into 1 table - so I can copy just the tblAssessments records.
but how do I then copy the tblRisks related records and make sure I attach them to the correct AssessmentID?
I have an Access database with linked tables from Sybase SQL Anywhere, via an ODBC data source. I have just linked the tables recently, all the data used to be in native Access tables. It is fairly common for members of our team to open these tables in datasheet view, and copy/paste several records to create new records, then edit a few fields on the new records. This used to work fine with native Access tables, but when we try it with the linked tables we either get an ODBC error - "primary key value already exists" or the new records show up with #Deleted.
The root of the problem is this: In the old Access tables, the primary key was an autonumber field, and Access was smart enough to assign new ID's when you copy/pasted records. In the linked table, the primary key is type "Number" in Access, and Access is not smart enough to let Sybase assign new ID's when you copy/paste records in datasheet view. Access is trying to force the existing ID's into the primary key field, and Sybase says "too bad so sad".
Of course, I could just write some quick append queries to copy/paste the data. And in the short term, that's exactly what I will have to do. But is there any way, long term, to allow members of my team to do it the "quick & dirty" way by copy/pasting in datasheet view? I have tried to change the primary key to an autonumber field in design view, but Access doesn't allow that. Is there a way to do it in code, or a way to force Access to allow Sybase to always handle the primary key field?
I want to copy three of my tables from the back end to another database (backup) at regular intervals. When using docmd.CopyObject and docmd.TransferDatabase it is the link that get copied (naturally) and not the table itself.
I have an MS Access accdb with linked SQL Server 2012 ODBC tables. I am working on a procedure to copy data from local tables to these linked tables (identical schema). I did a simple
Code:
DoCmd.RunSQL "INSERT INTO linkedTable SELECT * FROM localTable"
This works, but is very slow. Way too slow. (INSERT copies the data one record at a time).
I would like to copy the data in a bulk operation, or operations that I can execute programmatically.
Well, heres the situation. I have a complicated query that refuses to work all the time using a linked table for the data (data is gathered from a FoxPro DB). If I copy the data into a local table in my database then the query will run fine.
The data needs to be updated only 1/month but I don't want to have to do it manually every month. I would like to use VBA to copy and paste the data from the linked table into my local table. Does anyone know of an efficient way to do this? I'm trying to avoid running a VBA loop and adding each record one-by-one (very slow).
I have created a DB with many tables and I want to find a way where I can retrieve all the emails from every table (each one has a column with emails). Does anyone know what to do? If a record doesn't have an email address do I have to type N/A or just leave it blank?
I have created a database system to book appointments between tutors and students in a school.
In the form, I want tutors to be able to send appointment details to students via email. I have created tables consisting of these details, however I don't know how to set it up for emails to be sent.
I am finding this very difficult especially with the visual basic codes. :confused:
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.
I recently posted a question in the REPORTS section asking if it was possible to generate a report that contains only the email addresses of my contacts to generate and send a mass email. There were no responses to that...so that makes me ask - Is there anyway in Access to generate mass emails using only the email address field in a table or query?
I am aware of other programs you can buy to do that - but was hoping to stay within Access.
I am sending emails when the user press a button, but the problem is:
1 - How to check is LNotes is open 2- How to know if the user needs to enter the password.
With the following code an email is sent ONLY if notes is open AND the psw is not required.
Public Sub Sendmailf(Task As String)
Dim nSession As Object Dim CurrentUser As String Dim DataBaseName As String Dim nDatabase As Object Dim nMailDoc As Object Dim nSendTo(60) As String 'array for 60 e-mail address Dim EmbeddedObj As Object
Set nSession = CreateObject("Notes.NotesSession") CurrentUser = nSession.username DataBaseName = Left$(CurrentUser, 1) & Right$(CurrentUser, _ (Len(CurrentUser) - InStr(1, CurrentUser, " "))) & ".nsf" Set nDatabase = nSession.GETDATABASE("", DataBaseName) Call nDatabase.OPENMAIL Set nMailDoc = nDatabase.CREATEDOCUMENT With nMailDoc
I apologize ahead of time if this has been asked before but I can't seem to find it anywhere.I need to create an email using email addresses from an access table. I used the sendobject syntax in vba to test the process.DoCmd.SendObject acSendReport, "copy2nd", acFormatXLS, Me.cboMngEml, , , "Entitlement Review Report", , FalseHere are my questions:Is there a better way to do this?If I chose to do it with the sendobject method, am I limitted to 255 chars for the body of the email?Can I use a draft email I created in Outlook? If so, how would I do it?I am using Office 2003 SP2 in WinXP SP2. If you need more information, please let me know.Thank you.
I need to find out which emails in our database have our domain emails mispelt incorrectly.
For example, our domain email should be miguelangel.duo@leoburnett.es but it may be mispelt miguelangel.duo@loeburnett.es. How can I run an SQL that return the
FirstName, LastName Email from the Extract080907 table with mispelt email domain names?
I am using a form to send an email but part way in the process a message box pops up with 2 buttons labeled: Allow and Deny with some other information. I am forced to select allow in order for the send process to be completed.
Is there a way to prevent this popup so that the process completes smoothly without interruptions?
I would like to import emails from outlook and I would need to select the fields which are required. It is importing some standard fields and the fields i would require is not part of that. ( For instance "Categories" field which is present in outlook)...
I have a client that has several users that need to send out multiple reports that are stored on a shared server drive. These PDF's are logged into a SQL database and the location of where they are stored each day and kept for several years. Is there a way to select several of these reports and attach them to an email that they can send off easily using Access 2010 or 2007?
I have a database with a number of linked tables that are linked to tables in different databases (not a back-end).for example, I have table1 that is linked to table1 in K:databasedb1.mdb.table2 linked to table2 in S:datadata.mdb.and so on...
However, recently we have moved all our databases to a new location.
K:databasedb1.mdb is now residing in O:masterdatabase and S:datadata.mdb is now residing in O:masterdata and so on...
I'm now in charge of relinking all those tables to point to the new location.I would do this in linked table manager one by one but we have 100s of tables linked to multiple different databases in different location.is there a way to create a VBA code that will automatically do this re-linking process?
so, 1. find unlinkable tables 2. search its new location under O:master 3. re-link it to the new location
Database names and tables names have not been changed. Just the location of databases.
I'm working in Access 97 (though I can use Access2000) and Outlook2000 and am trying to write a process that will go into a specified folder in a user's outlook and pull in the data from the emails there. The data will be in a standard csv format - but my biggest problem is trying to figure out how to systematically go into the folder, import the data from the email, and then move to the next email in the folder...
I'm sure this is here somewhere but I just can't find it.
I have a form where a selection of suppliers are selected, I then want to email each supplier a report attachment - headed up with their particular details - for them to complete and return.
I can use the SendObject to send one email with all reports attached, how do I split it up? Can I split it up?
hi i am trying to copy emails from a ms access document for work. (there are about 6000 of them) when i go into the data base...under the emails column i see ALL this
åëîõôèÀðáõìèåííåò®ãïí
its just lines of that! if i cant copy all the emails this way, i will have to do 1 at a time with a program and it will take me literally 10 hours
please help i dont wanna get fired lol
how can i copy the emails. In the program, the emails are all normal (you kno....like myemail@here.com) but in the access document, its like that
I am building a databse that registers all communication between a company and a customer. here is my question. If customer A sends an email to the company how can I store that email in my database. I dont want to copy and paste the contents of the email to a memo field. Is there a way to automate this?
Can someone help me try and figure out how I can get my code to not just pull the first email based on a dlookup from a table...
I am looking to enter information in a form and have outlook populated with to specific email addresses based on a groupid in the table. Right now this code works fine but only returns 1 email address not all with the same GroupID.
Private Sub Command27_Click() On Error GoTo Err_Command27_Click
Dim stWhere As String '-- Criteria for DLookup Dim varTo As Variant '-- Address for SendObject Dim stText As String '-- E-mail text Dim RecDate As Variant '-- Rec date for e-mail text Dim stSubject As String '-- Subject line of e-mail Dim stWho As String '-- Reference to tblUsers Dim stEvalEmp As String '-- Person who assigned ticket Dim stDelBidPrice As String '-- Delivery Bid Price Dim stOverBidPrice As String '-- Override Bid Price Dim stOverMeanPrice As String '-- Override Mean Price Dim stOverOfferPrice As String '-- Override Offer Price
'-- Combo of names to assign price change to stWho = Me.GroupID stWhere = "ClientServices_tbl.GroupID = " & "'" & stWho & "'"
'-- Looks up email address from ClientServices_tbl varTo = DLookup("[ClientEMAIL]", "ClientServices_tbl", stWhere)
