All Questions
Tagged with vba microsoft-outlook
158
questions
0
votes
1
answer
74
views
Counting the number of selected messages in Outlook when Conversation mode is on using VBA
I need to count some mails in Outlook for Windows. There are some workarounds to do so, but the only real solution I found is to use a VBA script as described in this other question here:
How can I ...
- 1,211
0
votes
0
answers
33
views
Mentions affecting Regex Validation
I was wondering if anyone came across the issue with Regex validation in Microsoft Outlook when including mentions (i.e.,@Tony or @Jodie). The below code works fine when there is no mentions in the ...
0
votes
0
answers
155
views
Outlook 365 VBA to access entries in a group mailbox contact list
I don't know if this is possible but I want to insert into the To of an email, an entry from the contacts part of a group mailbox address book.
I have managed to find the code to show the contact list ...
0
votes
1
answer
33
views
Using Javascript in TextExpander to validate text on the clipboard and make it Bold
I'm not sure if this is possible but essentially I haven't been convinced to switch to the new Microsoft Outlook because I value the functionality of VBA. Specifically, I use VBA to always validate ...
-1
votes
2
answers
140
views
Pop out emails in folder pane only when in reading reply/foward pane? [closed]
I have a code that I want to (upon manually running the code) pop out the email in the folder pane to a pop out window. I only want it to do this whenever I am currently drafting a reply/forward.
...
1
vote
0
answers
62
views
Outlook rule to move a different email than the one that triggered the rule
I get a series of emails (separate, not in the same conversation) for approvals. The first email will have a subject line "ACTION REQUIRED: [XYZ] approval request." If another user ...
- 11
0
votes
2
answers
874
views
How to use Excel to produce Timesheet from MS Outlook calendar?
This question is mainly to share my idea.
On daily bases I have problem to fill in my timesheet. I work different hours every day and at the end of the month I have to submit Excel timesheet that ...
- 21
3
votes
1
answer
664
views
Automatic reply in Outlook when out of office
For my e-mail account on a Microsoft Exchange Server, I would like that, for each email received where the following two condition are met :
I am in the to: or in cc:
I have an "out of office&...
- 31
1
vote
1
answer
239
views
Outlook VBA - linked image in ReplyAll mailitem created from Custom from template not displaying
The below code creates a mailitem from a custom Outlook Form Template and a ReplyAll mailitem and appends the ReplyAll mailitem to the Template mailitem. However, the image icon from the Outlook form ...
- 111
0
votes
1
answer
9k
views
Reoccurring Out of Office Every Other Week Outlook
In Outlook, is it possible to set a an out of office automatic reply every other week on the same day? e.g. every other Monday.
I see a solution here using headers for every week: https://answers....
- 115
0
votes
1
answer
811
views
How to Automate Outlook to Count Emails [closed]
Gentlemen, I have a graph made in Python where it shows the count of how many emails were received for "Refunds", "Received", "Account Closure". However, this "data&...
- 3
0
votes
1
answer
524
views
Outlook VBA - go to specific public folder wthout giving the complete folder name
I usually need to go to some specific folders to see the containing emails.
These folders are in Outlook exchange public folders.
I have managed to write a script that I can enter the full name of the ...
1
vote
0
answers
105
views
How Can sort hundreds of emails in outlook alphabetically by company name?
So first of all, I have Windows 11 and my version of Microsoft Outlook is 2010.
I am the accounts payable clerk for my company. I recently went paperless and am trying to find some shortcuts to ...
- 11
0
votes
1
answer
524
views
I need VBA code to select certain rows based on grouping data in one column and email that selection
I need to select rows based on email address and mail it to that address. I only have code that will send a worksheet to email
The image is the sample file. The macro needs to select the rows based on ...
0
votes
0
answers
3k
views
How to make a Search with VBA through all folders and change the links in Outlook?
I stuck with one problem. I have my outlook and I have some folders there with messages. I need to go through all these folders and then replace the links in those messages. Is it possible to do?
I ...
- 13
0
votes
1
answer
556
views
Outlook VBA - open email attachment in appointment and extract sender's email address
I have over 200 calendar (appointment) entries and all of them contain the original email message as an attachment. I need to extract the sender's email address from the email attachment in the ...
- 1
0
votes
1
answer
247
views
How to use regex to replace text in forwarded email
I have the following code that I pulled from, niton (VBA to forwarding emails in Outlook).
Private Sub objInboxItems_ItemAdd(ByVal item As Object)
Dim objMail As MailItem
Dim objForward As ...
- 1
0
votes
1
answer
3k
views
Outlook - How to get folder name of MailItem in VBA macro
I have an outlook VBA macro in which I would like to check that a given MailItem object belongs to a specific outlook folder. Is there any way I can accomplish this? I can use
Set objFolder = ...
- 230
1
vote
1
answer
2k
views
Outlook VBA: How to get 'To' first name?
I can get email 'To' recipient full name with below code.
Set oMItem = ActiveInspector.CurrentItem
recip = oMItem.To
How to get only first name directly?
Note: In some system, it shows last name ...
- 697
1
vote
1
answer
145
views
Outlook Blank Subject Crashes Rules... VBA to Resolve doesn't show in Scripts list
So there is a known bug in Outlook, where my blank subject lines in incoming rules on IMAP&SMTP accounts cause forwarding rules to error and crash, and ultimately disables the rule.
I thought a ...
- 113
0
votes
2
answers
490
views
How to forward new email to next team member using VBA?
I run a sales team and we get referrals in our team inbox. I manually forward each new referral to my team members and this is a huge waste of time.
I'm looking to forward each new referral email to ...
- 1
0
votes
2
answers
959
views
How to set automatically a reminder depending on meeting time
I don't know how many of you have the same problem, but I work in a company where most of the colleagues wake up considerably earlier than I do.
This led in the past to me missing by 30-40 minutes a ...
1
vote
1
answer
506
views
Outlook 2013: export SMTP addresses of the Exchange contacts
Outlook's 2013 Export to CSV doesn't output SMTP addresses of the Exchange contacts.
Is there a viable VBA or non-VBA workaround for this?
Thank you.
- 130
3
votes
1
answer
3k
views
Keep as Unread when open/ double click email on outlook
I would like to keep the Read/ Unread Status while I open/ double-click the e-mail on outlook. Unfortunately, It seems that there is not exist any default setting/ option to define the function.
For ...
- 85
0
votes
1
answer
278
views
Outlook alerts user when an email contains certain words and warns before sending
I would like to be alerted before I send an email if the email I am composing contains certain words.
Example: Dog, cat, mouse,
I would like to be alerted if I forgot to change any of the words listed....
- 1
1
vote
1
answer
922
views
Allow Outlook VBA to run when item selected in explorer
I have code to pop a message up if I hit Reply rather than ReplyAll when responding to a certain customer.
I got it to run when I have the email open in the active window but not in the explorer pane.
...
- 11
1
vote
2
answers
1k
views
Outlook Rules Sending Auto-Reply Over Specified Time Range
I am seeking help with Outlook Webmail.
Specifically I am trying to set up auto-reply messages during certain times of the day.
Outlook offers out of office emails, but I am trying to set up rules ...
- 111
1
vote
3
answers
1k
views
Canned auto email forward (with attachments) in Outlook 2013
I get emails sent into me from one sender (with attachments). All I do is forward (not reply) that email to another recipient with a short sentence (always the same).
Surely this could be automated .....
- 201
1
vote
1
answer
1k
views
Excel VBA send e-mail with variable number of attachments
I am trying to write some VBA code that will open outlook and attach all the PDFs in a certain folder to the email. I know how to do it for one item, but since I don't know how many items the folder ...
- 174
0
votes
1
answer
483
views
Outlook VBA - A startup macro that moves incoming undeliverable (NDR class) messages for multiple shared inboxes
I have a little experience in Java but barely any in Visual Basic. I need to create a macro for my work Outlook that has 4 inboxes in the profile. One is my [email protected], another is for marketing@abc....
- 1
0
votes
1
answer
704
views
Outlook VBA - Automatically create a folder based on date
I have created a VBA script that will automatically save pdf attachments. Does anyone here know how can I save the attachment based on the date? For Example, today is 02-04-2020 then this specific ...
- 1
0
votes
1
answer
4k
views
VBA to forwarding emails in Outlook
I'm trying to create a vba that can forward emails I received. The only problem is that the emails I'd like to forward have different subjects. Only the beginning is the same. This is how far I've ...
0
votes
2
answers
2k
views
VbaProject.OTM does not work unless VB Editor opened once
I'm looking for a solution to my issue which is when I copy my VbaProject.OTM and open Outlook my macro's don't run. All I have to do is open the VB editor and then close it/close outlook and start it ...
- 1,455
0
votes
1
answer
2k
views
How to replace text in body of incoming message in Outlook 2013 with VBA without losing formatting
This post discusses a VBA solution to replacing text in an incoming email with Outlook rules.
I used the same approach to remove "External Message" text from the top of emails I receive (it's ...
- 141
0
votes
1
answer
304
views
How to get all TaskItems for recurring task Outlook (VBA)?
I need to get list of all tasks for specific dates. How can I loop in VBA every TaskItem for recurring tasks?
For Appointments there is method .GetOccurance, but it's don't work for tasks.
- 19
0
votes
1
answer
2k
views
Schedule Run Outlook VBA Script At Time
This question is a different (simplified) version of this SO post (link).
I have a particular outlook VBA script I want to run automatically at 2 PM every day (and others at multiple other times). ...
- 262
1
vote
1
answer
279
views
Force Outlook Filter Refresh
In Outlook 365 I use a filter showing unread and flagged items as my primary view rather than my inbox. This works well except that read items don't disappear from this filter view until I move to ...
- 1,866
0
votes
1
answer
55
views
Mark email messages received with delay
For many reasons an email message can be hold up in mailservers for several hours or even days.
I wanted to create a rule that assigns a given category to messages received with a delay greater than ...
0
votes
1
answer
82
views
copy an outlook appointment and send it to an other mail
Problem is, I don't have a work phone. But I would like to know when and where my appointments are on my private phone.
I need a rule that does the following:
- find all Outlook appointments
- copy ...
- 1
0
votes
1
answer
2k
views
Link send Email to Outlook and Subject is equal to cell value vba
I've created an hyperlink name send I want it, when the user click it
outlook will automatically display. and I want subject will equivalent to cell value
example here's my col:
col 1 |col 2 |...
- 45
1
vote
0
answers
236
views
MS Outlook VBA Script - Automatic Print ORIGINAL email when it gets undelivered [closed]
I'm using MS Office 2016 Desktop App on Windows 10 and looking for some functionality which I didn't find any success after searching online a lot and also contacted MS Outlook Support to only find ...
- 111
2
votes
1
answer
1k
views
Outlook run VBA script on email to move to folder based on 6-digit number in subject
Our company uses a 6-digit number for our projects. I'm attempting to create a script that will search the email subject for this 6-digit number, then find the subfolder that starts with this 6-digit ...
- 31
0
votes
1
answer
205
views
Outlook / VBA How can I count the mail I moved by outlook rules?
I have created outlook rules for a shared mailbox. Now, I would like to understand how many of the e-mails are processed through the rules. One of the rules is that an email is moved based on the ...
- 1
0
votes
1
answer
281
views
Add todays date when opening saved email template
I want to add a message and the date when ever I open an email template I have saved.
I could only manage to get to the below bit of code:
Private Sub adddate()
.Item.Subject = "Prep Status ...
- 7,485
0
votes
0
answers
6k
views
See who last changed category color on outlook email
Here is the situation. Someone at work in a shared inbox keeps changing the category on incoming email to a specific color. For this shared inbox those colors represent the employee who has picked up ...
- 204
0
votes
1
answer
569
views
Save and rename an attachment from outlook 2013 to a specific folder
I have been using the steps from another post on this site and it worked for a few days and now it does not. The file always comes in from the same person and is always an xlsm attachment.
I enabled ...
0
votes
1
answer
160
views
Hotel software opens E-Mail Window in Outlook with generated text - how to change it automaticly to html or trigger a vba script?
My situation: A hotel managment software generates a text and opens a "New E-Mail" Window in Outlook with that text preset. However, I need the E-Mail to be in HTML format, apply some formatting and ...
- 192
1
vote
1
answer
2k
views
VBA macro to open Outlook 2016 message as "Editable"
I'd like to be able click a QAT shortcut to run a macro which opens the current Outlook message in editable mode. And inserts the text "[Edited]" so I can see it has been.
I had a solution for ...
- 21
2
votes
2
answers
32k
views
Cannot get Outlook application object to work
I'm trying to write a program that lists the members of an Outlook email distribution list.
I've found that VBA seems to have objects that could make this possible, but I haven't yet been able to get ...
- 385
0
votes
1
answer
521
views
Make outlook add a signature based on a certain value [duplicate]
So in outlook you can select an email address in the from field for a new e-mail. I was wandering, can I make outlook add a signature based on the value in the From field. So when i send on behalf of ...