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...
The following codes are created to generate emails to a shared mailbox "firstname.lastname@example.org" draft mailbox. However, at step "Set OutlookDestFolder = OutlookNS.Folders("email@example.com").Folders("Drafts")", I receive the error message "run-time error '-2147221233 (8004010f)': The attempted operation...
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...
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.
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...
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.
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.
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...
I have this code in Excel VBA:
Dim OutApp As Object
Dim OutMail As Object
Dim ws As Worksheet
.EnableEvents = False
.ScreenUpdating = False
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
Dim folderPath1, folderpath2 As String
'Check and create folder for the word...
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?
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...
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...
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...
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...