Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. PortyAL

    Working with a selected email in Outlook

    Many thanks Tony. Works a treat. Much appreciated. AL
  2. PortyAL

    Working with a selected email in Outlook

    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...
  3. PortyAL

    Insert hyperlink dialog - current folder

    Thanks for the ideas. The ChDir instruction doesn't seem to make any difference. I'll look into the file dialog idea.
  4. PortyAL

    Insert hyperlink dialog - current folder

    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?
  5. PortyAL

    Insert hyperlink dialog - current folder

    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...
  6. PortyAL

    Select Email from 2nd Inbox

    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...
  7. PortyAL

    Office 365 - Outlook

    Many thanks for this. I will check to see what versions we are getting installed.
  8. PortyAL

    Office 365 - Outlook

    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...
  9. PortyAL

    Outlook 2007 email categories

    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...
  10. PortyAL

    Saving e-mail attachments

    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
  11. PortyAL

    Saving e-mail attachments

    The following code doesn't appear to work: For Each att In email.Attachments att.SaveAsFile Forms!Form1!docfolder & "\" & att.FileName Next att
  12. PortyAL

    Saving e-mail 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...
  13. PortyAL

    Hyperlink to open in specific website frame

    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...
  14. PortyAL

    Export multi-page report to a single page HTML file

    Any suggestions you would have would be greatly appreciated. Thanks AL
  15. PortyAL

    Export multi-page report to a single page HTML file

    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
  16. PortyAL

    "Sendkeys" problem

    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
  17. PortyAL

    "Sendkeys" problem

    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...
  18. PortyAL

    Insert signature in e-mail created by Access

    Hi Got it sorted using SendKeys! AL
  19. PortyAL

    Insert signature in e-mail created by Access

    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...
  20. PortyAL

    Works with Outlook 2002 but not 2003

    Thanks again Jerry. Everything's working now. AL

Part and Inventory Search

Back
Top