outlook

Hello - I'm trying to set up a Macro (or open to ideas) to auto create an outlook reminder from excel. The issue I'm running into is that it is a shared workbook and each row has different information. A B C D E F G H I J K L M N O 1 Date Notified PSID Employee Name Job Title MA Work...

Hi, I am hoping someone could please help me. My situation: I have to send information from excel via email, individually to different recipients. The subject lines change every day but are constant for across all recipients. The body of the email is always individualized. Example: email...

I have a code built that, upon clicking a command button, displays an email to a coworker when a cell in column P is "X". When a cell in column P is updated a date stamp is automatically entered into the adjacent cell in column Q. How do I update my code so the email displays only if the...

Dear Forum, I have this code in Excel VBA: Sub Outlook_Mail_Every_Worksheet_Body() Dim OutApp As Object Dim OutMail As Object Dim ws As Worksheet With Application .EnableEvents = False .ScreenUpdating = False End With Set OutApp =...

I have below code where the Macro fetches mail from the source folder "Testing". But i want to add another logic where it picks only unread mails plz help Sub Save_Attachments_From_Emails_to_word() Dim folderPath1, folderpath2 As String 'Check and create folder for the word...

Hi everyone, First time posting here. I am in no means an expert with VBA, I usually go through google and try to mix and match codes. I'm stumped with the current project I'm working on. What I'm trying to do is have a vba code wherein it will send the current workbook I'm working on as an...

Hi everyone, I get an email every week that has with a table in it that has numbers. I usually open the email, and just enter the data manually in my excel template that I use. I was wondering if there was a way or a macro which can pull this email, and copy the data into my spreadsheet? the...

Good afternoon everyone! I am an absolute rookie when it comes to VBA specifically, but fairly strong with excel. I had a problem I was trying solve to help me determine what percent of my time I am spending during my weeks on specific categorical meetings via Outlook. Essentially exporting my...

Is there a way to force mailto hyperlinks in Excel workbooks to use Outlook, perhaps using VBA? A user of one of my workbooks phoned me complaining that the link in the workbook, which should open a new email window with the email addresses pre-filled and a short message, opens up Google...

Hey guys, I hope everyone is keeping well! I was just wondering if anyone might be able to lend a hand or point me into the right direction, please? ? I have been experimenting with a few different ways that I could send excel data using VBA but have been struggling with this for some time now...

Hi all, I need some VBA to allow me to send multiple emails (same standard email body but each with their own individual Excel attachment). I'm using Microsoft Outlook and Excel 365 Workbook Entitled: 'Raw Data' Sheet Entitled 'Sheet1' Column A: Email Address Column B: First Name (for email...

Hello All, I am wondering if anyone can help to figure out how to send a macro free version of my workbook by email. I'm not too familiar with using other applications and objects in VBA, especially if I might need to create and delete a temporary workbook. I have seen other examples which...

Hello, I am currently trying to send automatic emails in an excel workbook, but every time an email is sent, since my company is subject to TITUS classification, I have to manually select it in a pop up. I use a regular outlook protocol to send emails I have not been able to find anything to...

Hello, I have a VBA sub sending an email with outlook. I am looking to have some parts in Bold characters. I thought of using .HTLMBody in the code based on some posts I saw. Where’s the catch? Well the parts I’m looking to put in bold characters are variables from a worksheet... I did...

Hello everybody, I am currently following this youtube video: (specifically look at around 07:30-08:30) in order to create an email link in my excel file that people can click on, have a pre-determined email message written and then fill out the blanks and send it out. However, while I tried...

Hello everybody, I am currently trying to create a macro in Excel that, once you click on it, displays a pre-written message (by me) and then allows the user to send off the email from their own account. Is this possible? Furthermore, I know that you can do something like: Set.subject /...

Hello VBA experts, I have a spreadsheet that I would like to add a command button to that would populate an email to the corresponding email address, but only if a condition is met (an upcoming due date). I have tried several versions of code, but none have worked so far and I'm also a beginner...

Hi, this is actually my first time posting on this site I am using the vba code below to send out email reminder via outlook. However, I am wondering how to make specific text which is fixed in the code to be bold, as listed : Event/Activity ; Department ; Date of Event ; Description Can...

Hi everyone, As a new VBA learner, I am seeking for your help to solve these three problems when automatically send Outlook email from Excel. The code is now lacking these improvements. Your support would be highly appreciated. 1. Attach multiple files with file paths by criteria (For same...

Hello everybody, Goal: I am currently trying to create a command button in Excel that, when one clicks on it, sends out an email to me with an order that one has entered into Excel. The following link here: Using Excel VBA to Send Emails with Attachments - wellsr.com has a nice VBA code that...