outlook 2010

  1. M

    VBA Email placed below auto signature

    Every week, I send out several emails with updated reports and hyperlinks. To save time, I created a macro to write and send these emails for me. The generated email is exactly what I want when I display the message. However, I noticed that after the email is sent, my automatic signature appears...
  2. D

    Outlook to Excel VBA

    Hi, I've had some code running in outlook for about 6 months at least now and been working fine however since about a month ago it stopped working and i cannot figure out the reason why... It keeps telling me that the file doesn't exist..., i've changed application visible to true and i can...
  3. R

    GetObject not getting Outlook.Application

    I have a stock function I use to test to see if Outlook is running before I attempt to draft an email. I've never had problems with it before, but today I ran the program and it doesn't acknowledge that Outlook is running. If I close/reopen the file, it seems to work and if I step through, it'll...
  4. M

    Outlook VBA to auto-save attachments

    Hi All, Some help please. I'm trying to write vba code that runs on new emails that are already in a shared mail box or arrive at that same shared mailbox. The emails will have a specific subject such as "Output for PS2 model" in the subject line with a crucial difference being that part of...
  5. T

    Use excel to copy word file to outlook as body of email

    I am trying to createa macro in excel which will send an email to a large number of people bycopying the contents of a word file as the body of the email. The list of emailaddresses is listed in column A of sheet1. I modified the code below from a post I found earlier. My problem istwofold...
  6. T

    Use excel to copy word file to outlook as body of email

    I am trying to createa macro in excel which will send an email to a large number of people bycopying the contents of a word file as the body of the email. The list of emailaddresses is listed in column A of sheet1. I modified the code below from a post I found earlier. My problem istwofold...
  7. B

    Creating a new "All Day Event" In Outlook Using Excel 2010

    Hi Guys, I hope you are all well. I was just wondering if anyone knows how to use VBA/Excel to Create a new all day event In A Specific Calendar in outlook. The name of the calendar would be "UK Customer Services Calendar" and The Date Range would be Defined in Cells A1 And A2. Any Help Or...
  8. N

    VBA / Outlook

    Dear Community, I need help with the following and would really appreciate any and all of your help. Currently I have 2 rules set up in my outlook inbox where whenever I send and email it 1)Automatically CC's me and 2) flags this email. Meaning that when I send an email it appears in my...
  9. D

    Macro for auto sending a work book a week before a date in range

    Hi I am in need of some expertise i'm trying to create a Macro that will be activated by the window scheduler, What i am after is a macro that a week before a date is reached it sends an email in Outlook to one fixed recipient with the workbook attached the dates sit in column F and there are...
  10. B

    Open Save As dialog box in existing VBA Sub

    Hi there, Below is the macro that I am using to export tasks from Outlook into Excel which I put together using various bits found while googling (See Macro 1). I am trying to merge Macro 1 & Macro 2, so that the user may use the "Save As" dialogue box to save the output file instead of having...
  11. samibo

    Shared Mailbox User Guide

    Hello Friday afternoon here and I've just made the fatal error of opening an email that contains work! :eeek: Generic Shared Mailboxes - Outlook I've got to come up with a set of rules/suggestions to put forward at our team meeting next week. Our team has expanded and there could now be up to...
  12. DPChristman

    Odd Question - Excel and Outloook

    I am trying to take a list of dates (specifically birthdays, anniversaries, etc.), and import them into my Outlook Calendar. I have seen a couple of articles and YouTube videos on this, but I can't get it to work. Using 2010 on both. Does anyone have a sure fire way to do this?
  13. V

    Need a VBA to send the PDF copy from Folder through Outlook

    Hi All, I need help with VBA code to send the PDF copies from the folder through outlook using the Excel Distribution list that when I run, would look for the path, grab the file that starts with the client name/Invoice number in Col A, and attach to the email, along with a predefined...
  14. W

    VBA Code for multiple emails using Outlook

    Hi, First posting on this forum so please be patient with me lol. I will include as much info as possible. My aim is to create an excel spreadsheet that holds numerous (2,500 approx) email addresses in column A of a worksheet called "Email Addresses" in a Workbook called "Distribution.xls" I...
  15. B

    Copy a Table from outlook msg body to Excel on receiving mail

    Hi, I want to copy a table from an email in outlook to excel automatically whenever I get a mail with subject "Tasks - <currentdate-month>" using VBA/macros I get at least 10 mails each day throughout the month with the same subject. The email body contains a table in the following table format...
  16. chris-in-cal

    Outlook "Tasks" quick tables - check boxes

    Hello, [(Executive Summary) I create a 2x2 table in MS Word. Column 2 is check boxes. I protect the MS Word doc to use the check boxes. But while protected I can not copy and paste it into a Task...where I would save it as a quick table] Where can I look to find some answers for a puzzle I'm...
  17. A

    Sending Email through outlook with saving Excel file

    Hi everyone, I am trying to send email to responsible person in Excel file by creating new workbook with some details and sending to responsible prerson but my code is not saving file and poping up window for email. Please tell what is the error in file and how i can optiomise it Sub...
  18. A

    Convert text to image, copy it and paste it in Outlook

    Hello all, I really hope I can explain myself here: I have this file that I'm working on and need to add a feature in which it takes a fixed cell range, copies it and pastes it in a new outlook email message window. However, I need it to paste the date as an image. I also will need that it...
  19. A

    Emailing each of 500 workbooks to a different email address located inside each one

    Excel friends, I have 500 Excel workbooks that I need to email to an email address located inside each workbook, first sheet, cell C2. I need to write the same subject, and body text in each email. I use Outlook, and Excel 2010, and all the Excel workbooks are located in the same folder. How...
  20. S

    Macro to loop through all rows of data

    Good Morning, I have created the following macro which is supposed to loop through all the data points and create Outlook calendar entries for each line of data in my Spreadsheet. At the moment it looks like it only enters the first line as an entry to Outlook before stopping. What do I need...

Watch MrExcel Video

This Week's Hot Topics

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
Top