outlook 2016

Hi Folks, I would need your dearest help in vba code . For your kind info - I need urgent help on this query. Hence, I have already cross posted the same query in other forum earlier (refer link below): Other Forum - Cross Post I would need to perform additional task along with existing steps...

Hi all, Back Ground: Due to the nature of my business I receive a vast amount of emails, many of which I have archiving rules to store in designated folders. A good amount of the emails I would like to retain and some I would like to delete after x days. Here I will highlight that my IT Dept are...

Hey guys! New to this forum, and trying to slap together a project to make my mornings a bit easier. I'm looking to count all of the email in a folder and all of its subfolders, and give me a count of each date in the folder. As of now, I have them exporting to excel and giving me a count...

Hi All, I seem to have hit a brick wall with my code. The main intention of what I am trying to achieve is run a macro in Outlook that saves attachments into a new folder, and the name for that folder and the files need to be based off information in some cells within an excel workbook...

Hi i am using this tracker below , I am trying to automate some processes as much as possible , so as it stands the hyperlinks work and bring up outlook with the fields required , i was trying to get it to populate them as well based on the values in the repsective cells. But i get a value...

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

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

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

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

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

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

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

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

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

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

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

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

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

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