excel & outlook 2016

Hi Folks, I am looking for some VBA code (to run from Outlook) that would: a) open an excel workbook, and b) refer to a worksheet with "source Outlook FolderPath" and "destination Outlook FolderPath" ---e.g., ws("MoveFolders") col A and B---and c) use this data to move any folder/subfolder in...

Hi Folks, I have searched the web for 'Outlook VBA code' that can query an Excel worksheet for the Outlook source FolderPath and Outlook destination FolderPath i.e., to use in an Outlook move-folder event. So far, I've only been able to find Outlook VBA code that moves multiple sub-folders...

Hi Folks, Basic aim I am looking to automate the adding of new email folders to Outlook 2016 for new jobs that come into our office. We are using Microsoft outlook 2016 through a MS 365 contract on an exchange server controlled by Microsoft. Detail I have created an excel model for...

I have a problem choosing the correct signature when sending mail from Excel via Outlook (Office365). I have 2 accounts set up in Outlook, one is primary email and the other is secondary email with both having different default signatures. Secondary email is a shared mailbox, but added as a...

Hi, I went through http://www.rondebruin.nl/sendmail.htm however it did not help since I am not much familiar with writing VBA code. Can anyone help me with VBA to send email based on values in Excel pivot? I have embedded a sample excel file below:- I need separate email where column A...

Hello When I run my send email macro, the excel sheet data that populates in the email body has errors in one column. Eg: In the workbook the values are reflecting as <tbody> 3/9/2019 22:00 </tbody> But in the email body the values are reflecting as 3/8/2015 22:00 Why is this happening...

Hello, I have been trying to set up an automated email system based on expiration dates of research supplies. I have set up a code in VBA that can send out an email to the appropriate employees based upon when the supplies have expired. I would now like to include specific cell data from excel...

Hello, I'm Looking for an excel Formula or VBA code to color (highlight or background fill) columns based on the count series of max frequency consecutive positive numbers. It should be left open ended for more data to be added after column P and Lower than row 5. Rows described: 1. max...

Many years ago, I got hold of a macro to list file names in a folder and its sub folder. All worked flawlessly until work updated to Excel 2016. The macro is no longer listed in the macro lists to use. It does use a private function to create the list that populates the spreadsheet. Even if I...

Hi, I am wondering if anyone can help. I am looking to use VBA to email a range on the active sheet the button is on. Range is B7:M33. I would like the range to be attached to an email in PDF format, I have a another sheet called "Setup" which has the email addresses, subject and body. I am...

I am trying to automate a template in outlook to automatically fill out certain fields based on data provided within the spreadsheet. The spread sheet is called "Progress Report" I want to grab the clients name, which is located in Column A I want to insert the clients membership number which...

Hello, I am currently struggling on how I can rank a subsection within a section based on a #. To make this easier, I will explain it like this. I have 4 separate "portfolios" in column "I". I have Different sub customers within those portfolios in column "K". I would like to rank these sub...

Application - Excel 2016 & Outlook 2016 My OLD MACRO code worked fine in Excel 2010, now we have been upgraded to Office 365 (2016), and my coding debugs at the ".send" command. Run-time error '287': Application-defined or object-defined error" and the .send is highlighted in yellow. I was...