outlook 2007

  1. P

    Read a Particular Column rows in a table data from Outlook Mail using VBA

    Hi, I've seen multiple fourms and found ways to copy the whole table or export the whole table. But my requirement is different. I have a mail like this: Start Date: July-07-2016 Timings between 2016-07-04T07:59:00.000-05:00 and 2016-07-05T07:59:00.000-05:00 Name Accept Approved John...
  2. D

    Optimize Excel Code to Automatically Delete an Outlook Appointment

    So I currently have code like this to delete an Outlook Appointment from Excel: Sub deleteAppointment(ByVal i As Integer, ByVal j As Integer, ByVal oldVal As Date) Dim objOutlook As Outlook.Application Dim objNamespace As Outlook.Namespace Dim objFolder As Outlook.MAPIFolder Dim subFolder As...
  3. C

    Excel to Outlook by VBA

    Hi, I want to create a macro that will send a particular range of data from a sheet (based on number of rows from another sheet) to outlook 2007 with signature. In the below codes, new mail has been generated with signature, but body of the mail is empty and its showing error in the line...
  4. F

    Excel Charts pasted into Outlook/Exchange Email

    I've written my VBA code similar to the post found here "http://www.mrexcel.com/forum/excel-questions/562877-paste-chart-into-email-body.html." However my issue is that when running the macro it's not giving me the latest chart on the active workbook. Any ideas?
  5. J

    Create Email from Excel

    I have an excel sheet which creates an email when clicked. Currently the body of the message only shows the row where the data is (the recipient will need to know the row to complete other tasks required) I would like to add more text to the body of the email as well as a hyperlink to the file...
  6. S

    Posting links / URLs to the favourites section of Outlook

    I need your help in creating a distributable add in which will help me post either one or many URL's (predefined by me) to outlooks favorites section. I.e. when I distribute this add in to the user and the user runs it, the url's should be posted to the favorites i.e. the user should be able to...
  7. E

    Change Word Macro to work in Outlook 2007

    For each reply in Outlook, I need to remove the text in the body of the message starting with the word "From" through the word "Support." I recorded the Macro in Word but I can't get it to work in Outlook. I also need to delete the information appearing between the two forward slashes that...
  8. R

    Code to load reference / Object library automatically for office 2007 & 2010 versions

    Hi, I'm working on an automation that will connect ms excel and outlook. I want a code to work on both office 2007 & 2010 versions. I'm getting a compile error "Can't find project or library" when i used a code taken from the below thread. VBA References I've given the code below which...
  9. W

    Cell Value in Email Body?

    Hello, I have this code but and I can't this out: it just keeps looping and doesn't stop... Its also not inserting the signature in each email... Can someone let me know what I am doing wrong please? Sub Notify() Dim name, email, evnt, status As Range Dim SigString As String Dim...
  10. K

    EXCEL VBA - Problem to search an email in Outlook folder

    Hi All, I have a code for EXCEL VBA that searches for email messages in certain folder of Outlook ( both 2007 version). However, the comparison starts from the lastest email in the folder and not from the first email. ( in Outlook, I prefer to keep the email messages sorted as Newest first and...
  11. D

    Create outlook email from excel email list with one criteria with subject matter and body of email

    Hi Everyone, I have emails in column C and the criteria in column D would be a "Yes". So I want to email everyone in column C when there's a Yes in column D in one big email. Also I'd like the subject to be in cell D1 and the body of the email in D2. Doable? Thanks, Michael
  12. R

    Importing Outlook Data into Excel

    I need to create an Excel workbook which imports in basic header information (Received, Parent, Importance, Unread, Received By, Sneder Name, Attachments and Subject) on all emails contained in 3 Public MS Outlook Folders plus any subfolders they have. Both Excel and Outlok are 2007. I have...
  13. L

    Excel 2007 - Create Outlook 2007 Appointment + Avoid double entry creation + Update

    Hi All, I'm new to this forum and to VBA. Still I have a rather tricky question to ask. I have an Excel 2007 work sheet with deadlines for action items. Formulas behind dates, each one of which is in a different column, ("launching date", "foreseen end date", "postponed date" and "closure...
  14. S

    VBA code to Open Outlook

    I have code that sends an email through VBA code in excel. I want to test to see if Outlook is open (not everone will be using this on their primary email box) and if not, to open then send the attachments. I have simpliefied the code below, would appreciate it if someone can give me the...
  15. N

    Outlook Macro Save Only PDF Attachments and mark Email as read

    Hi I’m new to VBA and I really have no idea what I’m doing so here I am looking for help from the pro’s I found this script online and though it would be useful, I made some changes to it however I’m having issues getting it to do exactly what I want. The below works to a point, it will...
  16. C

    Trigger Macro on Email Reciept

    All, Don't know if this is the best place to post this but i am looking for a way of opening a worksheet and then automatically running a macro when outlook receives a specific email. I need to run a set of reports but may not always be able to get to my PC so i would like to be able to send...
  17. R

    Copy a string of email addresses from Excel into Outlook TO: box

    The macro I'm using to copy a worksheet to the body of an Outlook email is working fine. Now I want to go to the worksheet ("volunteer list") and copy the email addresses in column D if the value of column A has an X in it then place that group of addresses in the TO: box of Outlook. Could you...
  18. T

    VBA in Outlook Help

    I have some VBA written in an Excel Workbook that controls some functionality inside of Outlook (ie writes messages). What I need to do is create a macro entirely in Outlook that will turn a message into a calendar appointment. The calendar appointment will always be for 9:30am, BUT the date of...
  19. L

    Creating Outlook Calendar Events From Excel

    Hello, I'm trying to integrate a timeline in Excel to create Outlook appts and need some assistance in the VB programming since I'm not very familiar. The macro now looks like this: Sub OutlookSetAppt() Dim olApp As Outlook.Application Dim olApt As AppointmentItem Dim blnCreated...
  20. A

    Send outlook emails with message in cells to individual emails associated with them

    Hi everyone, Basically I have a data sheet with a list individuals in one column and individual messages in the next and their associated email addresses in another. I have an excel VBA code which sends the whole worksheet as an email attachment to a specific address. Is there a way to modify...

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