outlook 2016

  1. S

    Excel2010 VBA for reminder Outlook2016 emails, three months before review date

    Hallo, I'm an admin and VBA newbie, trying to send automated reminder emails from Excel 2010 via Outlook, three months before the review date (in Column C). I've managed to send an email from Excel :) But can't get any further, have tried the YouTube videos but am baffled and was advised to try...
  2. D

    Multiple problems with macro to delete emails from Outlook Inbox

    I am using Office 2016 and from Excel and am trying to write a procedure to delete specific emails from my Inbox. I have written it to just delete one sender with the aim of looping through a list of senders once this is working. The macro is supposed to move the designated email to the trash...
  3. 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...
  4. M

    Excel VBA to send outlook email - Modify Subject line & Fix attachments

    Hi Guys, So I am a complete novice in Excel VBA. I want to send email using Excel VBA. I have excel sheet in following format Column A - Name Column B - To Column C - Subject Column D - Path of attachment Now, each row of this excel should open a new email. I have modified a code to suit...
  5. WERNER SLABBERT

    VBA to save as PDF and mail PDF to Specific recipient/s from Specific Account with Specific Signature

    Hi there .... i recently found this thread "https://www.mrexcel.com/forum/general-excel-discussion-other-questions/710212-vba-code-convert-excel-pdf-email-attachment.html" that does more or less what i want in my VBA but implementing it into my Current VBA is no easy feat, would anyone be so...
  6. S

    Macro skips some of the emails when sent in large number (via VBA outlook)

    Hi. I have created a macro to which works as below First part one procedure refers a CSV file, create mails based on the row input & saves them in draft folder. this is important because I want to review mails before sending them / i may decide not to send / send later.... Second part other...
  7. J

    Outlook VBA newItem.Attachments.Add - adding excel files from folder, skipping to next file if first file not available

    I have a very simple code that I have created in outlook where the code will pick up an email template that was created, open it and add files to the email. I have the designated path for vba to pick and choose the file. My current problem is that sometimes the file in that path/folder may not...
  8. G

    Not able to loop for converting range into image

    Dear All, Please help me with a vba code to convert a particular range to an image through looping. I'm using the below code, however I'm not able to convert range into image through looping. I'm using excel and outlook 2016. Sub sendMailj() Dim TempFilePath As String Dim...
  9. P

    VBA - Connect excel with Outlook

    Hello, I have a problem with VBA when trying to look at multiple cells and compare them to a criteria. I am new to VBA but I dont understand why this problem is happening. The matter at hand is, that im trying to link excel with outlook in order to get my work shifts from excel into outlook...
  10. R

    Automate emailing current workbook to end users

    I currently have a workbook that employs userforms that my end users fill out to send in part maintenance requests. Once we receive the workbooks from the end users I process their requests into out SAP system. Once I process the data, I have to click the email icon in my quick reference bar to...
  11. S

    Excel/VBA Creating Outlook Appointments from Spreadsheet Data

    I'm trying to create a macro that will create appointments based on task from column B. For some reason, my code to create appointments is creating each item in the subfolder twice. Also, I'm trying to get the appointment date to be column F -30 days. Ultimately I would like to have this macro...
  12. S

    Excel 2010 VBA send email doesn't work with Excel 2016

    Hello, Recently my employer moved from Office 2010 to Office 365 (Office 2016). Now my macro's that contain sending emails no longer work and when ran the error and provide a Run Time error '287': Application-defined or object-defined error. Hit debug and the .send command is highlighted in...
  13. F

    Excel auto email from Outlook going from Office '07->'16

    Hi folks! We've just updated from Windows 8/Office 2007 to Windows 10/Office 2016 at work. Some time ago I created a help file for invoice posting that had a built in auto email feature if certain conditions were met. To my horror I now realize that the auto email that Excel sent through...
  14. K

    Exporting Attached Excel File in Outlook to Another Excel File

    Hi, I would like to export data from an Excel file attached to an email... to another Excel file... and I would like to do it (if possible) by mass exporting all emails within a specific Outlook folder. The 2nd half of the code (the exporting from one Excel file to another... I've got down)...
  15. T

    VBA code to email staff when their assigned a new task in excel

    Hello All, *Working with Excel and Outlook 2016 I need a code that will send an email via Outlook, to the person being assigned a task, but only at assignment, not every time the workbook is opened. When we have a new assignment, it is entered by management. The new staff is assigned in...
  16. M

    Open Outlook Email Template and Send to Multiple Recipients

    Good Morning All, I am trying to create a macro that will open a template email, allow me to insert the individuals' names in the body, and send each email independently (not one large BCC bulk email). I have only found a macro that will send one email with all of the emails grouped together...
  17. N

    find specific Subject line from outlook and copy the content of the mail body to excel

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

    Read ICS file using Excel VBA with Outlook 2013/2016

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

Some videos you may like

This Week's Hot Topics

Top