jonnathanjons
New Member
- Outlook version
- Outlook 365 64 bit
- Email Account
- Outlook.com (as MS Exchange)
Hello Dear Team,
Glad I found this forum. I have a request if I may. Could you please help me to create a vba to populate a list box and add keywords to the message body where I place the cursor text. I saw a thread earlier on similar topic "Use a Text File to Populate a ListBox -
Outlook VBA: Use a Text File to Populate a ListBox" . But this only place the keywords to Subject field and not to the message body. I tried my best to tweak the scripts but could not get the text placed in the desired message while I draft an email. My notepad file has url links to several sources and I wanted to quickly have a textbox populated and paste the same in the text cursor while I draft .
As mentioned I tweaked the code provided in link from " oMail.Subject = oMail.Subject & " " & lstText " and changed to "oMail.HTMLBody = lstText & oMail.HTMLBody " But its placing the link only at the top of the message body .I think at line 1 of the message and not at the user defined place. Could you please help to create a code which function the same but paste the result in the message body where I place the cursor text . Really Appreciate your help.
Glad I found this forum. I have a request if I may. Could you please help me to create a vba to populate a list box and add keywords to the message body where I place the cursor text. I saw a thread earlier on similar topic "Use a Text File to Populate a ListBox -
Outlook VBA: Use a Text File to Populate a ListBox" . But this only place the keywords to Subject field and not to the message body. I tried my best to tweak the scripts but could not get the text placed in the desired message while I draft an email. My notepad file has url links to several sources and I wanted to quickly have a textbox populated and paste the same in the text cursor while I draft .
As mentioned I tweaked the code provided in link from " oMail.Subject = oMail.Subject & " " & lstText " and changed to "oMail.HTMLBody = lstText & oMail.HTMLBody " But its placing the link only at the top of the message body .I think at line 1 of the message and not at the user defined place. Could you please help to create a code which function the same but paste the result in the message body where I place the cursor text . Really Appreciate your help.
Use a Text File to Populate a ListBox
Outlook VBA: Use a Text File to Populate a ListBox
This code sample demonstrates how to use the contents of a text file to populate a ListBox. This works for ComboBoxes and TextBoxes. A client adds keywords to message subjects so it's easier to find the messages later but had a problem: if he misspelled a keyword or used a slightly different...
www.slipstick.com