outlook

I want to know if its possible to insert multiple calendar events in outlook, from excel, with an image, so that when the invite is sent, the user click on the image to go to the calendar event. Can someone please help me? Thanks in advance.

Hey Guys, I have a really annoying manual task I do everyday for work: Receive an email (always same subject and body format) into a shared mailbox in Outlook. In the body of that email it has a client name (again, always same format). I look up the client against the account manager name in...

Hello - I receive an email every day with a link that takes to me to folder. That folder houses a PDF I need to share with colleagues. I've asked that the email contain the PDF rather than the link but have been told it will take some time. Is there a way I can run a macro in Outlook to click...

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