Search results

  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:
  16. A

    Email Subject and Conversation Topic

    Hi Diane, I found some code elsewhere that suggested the Conversation Index could be set to null using redemption. The code I'm trying to use is below. When I run it I get no error message and the Conversation Index isn't being set to null. Any ideas? Sub convdel() Dim objApp As...
  17. A

    Email Subject and Conversation Topic

    I was hoping that I could take the Conversation Index Value prior to changing the subject and storing it as a String and then after the subject is changed I could change the new Conversation Index to the original Conversation Index. However the Conversation Index is read only so that doesn't work.
  18. A

    Email Subject and Conversation Topic

    I've had a look at what is happening when I change the subject. The Conversation ID and Conversation Topic are not changing however, the Conversation Index is changing. I'm assuming this changing is why the messages are no longer being grouped in a Conversation.
  19. A

    Email Subject and Conversation Topic

    We are running Office 365 so fully up to date I think. Not sure what version of Exchange but suspect that will be pretty much up to date too.
  20. A

    Populate Excel from Outlook Userform

    yes Diane that's what I used
Back
Top