outlook 2013

Hi all, I found some code on the web and am trying to adapt it. I need to categorize and save emails by their subject and time received so that I can reference them in a database. The below code works for new emails, but when i try to save someone's reply it creates an empty file. Public...

Here’s a doozy! I have a spreadsheet with reference numbers and the path to a spreadsheet for each reference number. I would like to search through Outlook for an email with the subject line that includes the reference number, then with that email reply with the specific referenced...

I have a problem with my macro for outlook. I've created VBA as below to change default sender email address in Reply , Forward and New Email. I want to use group email as default sender address for all outgoing email. But it can work fine only for New Email. It does not work in Reply and...

I have the following code for extracting tables from Outlook email. However it only looks at the latest email. I need it to be able match string in the subject of the email in order to identify which email to extract the table from. Can someone please let me know what I need to add to the code...

<!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:AllowPNG/> </o:OfficeDocumentSettings> </xml><![endif]--> *This all Office 2013 on Windows 7* I receive automated emails from an enrollment website and need to pull specific text from the Outlook emails into a spreadsheet. I’ve...

I would like to use my flagged email list to build a to-do list in excel. I need an excel macro that can: 1. Go into outlook (not sure how to tell it to reach from excel to outlook) 2. Find the messages in Outlook that are flagged 3. Copy the subject line, and date that I have set to...

Hi everyone I need your expert help !! Please refer to the code below. The code will be in Excel VBA (I am using Excel and outlook 2013 version) and then run it in order to extract a large amount of email in outlook I have 3 questions and need your help Let's say my "Inbox" has...

Hi Team, I am using the below code for VBA to pick the respective range of an excel and publish it to an automated email after a static line of body which is coded already in the VBA. Also I am looking for the mail to be in HTML format. The code is working fine but not copying the excel range...

Hi, I wonder whether someone may be able to help me please. I'm using an adaptation of one of Ron de Bruins email scripts below: Sub Email() Dim OutApp As Object Dim OutMail As Object Dim cell As Range Dim Src As Worksheet Dim fNameAndPath As Variant, wb As Workbook...

Guys, I am New to this forum. Appreciate your any help in my below issue: I am receiving 200+ emails in outlook everyday as PDF attachment. All attachments are protected with known and Same Password. Is it possible to create VBA to Print all these on Daily Basis? Currently I have to open each...

Hi All, Does anyone here able to read an ICS file(with Outlook 2013 or 2016) using VBA in Excel? Basically I have this ICS file, I would like to evaluate all the events under it. I just need to get the data such as the date start and date end of an event. Also, I need to generate the...

Hello all, I have created an Excel spreadsheet that works like this: a user clicks a .VBS file which opens my Excel spreadsheet (which stays invisible) and runs a specific macro a calendar pops up and the user clicks on a date A particular column within the spreadsheets resets to default SQL...

Hello All! I am working on a problem where I need to... 1. Receive an email 2. Have that email automatically moved to a specific folder 3. Have any email in said folder exported into a .csv file 4. The data in that file must be placed under specific columns. I can achieve all of the above...

So I have a folder labeled "Weekly" with 6 different emails with "Scheduled Report" somewhere in the subject line. I need to create a macro that will copy each of those different sheets and paste them as different tabs in a specific excel workbook labeled "Revenue". I then wanted to label each...

Hi All, Is there any way to access the Auto Replies feature of Outlook 2013 using excel VBA 2013? I want this to work when a button is clicked in an excel sheet. I just really don't know where to start. Is there's any way to do this? Thanks in advance for the help!

Hello, I am working with Excel 2013 & Outlook 2013 on Windows 7 on a PC. I adopted a macro from a co-worker which creates an email. The code is shown below. He was using .Display to just open the window of the email and then he manually clicked send on each email. I really don't want to have...

Hello, Please help, I need vba to email using outlook 2013 specific files to group of people with subject and Message, all information would be on spreadsheet in the row, the code should stop when last row is empty column a and b has to: email column c, d, e and f has CC: emil column g has file...

Hi guys, I have a simple question, but I didn't find any answer anywhere. How do I set Outlook 2013 to offline mode (via vba)?! In Outlook 2010 (or earlier) I used the commandbar.findcontrol(,5613) but in Outlook 2013 this commandbar simply does not exist anymore. I have made a code to...

Hi Everyone, I use MS excel to tabulate a list of prospect/ lead names. The names are in the format Title, First name, Middle name, Last name. Q.1) I need to generate email addresses from the different combinations of the first name, middle name, and last name. The domain for the email...

Hi All, Hope you are all well. I have made an email reporting tool and I am really struggling with this. Each row has an ID number (starting from 1 and on row 2 in Column G). When a reply comes in I need the reply to have its original ID. Tried using entryid but this value changes when a reply...