outlook

  1. R

    Mail merge to insert the picture in the mail body and schedule the email

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

    Getting pop up in outlook with vba/excel integration

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

    VBA: create separate emails for each unique address in selection

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

    Unsure why this automatic Calendar reminder is not working.

    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 =...
  5. S

    Export Attachment from outlook to excel cells

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

    Loop in macro calculating twice instead of once.

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

    Query in excel to Outlook mail take rows with name until next name

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

    Problem with Application.FileDialog(msoFileDialogFolderPicker) in Outlook

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

    Send email from excel

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

    Task Scheduler fail to open excel and run macros

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

    Create mails with table - standard header specific row

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

    VBA Outlook export calendar items - Code 13 type mismatch error

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

    VBA Code for Outlook E-Mail Due Date Reminder Based on 2 Cells

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

    Creating Call To Action Button Inside Outlook Email That Creates Template For Recipient To Complete

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

    Email list on Excell with template but missing Signature

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

    Calling new Subs

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

    Excel to update based on Outlook email

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

    How to Insert another loop for inputting multiple receiver name in an Email based on criteria

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

    vba, Email multiple addresses with multiple rows

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

    Default Signature at end of Excel generated email

    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've detected that you are using an adblocker.

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.
Go back
Back
Top