excel & outlook 2016

  1. D

    Outlook VBA to Move Multiple Outlook Subfolders With Ref to Excel List

    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...
  2. D

    Outlook VBA - Automating the moving of sub-folders via reference to a source/destination table within an Excel workbook

    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...
  3. D

    VBA to Create Outlook Folders from a List of Folder Names in Excel

    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...
  4. D

    VBA email signature from secondary account

    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...
  5. M

    VBA email from outlook - Excel pivot

    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...
  6. R

    Date error in excel to outlook conversion

    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...
  7. T

    Including specific excel data into an automated Outlook Email

    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...
  8. M

    Highlight Columns- Highlight count series of max frequency consecutive positive numbers

    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...
  9. G

    Running VBA in Excel 2016

    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...
  10. S

    VBA how can I email a range as PDF

    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...
  11. S

    Excel Macro to Auto Fill an Outlook Template Based on Sheet Values.

    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...
  12. H

    Ranking sub sections question

    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...
  13. S

    Excel Email VBA code broke when moved from Office 2010 to Office 2016- Help

    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...

Some videos you may like

This Week's Hot Topics

Top