Tagged Questions
0
votes
0answers
25 views
VBA Code - Extract email addresses Outlook
I got a code VBA code for extracting email addresses from PST files.
It is very useful as I can choose the folder to have the addresses extracted.
The code is extracting from the "To" field.
I need ...
1
vote
1answer
32 views
How to call a Microsoft office outlook Macro from C#
I have a Macro which fetches some data into the excel file from the Microsoft office outlook (inbox or any other folder). To get the excel file I have to manually run the Macro in the outlook. Is ...
0
votes
1answer
20 views
Outlook VBA AppointmentItem.Move creating a copy
When using the Move method on an AppointmentItem in an Outlook macro, I lose the ability to receive updates because it is creating a copy of the item instead of truly moving it. This behavior causes ...
0
votes
0answers
32 views
Outlook 2010 macro to run rules
I got the below code from the web to run outlook 2010 rules. I'm just trying to run only one rule at a time by selecting it from the combobox but I couldn't figure it out since it runs all rules as ...
0
votes
1answer
31 views
Add automatically CC In the new message in outlook using VBA doen't appear?
when i click new email outlook the automatically cc email doesn't appears form VBA code in cc text area please help me in doing this i already add the CC using VBA in Application_ItemSend event but it ...
0
votes
0answers
36 views
Invalid Qualifier for String.Add in Outlook VBA
You all have been so helpful, and I was wondering whether I might trouble you a bit more. I have nearly completed my conversion from VB.net to VBA for Outlook, and in order to complete that, I need ...
0
votes
0answers
19 views
Type mismatch line n° 1 accessing outlook task userproperties
Trying to loop through userproperties of outlook 2010 tasks, but I get some kind if script error message or warning saying:
Type mismatch "opensms'
Line n°: 1
The reference 'opensms' seems ...
0
votes
1answer
67 views
VBA - Outlook 2010 - Using ReceivedTime of email in calculation constrained by work week and office hours
I'm trying to develop a module in Outlook that can use the ReceivedTime of an email and then add x hours to it to give a 'response time'. The hours added though have to be within the working week ...
0
votes
0answers
43 views
Outlook Appointment - ItemChange and ItemRemove Event
I would like to sync appointment items from one Calendar to another. I implemented a ItemChange Handler which updates the Appointments based on a specific UserProperty. Now I thought when I delete an ...
0
votes
1answer
77 views
Visual Basic Compile Error - Invalid Character
I got a VB SCRIPT off the internet to create new mail alerts for secondary email accounts in Outlook(2010).
Now this is the first part of the code, and when running Outlook, it gives me the ...
0
votes
0answers
37 views
Outlook.Application on Access Database
I am trying to run this code but the system does not respond to any of the inputs. Could you please help me with this:
Private Sub SendMail_Click()
On Error GoTo Err_SendMail_Click
If Me.Dirty Then
...
0
votes
0answers
67 views
VBA Automatically Saving incoming emails from outlook
I am trying to write a small macro program for outlook.
The Program Should automatically save the text of incoming emails as a text file.
I found large pieces of code and tried to make this work but ...
-2
votes
1answer
95 views
I'm trying to bypass outlook alert using sendkeys, is this code correct? [closed]
Sub Mail_Workbook()
Dim wb As Workbook
Set wb = ActiveWorkbook
Application.Wait (Now + TimeValue("0:00:06"))
Application.SendKeys "{TAB}", "false"
Application.SendKeys "{TAB}", "false"
...
1
vote
1answer
116 views
Outlook VBA to create new draft email for each Contact Group in contact list
Is there a VBA script that will
Create a draft email for each Contact Group
With the Contact Group's contacts in the "TO" field
With a uniform Subject
With a uniform Body
...and bonus if the body ...
0
votes
1answer
76 views
Outlook Forms: Importing / VLOOKUP Data from Excel?
I am a bit new to Outlook forms, but not to VBA overall - nor HTML/Web design of forms. However, my problem is finding a way to combine the two.
I am trying to design a form for users to fill out, ...
1
vote
1answer
76 views
Control already created Outlook message from excel VBA
longtime reader, first time messenger (not my first time making a bad joke though),
I would like to know if it is possible to gain control of an Outlook email message that has already been created. ...
0
votes
1answer
81 views
No existing macros availble when Excel is opened from Outlook macro
I have a macro in Outlook, and I have it opening an Excel file that is saved on my desktop. Once the file is open, I would like to run a macro that I have written in excel, but none of my excel ...
1
vote
0answers
67 views
Macro to send two different mail when a cell reaches two different values (right)
Excuse me for my English.
I offer to you my best compliments for this very useful and well done website.
Now I'm developing a program very complex Excel in which I predicted the attached Code Macro, ...
0
votes
0answers
18 views
ActivePersonRecipient.Resolve returning FALSE even though the alias is present in outlook
i am trying to extract outlook names corresponding to aliases. however for two aliases ActivePersonRecipient.Resolve returns false even though the recipient is present in outlook
1
vote
1answer
61 views
Object Required VBA Outlook
I'm not sure what it doesn't like about my code here, I'm experienced in .NET, but VBA is new to me. I know when called functions not to do myFunction('args') and do myFunction args instead, but I ...
0
votes
1answer
70 views
Add Recurrence event on outlook 2010 from Excel
I have my friends date of birth in excel with name and dob column. I have to import the birthday events in my outlook calender with reminder of every year.
I tried with birth date as start date and ...
0
votes
0answers
53 views
VBA Outlook 2010 SharePoint 2010 GetUserLoginFromEmail
Given an email, I would like to get the SharePoint ID (in List > User > ID; Person or Group)
Public Function GetUserFromEmail(ByVal Email As String) As String
Dim EmailXML As String
...
1
vote
0answers
63 views
VBA to forward an email
I have designed a macro to forward an email. The below code drafts a forward email, adds some information in the body, retains the original content at the bottom of the email. But the only problem is, ...
0
votes
1answer
67 views
outlook shared calendar recurring item between the date specified range
Following is my code where i can print the number of recurring items in the shared calendar folder. Now i want to take the date range from the user say SDate and EDate and want to check for the ...
-1
votes
1answer
53 views
Filter on Appointment,Meeting and Online Meeting items in OutLook-2010
I want to write a macro in VBA that will give me all the items from the above mentioned category.
I can be able to find all the AppointItems. How can i find the others?
Any Idea?
Set ...
0
votes
0answers
36 views
Outlook vbscript event management
I don't fully seem to understand Outlook vbscript events.
I've added this method.
Sub Item_CustomPropertyChange(ByVal Tier)
...
End Sub
That listen to all custom property changes. The problem ...
0
votes
2answers
73 views
adding multiple messgeboxes values to single messagebox in vba
I have this code with me where i can display the message when every outer loop ends. I want to catch all these messages in suppose array or soome list like structure and then at the end want to ...
1
vote
1answer
155 views
Using the .Restrict method in Outlook VBA to filter on single recipient email address
I've been coding in VBA for Access and Excel now for several years, but am making first forays into Outlook, and am struggling to find an answer to this.
Essentially I have code in Access that gets ...
0
votes
0answers
63 views
Outlook VBA Exchange User Get “Last Active” Time
I am using VBA fairly intensively to utilize the Global Address List (GAL) within Outlook and retrieve a large variety of information.
I cannot figure out how to retrieve the "last active" ...
0
votes
2answers
600 views
Extract outlook message body text with VBA from Excel
I have a huge number of Outlook .msg and Outlook .eml files saved to a shared network folder (ie outside of Outlook). I am trying to write some VBA in Excel that extracts the Subjects，Sender, CC, ...
