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...
I have a text file that is in the following format (8 values per line)
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...
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)...
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
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.
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...
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...
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...
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...
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...
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?
Dim objApp As...
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.