Tagged Questions
1
vote
0answers
22 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, ...
1
vote
0answers
41 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, ...
1
vote
0answers
51 views
send a votingresponse to outlook
i'm trying to run a script that will automatically vote for me.
this is what i have so far:
Sub vote(newMsg As MailItem)
newMsg.VotingResponse = "YES"
newMsg.Reply
End Sub
its not ...
1
vote
0answers
676 views
Where's my bug? VBA - How to select a folder in Outlook to import to Excel
The code below is supposed to harvest contacts from a folder within Outlook in to Excel. The user gets to pick the folder because I want them to pick a folder that is not the default contacts folder.
...
1
vote
0answers
122 views
Alternate to ShowCategoriesDialog to show most recent categories
I wrote a macro that prompts me to add a category to an outgoing e-mail if there are none (saves time when looking for 2-year-old e-mails).
I noticed that if I categorize an e-mail manually without ...
1
vote
0answers
616 views
Deploy Outlook UserForm
I made an Outlook user form which I intend to give out to some colleagues. However I am a bit unhappy with the installation procedure, which goes approx. like this:
allow unsigned macros
open VB ...
1
vote
0answers
1k views
Setting up a macro in Outlook 2010
I need some in adding a step in one of my macros I use in Outlook 2010. What I want it to do is whenever I use this particular macro (that opens a new email from a template) I would also like it to ...
1
vote
0answers
365 views
Modifing an X-Header on Outlook using a VBA Macro
I need to write a OutLook macro to read a special email header ("X-SpecialMe") and modify it.
How is it possible to modify an X-Header on OutLook?
Can you modify it before sending an email (inside a ...
0
votes
0answers
40 views
get recurring appointment item date between my date range
This is my piece of code.
outlook_Items.Sort "[Start]"
Set outlook_Items = outlook_Items.Restrict(strFilter)
For Each MyItem In outlook_Items
Set MyRecur = ...
0
votes
0answers
16 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
...
0
votes
0answers
14 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
0answers
23 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
0answers
136 views
Counting Emails in outlook 2010 in specific folder
Ok, I'm not all that familiar with VBA coding so I was hoping someone would be feeling helpful and see why the code (got code from another ticket on this site), which seems to work but generates an ...
0
votes
0answers
56 views
Outlook email word frequency analysis
Can anyone think of a faster macro for outputting word frequencies from all emails in an Outlook folder? The goal is to get both a count of how many times each word occurs, and how many emails it ...
0
votes
0answers
48 views
Outlook Adressbook in Access 2010 - VBA
I am trying to access the Outlook Adressbook via Access. Once a contact is selected, it shall be availabe as an Object in Access to further work with it.
This worked fine with Office 2007 using the ...
