outlook & vba

Hello! I'd like to ensure the formatting for the table referenced in the RangetoHTML Funtion keep both Date format for the first column, as well as keeps column width to fit the largest text within each column. Does anyone have pointers or code to accomplish this? Sub CreateEmailFromExcel()...

Guys, good morning/afternoon/evening, I'm having an issue with Excel VBA while automating an email send-out. My code sends approximately 17/18 emails and then crashes with the following error: I'm not sure what might be happening, can you help me? I don't think it's Microsoft limiting the...

I'm a newbie at VBA and don't know what i'm doing wrong. I'm simply trying to delay delivery on bulk emails by adding the following line to an existing code someone else had helped me with. msg.DeferredDeliveryTime = "12/14/2023" & "11:20:00 AM" My full VBA code is as follows, but I'm...

Not a VBA expert, AT ALL. I searched for a code to automatically send emails from Excel through Outlook. However, is there a way to stop the code from automatically sending them, and instead create the email pop-up and if all looks good, then I manually click Send? Sub Send_Bulk_Mails() Dim...

Hello guys, How can I make excel send email reminders in outlook based on the given dates In one column. I would like to make it send the reminder with 6 months in advance, do you have any ideas? I have seen it is possible to do so with visual basic but I do not know how to code.

Hello! I know its possible for VBA to send emails via Outlook. Is it possible for the code to view an individual's organization/boss and copy that value into a cell?

Hi all, I am very new and very inexperienced, I hope someone can help me. I have 2 questions see below first one: I want to find duplicate dates for my database, but not working. I want to show how many duplicates too. Private Sub Textbox3_afterupdate() Set rng = Range("E2:E3000") Dim ws As...

Good Day Everyone, I have been developing an Excel app that at some point has to open Outlook. Until a few days ago this was working fine. I am using Office 2010 for the development since it works nicely for backward compatibility. I also had Office 365 on this machine but decided to remove it...

Is there a way to prompt the user to choose an email just like pickfolder?

Hi guys, I am trying to add my Outlook signature that has an image with text (i.e. HTML format) and refer specific cell (i.e. .HTMLBody = Range ("B5"). Value) using Macro to return the Outlook Signature with Email body text that is written on cell B5. I used Ron de Bruin's code (Insert Outlook...

Hello! I currently have a Macro that creates an email for each row of data, then copies and pastes that row into the email. Each row is assigned to an individual (receiver of the email),, but sometimes, the same individual is assigned to multiple rows. I wanted to see if I could change up the...

Good day everyone. I am trying to make this code run so every time I open it so excel automatically checks for expired equipment, put message about it and then send it to Outlook. Ideally i want all outdated equipment to be listed in email too. For example if equipment flagged already as...

Hi, I am basically trying to add text from a cell into the body of my email, I have tried doing it myself but have no luck in getting the text to appear. I am looking to include cell reference D48 from the 'D&P' tab of the current worksheet, and ideally the text from the cell would be be...

Hello, I am attempting to insert my default signature at the bottom of some automatically generated email. The contents of my signature have been copied, however, it lost the formatting. Here is the code I used. Set OutApp = CreateObject("Outlook.Application") Set OutMail =...

Hi all, I have a macro which downloads attachments based on a given Download Path (F1), Date Range (F2 & F3), Attachment extension/ type (F5), Main Folder Name (F6) and Sub-folder name (F7). I want to be able to download attachments in a specific folder in my mailbox but it doesn't work when I...

Hello, i need some help for VBA in my excel i would like to draft in my email in this format from my excel here the example to be send to the emails To: [Send Email To] CC: [CC To] Subject: [Doc. No.] Require Your Attention - [Error Message] Dear Sir/Mdam, We would like to inform the...

I use the code below to count emails by Sender and send to a new Excel sheet. I would like one that will count emails in the inbox by subject line, excluding characters at the beginning (e.g. {EXTERNAL}, RE:, FW:, etc.), and send those to a new Excel sheet. Any suggestions? Sub...

Hi, I have created a code in excel to create an email with a link and paste a screenshot within the email but im having trouble pasting the screenshot below the email body (ideally i would like it a line below the hyperlink, probably a stupid question but is there a way to ammend the code so...

Dear all, Im trying to avoid sending mails out every week with new tasks for people. Therefor i try to create a code that can look at my query data and sent it to the correct person in outlook. I would like to make a code which takes the header and table data for rows with specific name and...

I am on office 2019 and I have been trying to automate my emails to an excel sheet as part of a Ticket System, I know absolutely zero VBA and have just been trying to cobble something together off of some old posts. All the different vba code I have tried keeps creating a copy of my workbook...