outlook

  1. D

    Formula in Excel to display email message with CC & email receiver

    Hello everybody, I am currently following this youtube video: (specifically look at around 07:30-08:30) in order to create an email link in my excel file that people can click on, have a pre-determined email message written and then fill out the blanks and send it out. However, while I tried...
  2. D

    Send/display email through Excel in Outlook

    Hello everybody, I am currently trying to create a macro in Excel that, once you click on it, displays a pre-written message (by me) and then allows the user to send off the email from their own account. Is this possible? Furthermore, I know that you can do something like: Set.subject /...
  3. R

    Command button to send/display email to corresponding email address if condition is met

    Hello VBA experts, I have a spreadsheet that I would like to add a command button to that would populate an email to the corresponding email address, but only if a condition is met (an upcoming due date). I have tried several versions of code, but none have worked so far and I'm also a beginner...
  4. H

    VBA Sending Email from Excel - Make specific text of email body BOLD

    Hi, this is actually my first time posting on this site I am using the vba code below to send out email reminder via outlook. However, I am wondering how to make specific text which is fixed in the code to be bold, as listed : Event/Activity ; Department ; Date of Event ; Description Can...
  5. randaubienghoc

    Send bulk email from Excel issues: 1-Attach multiple files with file paths, 2-Copy visible ranges and 3-Add default email signature keeping formats

    Hi everyone, As a new VBA learner, I am seeking for your help to solve these three problems when automatically send Outlook email from Excel. The code is now lacking these improvements. Your support would be highly appreciated. 1. Attach multiple files with file paths by criteria (For same...
  6. D

    (Fast read!) Send out email automatically with attachment through command button

    Hello everybody, Goal: I am currently trying to create a command button in Excel that, when one clicks on it, sends out an email to me with an order that one has entered into Excel. The following link here: Using Excel VBA to Send Emails with Attachments - wellsr.com has a nice VBA code that...
  7. J

    The attempted operation failed. An object could not be found. Excel and Outlook VBA

    Hello Everyone, I have created a macro that gathers all the timings from a specific subfolder on a specific date from a shared mailbox and personal sent folder. When checking the timings from the personal sent folder there is no issues, but when checking from the subfolders from the shared...
  8. O

    VBA to paste from Clip Board onto an Outlook email.

    Hi Guys I need help with the VBA. Here is what I have so far. THe first few lines copys some rows in excel (some rows are hidden, filtered out in a filtered cells by the way) I don't know how do I paste this into the body of the email?? I tried searching online but it came back with really...
  9. J

    Add a link in the body of an Outlook task created from Excel VBA

    I currently have a worksheet that creates Outlook tasks based on line data from a table. Works like a charm however i need to create a link in the body of the task. I can get the file extension in the body but i would like to hyperlink it. I have done some research but have become confused...
  10. D

    Table to Outlook mail message missing frame

    Hi! I'm running the popular Excel-to-Outlook VBA code by Ron de Bruin. Granted, this seems like a miniature issue (and it is), but it still drives me crazy. As the code stands, I'm missing the bottom end of the table frame in Outlook (screenshots from Excel table + 2 below from Outlook...
  11. C

    VBA Outlook place cursor after specific word in email body

    Hello, I need a code VBA Outlook to place a cursor in email body after a specific word Thanks
  12. J

    VBA with olMail Body Formatting

    Thanks in advance for any help. I'm trying to create an email from an excel file. Currently works fine, however I'm looking to BOLD certain parts of the .Body string. It was suggested that I use .HTMLBody for some quicker easy coding, but I'm not that HTML savy and haven't been able to simply...
  13. T

    Large Excel list of various email addresses that need to be deleted from Outlook

    Hi All, I have a large list of email addresses in Excel, I need to delete (ideally to the Delete folder) or remove the emails present in the list from my Outlook Inbox. I've searched the web to see if I can find a vba routine but have been unsuccessful. I'd appreciate any assistance. Many...
  14. P

    Outlook Subfolder Expansion

    Hello, I've got some code that is supposed to expand some folders in Outlook. It works fine for the first level folders, but won't expand the subfolders (in this case the xx Progressions folder). The code doesn't bug out: the subfolder simply does not expand. Could anybody tell me what I've...
  15. X

    Move outlook contacts to folder

    Hi all, I have my icloud account linked to my outlook, and all contacts are added to a folder called "contacts" I can then manually add folders to sort contactitems. However, when you "move" a contact from the main group to a different folder, it also stays in the main group. Therefor the main...
  16. P

    Want to send a range in a sheet with Outlook. But I want to give the user an option for attachment or copy

    Hi I have a tool in which the user clicks a macro button and it send out the range of the sheet in the body of an email in Outlook. We are having an issue that sometimes the range can be over 1000 rows long. The receiver will have to copy paste it in a workbook anyways, so I wanted to give...
  17. M

    VBA from MS Outlook to copy data from excel file and past it to email body

    Hi! I have excel file which is saved locally in OneDrive folder but is shared within office 365 so can't use VBA. So I need to run a macro from MS Outlook to copy data from the excel file and past it in the new email's body. Here is the whole routine I want to automate: 1) Open the excel file...
  18. P

    Excel VBA to Outlook Select Range lastRow

    Hey guys, I need for the code to stop copying at the lat line with data, but cant figure out how to code it. Pretty sure i need to use lastRow, but Im not sure how to replace the range. Sub Main() 'For Tips see: http://www.rondebruin.nl/win/winmail/Outlook/tips.htm 'Don't forget to copy the...
  19. Y

    VBA / Macro: Book Excel dates to Outlook Appointment.

    Hi Everyone, I'm in the final stages of getting this vb code finished to book appointments to my default outlook calendar in outlook 365 (desktop version). There are two calendar appointment types: - Type 1. Personal Appointments, "CreateOutlookAppointments()" - Type 2. Shared appointments...
  20. J

    Save Emails from Excel

    Hi There, I have a new specific problem with interacting with outlook. I have a sheet where I need to save approval for things that came via email. I will be using a userform to allow my users to select which row the approval should go in. I need the macro to look at the user's inbox (there...

Some videos you may like

This Week's Hot Topics

  • Timer in VBA - Stop, Start, Pause and Reset
    [CODE=vba][/CODE] Option Explicit Dim CmdStop As Boolean Dim Paused As Boolean Dim Start Dim TimerValue As Date Dim pausedTime As Date Sub...
  • how to updates multiple rows in muliselect listbox
    Hello everyone. I need help with below code. code is only chaning 1st row in mulitiselect list box. i know issue with code...
  • Delete Row from Table
    I am trying to delete a row from a table using VBA using a named range to find what I need to delete. My Range is finding the right cell. In the...
  • Assigning to a variable
    I have a for each block where I want to assign the value in column 5 of the found row to the variable Serv. [CODE=vba] For Each ws In...
  • Way to verify information
    Hi All, I don't know what to call this formula, and therefore can't search. I have a spreadsheet with information I want to reference...
  • Active Cell Address – Inactive Sheet
    How to use VBA to get the cell address of the active cell in an inactive worksheet and then place that cell address in a location on the current...
Top