olapp

Hi Excel gurus, I have put a code together (see below - working code with no copyright, fell free to use it) that analyzes an action plan (excel file with columns for actions, date and time of begin and ending of an action etc.) and creates outlook appointments based on the information on the...

Hi all, I've found some VBA code that I've catered to my own "Schedule Uploader" using the inputs in the table below to create meeting invites to Microsoft Outlook calendars. My one problem is that the required attendees are not getting the meeting emailed to them, and thus it is not showing up...

Hello, I have a code that pulls Conversation ID from Outlook. This would represent an email that I sent through a VBA macro. I'd like to find a way to see if any of these emails have been responded to. I have two thoughts on how this might be completed but no concept of how to complete either...

Here is my code to create outlook calendar reminders: Option Explicit Public Sub CreateOutlookAppointments() Sheets("Sheet1").Visible = True Application.ScreenUpdating = False Sheets("Sheet1").Select On Error GoTo Err_Execute Dim olApp As Outlook.Application Dim olAppt As...

Hi Guys and Gals, I have a file with some VBA that work brilliantly for me. However, I need to move the location of it, currently sitting on the desktop, b ut when I move it, I get an error in the VBA. Sub PDFTOEMAIL() Dim olApp As Object Sheet1.Unprotect Password:="" Path =...

Hi experts, Below is a macro that pulls attachments from an outlook folder and places them into a folder on my desktop. I am now trying to add to or create an additional macro to copy the contents of each file (mostly PDFs) and paste the contents into excel to extract PO numbers. I would then...

Hi, I have an excel template that sends emails. When I wrote the code it was working fine. Then it seemed to freeze outlook at some point after which excel crashed. On reopening, the code gives me said runtime error at the ".Send" part of the code below : Sub SendRunRequest() Dim Msg As...

Hi everyone... I need help with the code that I am using. It works great on adding reminders to outlook based on a excel sheet. however when i use diferent versions of excel 2010 or 2013 or 2016 it gives the error because of the references. Can anyone help me convert the code I am using...

Ok guys, I'm reaching again... I have a spreadsheet that I need to initiate an outlook calendar event/ reminder for 25 days after the date entered. Through much research and trial & error, I have a VBA code written that almost does what I need. I just need some assistance in tweaking it a bit...

Dear All, I have a short and simple macro that replies to a specific email found in my Outlook sent folder based on the subject. But the issue is that this code opens all mails with that subject. But I would need only the latest reply email to be remained opened (with the entire mail chin). Is...

Hi all, Need some help on a piece of code to export only the visible rows in a worksheet. I have a worksheet with a list of work items/processes. These are all hidden. After clicking on a button a userform appears where processes can be selected. After submitting the userform all the rows...

Hi guys, I have this code that automatically sends emails from my excel model on outlook. Can anyone suggest a straightforward (or otherwise) tweak that will enable it to send attachments?? Code: Sub SendRunRequest() Dim Msg As String Dim olApp As Object Dim olEmail As Object Dim...

Hi, I can't work out what the error is on this vba code. It keeps getting to .SaveAs but getting a Run-time error '287'. Does anyone have any idea? Function MailClient() Const Key As String = "HKEY_LOCAL_MACHINE\SOFTWARE\Clients\Mail\" Dim ws As Object On Error Resume Next Set...

Hello All, I want to send the entry from a userform to an email box. I have everything set up correctly. But the code is only sending the "entries" and not the labels, etc. See below:[ CODE]Dim olapp As Outlook.Application Set olapp = CreateObject("outlook.application") Dim olmail As...

Hi, I have VBA code that sends emails on outlook that works fine. However, the sent emails do not contain my logo and signature as set up in out look (even though composing & sending manually on outlook automatically compose and send on logo/signature-ready templates). Can someone suggest what...