outlook

Hi all, I've got a script for Outlook that *should* delay sending emails Mon-Fri after 1800, and any time at the weekend, until 0700 the next weekday morning. It seems to work Mon-Thu, but Fri-Sat it just sends it the following morning rather than waiting until Monday morning. Can anyone help...

Hi All, Its been a while and I was hoping to learn more of VBA Coding. So here I'm with a request for VBA code to export outlook email (individual) to an existing excel file. So here is what I'm wanting the code to do: When I open an email in Outlook and press a hotkey (in groupmail inbox)...

Hi all, I have excel template where data are updated, once the data is updated i would like to copy the contents from each column and paste it in the table with blank column in the outlook .msg file which i have saved in my desktop currently, I have attached the screen shot of the excel sheet...

I'm having trouble coming up with some code to attach an Excel full file to an Outlook E Mail. The issue is that I'm trying to have the code first save the file with a modified name, using the contents of a cell. For example: If the file is named "Sales By Customer", I have built a macro to...

Good morning incredible excel people! ? I hope you’re all going well this sunny weekend. I was just wondering if someone might be able to help point me in the right direction or if you have any ideas that would be greatly appreciated. I have the below module that takes two sheets and inserts...

Hello all, I have some code that would send an email for me. But after having Outlook updated or reinstalled, now it no longer works on this particular computer (though this code does work on another computer). Sub DQ_Comp() Dim OutApp As Outlook.Application, OutMail As...

Hi, The company I work for manage a holiday log through excel and have asked if it is possible to automatically update this information into a shared outlook calendar. The spreadsheet contacts a list of dates along row 4 (E4:NE4) one column for each date. And a name for each person in the...

Hello everyone, I'm currently doing a little project and would like to automatically update an Excel sheet based on the information taken from an Outlook mail from the Inbox folder using Outlook VBA. So while doing my research on the topic, I found this topic Macro to read email and update...

Hello Friends, I am trying get email addresses of a list of users present in Sheet1:C. User's names are like: "FirstName LastName" eg. John Smith. First iteration completes but 2nd iteration giving error. Please find the error screenshot attached. Following is my VBA code: Sub...

Hey guys, Hopefully this is okay to post in a primarily Excel-based message forum. I just have a question about an oft template that my company has available. When double-clicked, it opens in Outlook. Basically, it is saved as an .oft and there is just a bunch of text in the message body...

Hi Everyone, I'm hoping you could help. I'd like to create an Outlook calendar meeting request each time a spreadsheet is saved, the meeting requests needs to be added to a shared mailbox so that all users that have access then see the meeting invite. So far I have this setup so it adds an...

Hi there, I am using the code below to email out a report (using task scheduler & macro launcher to email our daily). The report I'm emailing out contains macro buttons, relating to two modules (Module1 and Module2). The code below works as far as sending the workbook as an attachment, but...

Hi. I have this VBA code that copies the current range starting from A1 and emails it out. It works however, the body text gets put below the pasted info and there is no signature. If I remove the body text the signature is there. How can I edit this to put the body text on the top and still...

Hello Gurus, I've just been asked if it is possible to create some VBA that sits in a master workbook (Excel 2016) that will collect or merge data from hundreds of identical files that get sent to an Outlook 2016 email account as attachments and then move the emails to a named folder in Outlook...

Hi, The following codes are created to generate emails to a shared mailbox "abc@de.com" draft mailbox. However, at step "Set OutlookDestFolder = OutlookNS.Folders("abc@de.com").Folders("Drafts")", I receive the error message "run-time error '-2147221233 (8004010f)': The attempted operation...

Hi all, The goal of the script is to display an email containing one or more attachments and a screenshot of the details of such attachments for each one of the clients within a column. The attachments tend to be Invoices and a single customer may have one or multiple. As of now, I have the...

Hi, I have a spreadsheet with names in Column A and email address in column B. There are PDF attachments for all names mentioned in Column A, in a single folder. I found a macro that can send an email to all recipients mentioned in column B, and attach the corresponding attachments from that...

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