Making all Drafts High Priority.

K

kcaenj

Board Regular
Joined
Oct 13, 2004
Messages
197
I have about 150 messages in my draft folder that are ready to send however I just realized that all of them need be marked High Priority (red exclamation point) and they also need to have a read receipt attached to them. In addition the following email needs to be added to the CC: line of the message (scott@abc.com).

Is there a way I can program a macro to do this for all of the messages? I am not sure how this would be done in Outlook 2000.

Any help would be appreciated.

Thanks,

KC
 

Excel Facts

Can you sort left to right?
To sort left-to-right, use the Sort dialog box. Click Options. Choose "Sort left to right"
Sort by date Sort by votes
Hi,

Something like this should work for you:

Code: 
Sub UpdateMessages()
    Dim olMsg       As Outlook.MailItem

    For Each olMsg In Application.GetNamespace("MAPI").GetDefaultFolder(olFolderDrafts).Items
        olMsg.Importance = olImportanceHigh
        olMsg.ReadReceiptRequested = True
        olMsg.Save
    Next olMsg

End Sub

HTH
Dan
 
Upvote 0
You must log in or register to reply here.

Similar threads

G
  • Question Question
Modify Single Email in Outlook Drafts subfolder
Replies
0
Views
205
g_speran
G
R
  • Question Question
Mail merge to insert the picture in the mail body and schedule the email
Replies
0
Views
1K
rafeek4u
R
G
  • Question Question
Modify Single Email in Outlook Drafts subfolder
Replies
1
Views
332
g_speran
G
M
  • Question Question
VBA for sending all emails in outlook draft folder
Replies
8
Views
1K
Moustafa Houssien
M
E
  • Solved
Using Excel to copy and paste one of 9 different replies
Replies
6
Views
265
ellison
E

Forum statistics

Threads
1,222,749
Messages
6,167,967
Members
452,158
Latest member
MattyM

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top