outlook

  1. 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...
  2. M

    Runtime error 1004 with "ActiveWorkbook.EnvelopeVisible = True"

    Hi all, I am trying to create a macro to send an email via outlook. The code works on my computer but it does not seem to work on another computer, where a Runtime error 1004 is returned. "ActiveWorkbook.EnvelopeVisible = True" being highlighted when I try to debug. Please see my code below...
  3. K

    Sending an automatic email when the due date is approaching

    Hello experts, I am quite new to VBA. Currently, I am working on a project where I want to send an automatic email seven days before the due date notifying that the due date is approaching. I want to get the date and the respective email address from two different sheets. I searched for other...
  4. C

    Email Hyperlink

    Hello: When I click an email hyperlink, it currently opens to the Mail app. Is there any way to have this switched to Outlook? Thanks OJ
  5. Y

    VBA Check existing Calendar appointments when importing from excel.

    Hey guys, I've already posted something similar but i replied to my own post and im concerned no one will see it, so here is the problem: I'm stuck trying to prevent duplicate appointments being created when i run the following code to import excel dates to outlook. I need the code to ignore...
  6. Y

    Check for existng appointments in calendar to prevent duplicate entries when importing from excel

    Hey Guys, I'm stuck trying to prevent duplicate appointments being created when i run the following code to import excel dates to outlook. Public Sub CreateOutlookMeetings() Sheets("sheet1").Select On Error GoTo Err_Execute Dim olApp As Outlook.Application Dim olAppt As...
  7. M

    Make a word document from range of cell and send as attachment from outlook

    I have this code to send PDF files but now I need to send word document instead of PDF, could someone help to adjust the code: Sub PDFXX() Dim SaveAsStr As String 'SaveAsStr = ActiveWorkbook.Path & "\" & ActiveSheet.Range("J1").Value SaveAsStr = ActiveSheet.Range("J1").Value...
  8. R

    Creating a single email from list

    Hey y’all, I am having issues finding a VBA that can create an email in outlook from a list of email addresses. The email addresses change fairly constantly and will sometimes have blank cells in between them. I would like it to create a single email but can only find VBAs that create...
  9. B

    use excel/outlook VBA open PDF file(password protected but have password to open it) and then click the link(on pdf file ) to open the file

    Hi All I need your Excel Excel/Outlook VBA expert to help. I knew how to build up outlook VBA to detect new email with attached file (i.e. PDF file) coming in the specific folder but have the following problem : The email has attached file that is PDF file with password...
  10. A

    Referring to files in same folder as workbook in VBA

    Hi, I'm trying to put piece of VBA code together to attach some PDF files in outlook and send out. However, I sometimes work from my personal laptop and my business laptop. How can I code something like this .Attachments.Add "C:\Users\arazaq\Documents\Black\PDF Reports\Demo PDF\UK FTSE 100...
  11. M

    Finding the end of the body of an Outlook Email

    I want to paste two ranges into an Outlook email. I can create the email, filter for the range, copy and paste the range. The problem is with where the second range pastes. In the first three emails, everything works correctly. Then, the code does not correctly find the end of the message to...
  12. U

    VBA hyperlinks in Excel

    Currently in the middle of an assignment where you have send an excel file as a hyperlink rather than an attachment using VBA, Is there any possible way to do this as at the current moment I am only able to send the location of a link as regular text rather than a hyperlink. Any help would be...
  13. P

    OUTLOOK VBA to download attachment/s to LOCAL ZIP folder

    Hi All, Hoping someone can help me out? I'm trying to download all attachments from an open Outlook email to a zip file, name of my choice, to a local folder. There's no record function on outlook and i cant compile from scratch. I can only find stuff about downloading all attachments in an...
  14. L

    Error accessing 2 shared outlook mailboxes at the same time

    I have 2 shared mailboxes where I retrieve the count of the mails. These 2 shared mailboxes have 2 different mailaddresses. When I combine these 2 codes, it gives the following error: <code style="margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight...
  15. L

    Temp File Folder in MAC vs Windows

    Hi Experts! I have a line item in my vba that saves an excel file in a temporary folder and then attach in an outlook email. It perfectly works on a normal laptop but when my co-worker tried it in his mac, the vba is debugging showing a run time error '1004': Microsoft Excel cannot access the...
  16. L

    Accessing a shared inbox from outlook to VBA

    Hello, I have written some code that retrieves the number of mails from two inboxes. I've tested it locally however when I am trying to connect to a Shared Inbox, it returns a 0. I am very confused and I am wondering if someone can help me. The names of the two shared inboxes are 1) FolderA and...
  17. S

    Populate Outlook Userform Listbox From Excel Data Table

    Hi Guys, I know how to populate a Userform Listbox from within excel, but I want to create a listbox in Outlook to be populated from data in the first column of an Excel table. At the moment I have this from within Excel: Me.ListBox1.List =...
  18. U

    Excel VBA code to extract all outlook global address emails and UserID

    Hi All, Im trying to get outlook global email address and userId in to my workbook What is the best way to achieve this Please can you help me Many many many thanks
  19. FuNeS13

    Run-time Error 2147418113 (80000ffff) Automation Error Catastrophic failure

    Hi all, for some reason, when I run a macro that send an email via outlook I get this error on the "CreateObject("Outlook.Application") part... I've tried several different possible solutions but none have worked... I've try multiple stuff on outlook as well and still no luck... Plot twist...
  20. J

    Auto Creation of Folders in .pst File

    Hello All, So I feel like this should be relatively, easy but really have been struggling on the syntax. I currently have a functioning Excel macro to create a folder in my Outlook Inbox, but what I really need to do is create it in my .pst file folder structure since our Outlook storage is...

Some videos you may like

This Week's Hot Topics

  • VBA (Userform)
    Hi All, I just would like to know why my code isn't working. Here is my VBA code: [CODE=vba]Private Sub OKButton_Click() Dim i As Integer...
  • List box that changes fill color
    Hello, I have gone through so many pages trying to figure this out. I have a 2020 calendar that depending on the day needs to have a certain...
  • Remove duplicates and retain one. Cross-linked cases
    Hi all I ran out of google keywords to use and still couldn't find a reference how to achieve the results of a single count. It would be great if...
  • VBA Copy and Paste With Duplicates
    Hello All, I'm in need of some input. My VBA skills are sub-par at best. I've assembled this code from basic research and it works but is...
  • Macro
    is it possible for a macro to run if the active cell value is different to the value above it
  • IF DATE and TIME
    I currently use this to check if date has passed but i also need to set a time on it too. Is it possible? [CODE=vba]=IF(B:B>TODAY(),"Not...
Top