• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

vba code

  1. K

    Selecting a folder from an entry in a Listbox

    I have a large number of folders in my inbox and also multiple levels of folders. I have written a macro to prompt for a snippet of text then return all folder paths containing that text. This works fine and produces a nice list. However, I then have to fumble around trying to locate the...
  2. Z

    Adding dropdown list using custom form

    I'm trying to add project codes dropdown at custom form. Once user selected the project codes, it will display it at the end of the subject. This is the code that I have right now. Everthing working fine untill when I received the sent email. The email wont automatically open like normal...
  3. W

    Save and rename outlook email attachments to include domain name & date received

    Hi all, I'm not a developer and quite the beginner. I work for my family on a farm and we have a heap of invoices coming in each month via email and I'd love to be able to create a macro that allows all attachments that are invoices or statements to be saved to a file on my computer. I have a...
  4. E

    Copying data from e-mail attachement to EXCEL file via macro

    Hello, everyday I get several e-mails with either an excel or PDF file attached that has the following body: Code: 1000 Date Company Currency Amount text 11.11.2018 AAA Dollar 1000 bla 11.11.2018 BBB Dollar 1000...
  5. D

    Outlook 2016 How to handle filing of emails from an Inbox Subfolder to a specific Public folder

    Environment is Office 365/Outlook 2016: My client has recently noticed that when they go to manually move multiple emails from their Outlook inbox to a "project specific" Public Folder it hangs Outlook until the move process is completed. The more emails they select to move, the longer the user...
  6. Bri the Tech Guy

    Run Script rule not running for newly arriving messages

    Hello All, First a bit shout out for Diane Poremsky, who's assisted me extensively to get me to this point. A bit of background, just so you have it. I have a visually-impaired client who does freelance medical translation work where job offers come to him, and a variety of other...
  7. J

    VBA Run When Reply

    Hi Diane, can you help me with VBA code to be used in Outlook 2013. This is what I would like to do: 1. I will select Reply To All and then run the code. 2. The code will add an attachment, insert certain text to the top of the body of the email reply, and insert my signature under the text...
  8. B

    Outlook 2010 Emacs Dynamic Abbrev Expansion, Esc-/

    Looking for an Emacs Dynamic Abbrev Expansion like macro for Outlook. If I have already written "epäjärjestelmällistyttämättömyydellänsäkään" in my email msg. Then start writing "epä" and give the Esc-/ command epä is expanded to epäjärjestelmällistyttämättömyydellänsäkään. Saves a lot of typing.
  9. A

    Cannot Figure Out This VBA

    Hello there - I cannot figure out how to use this VBA. It is actually a "ready-to-use" script that I took from offline but I am unsure how to use it as I am a learning, VBA-Novice. Please help me if any of you know... Thank you! Private WithEvents m_Items As Outlook.Items Private Sub...
  10. K

    ind specific Subject line from outlook and copy the content of the email body to exce

    I have group mail box in we receive mails frequently with Subject line "Request ID 691941: Call Lodged", here 691941 keep changing with request coming in mail box and remaining will be same. what I would like to do is; My Macro should keep reading the group mail box when ever it sees a new...
  11. K

    How to find specific header and copy the mail body

    Hi Team, i have gone through many outlook forums and could not able to figure out correct code for my requirement. i have group mail box in we receive mails frequently with Subject line " Request ID 691941: Call Lodged " here 691941 keep changing with request coming in mail box and remaining...
  12. J

    Auto Forward - Include Attachment and change Subject depending on original sender

    Please help me create a script that will help me save A LOT of time. I need an auto forward that will include the attachment, all to the SAME EMAIL, but I need to change the subject based on who I received the email from(up to 5 different ones). Maybe an IF statement or WHILE loop? Any help...
  13. P

    Outlook Randomly Not attaching (attachment file)

    Hello. I am using Office 2013. I have excel vba working great except for outlook doesn't attach the file 100% of the time. Sometimes it attaches and sometimes it doesn't. It only acts up for remote (out of the office) individuals. The excel macro runs and attaches an email in outlook and saves...
  14. P

    Macro to attach a file in a shared Outlook draft folder

    Hello. I am trying to do the following. Run a macro in Excel which will attach a file in Outlook (Office 2013) and save in the draft folder of a shared department folder. I will then go to the shared department Outlook account, review the email and click send. I need the email when received by...