I have an excel sheet with all the details required and my requirement is to email customized birthday cards to staffs. I want the picture to be inserted in the outlook mail body rather than add as an attachment. The email should go on the birthday dates at the specified time.
I have the...
Hi!
I'm getting a pop up in outlook when I run vba code in excel.
"A program is trying to access email address ifnformation stored in outlook. If this is unexpected, click deny and verify your antivirus software is up to date..." it has me allow, deny, or allow access of X minutes. If I click...
Hey
We have a database which we update daily and need to send an email to separate people based on the input. My code check selected cells per rows creates the emails. My problem is we need to manually check if we select cells from the same person otherwise we send it to the wrong person. For...
Sub COOutlookReminder()
Dim OutApp As Object
Dim OutMail As Object
Dim strbody As String
Dim myRequiredAttendee As Variant
Dim Address As Variant
Set OutApp = CreateObject("Outlook.Application")
Set OutMail =...
I've an issue to export attachments from outlook to excel cells. The attachment is not the filename, but the file itself. For example, if PDF file, it will extract the PDF file to the cells, not the filename or the details inside of PDF. I know how to save attachment to the folder but not on the...
Hello :)
I have a problem with my macro that should find me a lowest result in the column and add 1 to it.
Macro is started from my outlook and should work on unread emails in my Inbox.
Result of Macro should be name of subfolder where my email should go.
In Outlook I have code:
Public Sub...
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...
Hi!,
I use this code (within my Outlook) to drop my e-mails in a folder “MAILTRANSIT”. It works fine, but I’d like to expand it with some additional features.
For the moment, MAILTRANSIT has 2 subfolders to which BrowserForFolder leads me automatically to make my pick for the drop. But I’d...
Hi guys,
I have an excel file with a table, where I have clients and providers emails in column C.
I have the subject in cell G4
And I have the body of the email in cell G5.
I have a code written, but, it's not working as expected.
I was trying to loop through column C and past the emails to...
Hi, I am facing problem for Task Scheduler to run a excel macros. When I run the Vbscript in Task Scheduler, the status shows running but nothing happen. I open the excel file manually and it shows below reasons, so i have to end the excel using task manager to let me access to the file again...
I am trying to create a code that can create Namelist amount of emails. Each email should include some specific cell variables such as name and email AND a table in which i need the header from the excel sheet and a specific row.
I have tried to incoporate a take one row at a time approach but...
I created a code for exporting calendar appointments from outlook. It runs perfectly for me, however we get code 13 error on one of my collegue's computer who is supposed to use the macro. The error is at the "Next" line, and she uses the same outlook version as me.
Can anyone please help me...
Hello everyone,
I am still new to VBA and would highly appreciate if anyone can help me in this struggle i'm facing.
I've tried read in forums and else but didn't have any thread that meet my condition.
The goal is, i want to make an e-mail reminder update document to all the Updater regardless...
Hi All
I am working on a macro for an Email that will send some request to recipients. We are scrubbing the data on the responses so need them to respond in a certain way. I am trying to get the templates to auto-populate in the return email. I currently have the below coded up which is giving...
good afternoon all,
I've been tasked to contact over 500 companies my work deals with on a regular basis and need updated details from, I have collated an email sheet and have used the following code to produce the emails to each company, as I didn't want to fill out an additional column on...
Hello,
So, with help of kind people here I was able to make most of my project work, but have hit the hopefully last bump. Basically, I have a worksheet that based on condition decides whether the issue should go after Quality, Logistics or Finances, and then generates an email to be just sent...
Hi,
Currently I need to constantly search for references from Excel to my Outlook manually to check on their status, which is time consuming.
Is there a way for Excel to update (change cell colour) when I receive an email containing a corresponding reference? E.G. When I receive an email with...
Hi There ,
How to dynamically insert receiver name based on array that follow a criteria in the excel file.
For example , there are 3 different country US , JP and UK. The macro is able to create 3 different email draft and insert the table based on criteria of each country. It will create UK...
Hello, my first post.
I'm looking for a solution with my Excel VBA problem.
Hopefully someone is able to help.
I'm looking for a solution to send multiple emails with outlook to different mailadresses with different rows from my excel file.
Employee name
Email address
Info 1
Info 2
Info 3...
Below code works, except that instead of a Signature that I have designated as default in Outlook to be added to all my emails, this code picks another signature.
- How do I fix it for it to pick a Signature that I have designated as default in Outlook to be added to all my emails?
Playing...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.