Recent content by Alan McGowan

  1. A

    Outlook Userform Size

    The problem was only occurring when I was using an external monitor plugged into my laptop. The solution is to select the 'Optimise for compatibility' setting which can be found in File>Options>General
  2. A

    Form Position with Dual Monitors

    Is there any way to ensure a VBA form appears in the centre the screen that outlook is active in? If I have Outlook running on my primary screen I can use code to centre it on that screen. However if I have Outlook open on my secondary monitor the form is centred based on the combined with of...
  3. A

    Outlook Userform Size

    Hello, I previously created a number of different userforms in VB for Outlook and everything was fine. However in the last few months I've noticed that when I open the userforms the displayed size and position of controls, text boxes etc can vary randomly. Has anyone else ever came across this...
  4. A

    Populate Listbox from Txt File

    I have a text file that is in the following format (8 values per line) txt1,txt2,txt3 etc txt4,txt5,txt6 etc txt7,txt8,txt9 etc I am trying to populate a listbox with this information but I'm having no success. I was trying to use code similar to the following but keep getting a runtime error...
  5. A

    Populate Textbox from Txt File

    Sorted by adding the following code Dim myArray() As String 'Use Split function to return a zero based one dimensional array. myArray = Split(txt, vbCrLf) TextBox2.Value = myArray(0) TextBox3.Value = myArray(1) TextBox5.Value = myArray(2) TextBox6.Value = myArray(3)...
  6. A

    Populate Textbox from Txt File

    I am trying to populate multiple textboxes based on the value on each line in a txt file. Dim fn As String, ff As Integer, txt As String fn = "D:\filemail\settings.txt" '< --- .txt file path txt = Space(FileLen(fn)) ff = FreeFile Open fn For Binary As #ff Get #ff, , txt Close #ff...
  7. A

    Read and Write to Text File

    Having thought about it some more what I think I really need is a way to read a csv file and populate a listbox. It would also be good to be able to add to the csv file from textbox's on a userform but this is less essential at the present time.
  8. A

    Read and Write to Text File

    I have created a macro that I use to batch save emails in MSG format to specific folders on a server. At present the folder paths are held in a spreadsheet and displayed on a userform where you can pick which folder to use. I've noticed recently that the macro is running very slowly and I...
  9. A

    VBAProject.OTM Not Found

    Hi Diane, its not a signed macro and wouldn't know where to start in making it signed.
  10. A

    VBAProject.OTM Not Found

    Hello, I have quite a few macros and userforms etc set up in Outlook. One of the userforms is set to load each time a mail item is added to the sent item folder. This has worked for about a year but at somepoint in the last few months each time I load outlook and send an email that should then...
  11. A

    Creating Progress Bar or Status Bar Update

    Good morning, I have an Outlook macro that runs through selected messages saving each in MSG format to a specified folder. Depending on the number of messages selected the macro and can some time to complete. I would like to create a progress bar or status bar update that advises people that the...
  12. A

    ThisOutlookSession

    I have the following code inThisOutlookSession which up until recently was working fine. However I have noticed that it has suddenly stopped triggering UserForm6 despite the condition of UserForm4.TextBox2.Value = "YES" being true. Any ideas why it would stop working? There is no error it simply...
  13. A

    Email Subject and Conversation Topic

    I got the code to work by reinstalling redemption. However it isn't solving my problem unfortunately. I'm actually not sure if I can solve my problem. The basic issue I have is when I send an email I save it (to HD as msg) and keep a copy in my inbox. The copy in my inbox has a modified...
  14. A

    Email Subject and Conversation Topic

    The code I posted above is working? Strange that it doesn't for me. Wonder if its because I'm not testing on an Exchange mailbox
  15. A

    Email Subject and Conversation Topic

    Apologies I am getting an error (I forgot to tick Redemption in references). The error is:
Back
Top