recipient

  1. G

    VBA to open selected calendar item and add recipient

    Hello, I am looking for some Code to put in Outlook so that I am able to select a few calendar items (or all) and add a new recipient (Which is a room). I think I then need to send the calendar invite on but only to new recipients (the new room). No historic instances need to be changed. The...
  2. G

    VBA to open selected calendar item and add recipient

    Hello, I am looking for some Code to put in Outlook so that I am able to select a few calendar items (or all) and add a new recipient (Which is a room). I think I then need to send the calendar invite on but only to new recipients (the new room). No historic instances need to be changed. The...
  3. S

    Being notified when a file is changed / updated.

    What VBA would be needed to insert into a macro to notify an email recipient that a file has been modified?
  4. A

    Find header based on cell value

    Hello, I have a dataset where I want to locate the person with a value in a particular row. The table below is on range A1:E5 <tbody> Boyle Hayle Coyle Neli Coile -175 0 178 139 -142 -175 0 178 139 -142 -175 0 178 139 -142 -175 0 178 139 -142 </tbody> I want to search for the...
  5. A

    Outlook 2007 - Automated Response email

    Hello, I would like to know how to develop an automated email response based on user response. This is what I would like to develop: Using Outlook 2007 a template is created with a mail list group and two buttons that allow the recipient to either Approve or Deny the specific event. Once the...
  6. C

    Macro to automatically mail merger and print - Code Needed

    Hello, I have a word doc that I have set up as a mail merge from my excel file. I would like to be able to select a cell (a single recipient) in excel and have a user click a button ("Print") and have the paperwork print out for the single recipient that is selected. Is there a way to do this...
  7. B

    Multiple Email body to same recipient

    Hi, I wrote a VBA Code to send a mail to the recipient based on a criterion. My next step is a bit complex and I am not sure how to proceed. Problem: I have a criterion, passing which, a mail will be sent to a recipient. But there shall be several instances where the criterion is TRUE and...
  8. J

    Send Email to Recipient Command

    I love the "send email to recipient" command and it works great for a tool I have in place to share updated negotiated prices. As I need more people to be able to use the tool, I have to consider their "limitations." Is there a code someone can provide me that allows me to create a button on...
  9. T

    Macro Help

    I have written a macro that filters an excel sheet and emails the results to an email recipient - it uses "Send sheet" rather then send as an attachment. The problem I'm having is that when the email recipient replies to me, the sheet appears unfiltered and is causing confusion (I am sending...
  10. A

    Email using VBA but changing a few words in Body depending on Recipient

    Hello, I need to send out a standardized email, but I need to change a few fields within the body of the email to reflect names specific to the recipient. It's pretty simple, but I can't find anything specific to this case. Example: Hello _______, Here are your login credentials: Username...
  11. H

    Signature Line Help

    I set up a VBA to automatically email a sheet of a document to a recipient and a separate VBA to send the sheet back to me. I can’t get the Microsoft Offics signature line in excel to go with the sheet when the VBA is used. And once the signature is signed by the recipient, the 2nd VBA quits...
  12. S

    Command Button -

    I'm using a command button to automatically email a document. I have the recipient (srecipient), subject line (subject) and the body (sbody) text setup - I want to add additional recipient as a "CC". Any help on this would be appreciated.
  13. S

    Mail every worksheet using A1 as address

    Hello I am using code from the below link to send multiple sheets to email addresses in cell a1. http://www.rondebruin.nl/win/s1/outlook/amail5.htm I have hit a snag though. My sheets are made up of filtered pivots and I don’t want the recipient to be able to take the filter off. Could the...
  14. F

    Help Conditional Formula

    I need the recipient cell to equal the value posted to cell I165 only if cell E10 on the worksheet titled "Candidate Selection" equals "C" ... otherwise the recipient cell is to remain blank
  15. F

    How to extract partial string onto another cell if conditions are met?

    Hi :) I was wondering if someone could help me with a formula I am having a hard time coming up with: I have an excel sheet with various recipient addresses. The recipient name column, say column A, will look something similar to "Ship to business #1584" or "Ship to business #1224" or "Jane...
  16. E

    Emailing Range as a pdf attachment

    Good evening everyone, I wonder if there are some VBA people that like a challenge! I am trying to find a way to copy a range, save it as a .pdf, open outlook, send email to recipient and message, copy ranged contents place onto another sheet as a list (ie next row down from previous entries)...
  17. F

    Need for a Conditional Statement

    Need a conditional formula to address the following issue: If cell E10 on a worksheet identified as “Candidate Selection” = “C” and cell G6 on that same worksheet is not blank, post the value “Y” to the recipient cell….if these conditions are not met, the recipient cell is to remain blank...
  18. F

    Conditional Formula Request

    I would greatly appreciate help with formulas to address the following two conditions: 1). The recipient cell is to equal the value posted to cell F82if cell F83 = “CRITICAL” and cell M83 = “X” …..if these conditions are not metthe recipient cell is to remain blank. 2). Therecipient cell is to...
  19. D

    Email from Excel running through list

    Hi Is it possible to create a macro to email from Excel which runs through a vertical list in excel and sends the email (and attachment) to each recipient one at a time....there is a list of 250 people so I need to send the same file to 250 recipients without each recipient seeing the other...
  20. F

    Conditional Formula

    I want the recipient cell (I6) to equal the following statement: "Cable Median Barrier Repair" if the value posted to cell E10 on a worksheet identified as CANDIDATE SELECTION is "C". If however, the value posted to cell E10 is "R", then the recipient cell (I6) is to reflect the following...

Some videos you may like

This Week's Hot Topics

Top