Hi
I use the code below to select an email in my inbox and carry out various tasks with it. At present I choose the email I want to work with by "ticking" it as "Complete" and then running the code from a button in a form. The code works by checking each email in turn and using the one with...
Hi. I'm now using 2013, but was previously using 2010. It is the same in both versions. The insert hyperlink dialog initially displays the folder the db is in. When you say you "directed" your database to the correct folder, was this done by VBA or by just by using the insert hyperlink dialog?
Hi
I have a form in a project database which contains a list of links in a sub form to various files. The main form also includes a default document folder that project. When inserting hyperlinks the "Insert Hyperlink" dialog box initially displays the folder the database is contained in, which...
Hi
I use the following code to select an email from my inbox, save it as a file and create a link to that file in an Access application:
If Me.docfolder = "" Then GoTo nofolder
Dim ns As Outlook.Namespace
Dim sent As Outlook.MAPIFolder
Dim temp As Outlook.MAPIFolder
Dim I As...
Hi
I have an Access 2010 database which uses VBA to select and save emails from my Outlook 2007 inbox as files in a folder. The database also creates and sends emails via Outlook. This works well with my current Outlook 2007 setup but we are currently being upgraded to Office 365. Is it...
Hi
I have an Access database which includes code to identify e-mails in Outlook and perform various actions with them. Up to now I've used the Complete flag to identify the e-mail I wish to select:
Dim ns As Outlook.Namespace
Dim sent As Outlook.MAPIFolder
Dim temp As...
Sorry
The error is on
att.SaveAsFile Forms!Form1!docfolder & "\" & att.FileName
If I "rem" out the above line. The error is then shown on
For Each att In email.Attachments
Hi
I used the code below in Access 2002 to save an Outlook e-mail and any attachments to a specified folder. I recently upgraded to Access 2010 and have found that the part of the code that saves the attachments (in bold below) no longer works. I get an error message Compile error: Method or...
Hi
I have a Access 2002 database for the recording of fixtures and scores etc. in a local sports league. I also have a website for this league. I export reports from the Access database into webpages which I then upload onto the site.
One of the reports I export includes a hyperlink to a page...
Hi
Simple question - is it possible to export a multipage access report to a single page HTML file, i.e. with no Next, Prev tags at the bottom of each page?
Thanks
AL
Been down that way before Joe without much success. I have since been advised to use DoEvents before the SendKeys function, and it appears to have solved the problem.
AL
Hi
I use the following code to create an e-mail. (The original code is quite lengthy so I have deleted sections which are not relevant to my question).
Private Sub Command184_Click()
If IsNull(Forms![form1]![PAR Due1]) = True Then GoTo norespdate
Rem On Error GoTo nofiles
Dim strbody As...
Hi
My apologies in advance for the length of this post!
I use the following code to create e-mails from access.
Rem On Error GoTo nofiles
Dim strbody As String
Dim objOutlook As Outlook.Application
Dim objEmail As Outlook.MailItem
Dim MailTo As String
Dim attnameDR As String
rem Dim fso As...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.