| Thread | Last Author | Messages
read/total | Date |
|---|
| Inline Attachments |
Silas Peterson |
0 / 1 |
22 Nov |
| Thank you. I tried reading the properties using Redemtion and it works fine for Outlook 2003 and 2007.
Regards,
Silas.... |
| How to replace text upon receipt of message using a Rule? |
RogerM |
0 / 1 |
21 Nov |
| I'm trying to run a sript that will execute when an email message arrives
that will replace ]] with %5D%5D. I've tried the code below, but keep keep
getting an error that a user-defined type isn't defined. Maybe the code
below isn't even close for what I'm trying to accomplish, I don't know.
Any assistance would be appreciated. ~ Roger
Sub FixHyperlink(MyMail As MailItem)
Dim... |
| Can I restrict email sent in Outlook without using Exchange? |
answrtek |
0 / 7 |
21 Nov |
| That does it. Perfect. I tweaked the following to match and it did exactly
what I was trying to do.
If ((ct.Email1Address = recip.Address) Or
> (ob.Email2Address = recip.Address) _
> Or (ob.Email3Address = recip.Address)) Then
>>>>Changed ob to ct in email2address and email3 address.
Another headache put to bed. Thank you for your help.
answrtek
"Ken... |
| Outlook Toolbar button to open web link in Outlook and not IE |
Murphybp2 |
0 / 1 |
21 Nov |
| I would like to create a toolbar button that opens a specific webpage
in Outlook, instead of opening IE. I've searched multiple places, but
haven't found anything that I can get to work. I saw the code at
http://www.outlookcode.com/d/tips/formhyperlink.htm, but I don't know
where I would put the link in this code. Every time I try and run it
I get a run time error that object is... |
| Trying to run this macro to save Outlook mailbox folder list - |
Alan Moseley |
0 / 4 |
21 Nov |
| Hubert
If you debug the error can you find out which folder it is trying to iterate
through? I would think that you don't have permission to access a folder
somewhere along the lines.
--
Alan Moseley IT Consultancy
http://www.amitc.co.uk
If I have solved your problem, please click Yes below. Thanks.
"Hubert" wrote:
> Thanks Alan & Michael, your suggestion enabled me to... |
| Help on setting a Server Side Rule |
Joe Mac |
0 / 1 |
21 Nov |
| All...
I have established a Rule using the Wizard to automatically have the Server
respond with a specific message to an incoming mail message that meets
defined specifications... the challenge is to capture the "Subject" line or
the "To" address from the message that triggered the Server Responce event
and have the details pasted into the Server response message...
Can it be... |
| Moving inbox-items to personal folder |
Ken Slovak - [MVP - O... |
0 / 2 |
21 Nov |
| Where is "archive"? Is it located in the same PST file as your Inbox or in
another PST file? That would affect how the code would be written.
What version of Outlook?
--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm
"Michael... |
| how do i close my e-mail account permanantly? |
cindy |
0 / 1 |
21 Nov |
| I want to close my email account permanantly. Please assist me.... |
| Trying to run this macro to save Outlook mailbox folder list - but it doesn't... |
Michael Bauer [MVP - ... |
0 / 2 |
20 Nov |
| You'd need to install the CDO 1.21 library on your computer. But instead you
could also rewrite the code and use Outlook objects instead of CDO. Here's
an example for how to loop recursively through the folder using Outlook
objects:
http://www.vboffice.net/sample.html?mnu=2&pub=6&lang=en&smp=12&cmd=showitem
--
Best regards
Michael Bauer - MVP Outlook
: Outlook Categories?... |
| How can I force New Message cursor to start in bcc field |
Sawdust |
0 / 3 |
20 Nov |
| Thank you.
The Custom Form route appears to be the way to go.
I'll let him trake it from there.
"Ken Slovak - [MVP - Outlook]" wrote:
> There is no macro recorder for Outlook, you have to write VBA code from
> scratch.
>
> There's also no way to set up what you want without a custom form unless you
> use SendKeys
> and send tab characters to the open item when it first gets... |
| empty outbox ? |
Ken Slovak - [MVP - O... |
0 / 2 |
20 Nov |
| Yes it is, but if you do that you will cancel any send operation that's in
progress or get an error that the send is in process and the items can't be
accessed. So it's not really a good idea to do that.
--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.... |
| Setting reminder: Date format |
Ken Slovak - [MVP - O... |
0 / 2 |
20 Nov |
| There is no setReminder method or property.
What language are you using? What type of item do you want the reminder set
on?
How you set a reminder depends on what type of item you are working with.
For example if you have an appointment item that you want to set a reminder
on and you're using VBA code then you'd use code like this:
itm.ReminderMinutesBeforeStart = 60
itm.... |
| Removing recurrence in VBA |
Ken Slovak - [MVP - O... |
0 / 2 |
20 Nov |
| You do know that using GetRecurrencePattern() will make an item recurring
even if it isn't recurring, don't you? You should check first for
itmAppointment.IsRecurring() and only get the recurrence pattern if the item
is already recurring.
I don't know if that's the problem but I'd make that change anyway. I'd also
eliminate the access to RecurrenceState since you aren't doing... |
| outlook signature added to automated messaging? |
DStrong |
0 / 3 |
19 Nov |
| Kyle-
Did you ever get your issue resolved? I had this very same issue and
after trying a slew of ways to get this done I have take the advice from Sue
here and Ken Slovak as well and formed a very simple, quick way to do this.
It is not perhaps the most effective, but it works and works very well. I
have tested it from a personal account to an exchange server and had no
issues.... |
| Move item between folders |
Ken Slovak - [MVP - O... |
0 / 4 |
19 Nov |
| The declaration for colFolderItems needs to be at class level outside of the
startup procedure so it stays alive after that procedure ends. You'd also
need to have the items you're adding to the collection already instantiated
of course.
To instantiate a Class1 object do this:
Dim oClass As New Class1
You then need to set oClass (Class1) Folder and Items properties so those... |
| Changing folder description doesn't "stick". |
Jason Chapman |
0 / 1 |
19 Nov |
| My first Outlook VBA. I am trying to work through folders (typically
inboxes), archiving e-mails off to the appropriate place. As there are
thousands of e-mails in the inbox, I thought I would have a button that
allowed me to record what date the last e-mail looked at was, so I can
come back to that point and continue archiving in the future.
I thought I would use the folder... |
| How do I call a VBA subroutine from Javascript |
SteveR |
0 / 5 |
18 Nov |
| Understood and thanks for the reply. I'll see if the PPT General fourm has
an equivalent.
sr
"Ken Slovak - [MVP - Outlook]" wrote:
> Yes, but only if the code is in the ThisOutlookSession class of the Outlook
> VBA project. It might or might not work in some other application's VBA
> project, that's not an Outlook question.
>
> --
> Ken Slovak
> [MVP - Outlook]
>... |
| How do I expose internet headers in code? |
Wayne (CDX) |
0 / 4 |
18 Nov |
| Oh - and I disagree about what I am doing to avoid spam. I have been quite
successful at blocking the majority of spam from my exchange server by
blocking the sender's mail server IP and reporting the abuse to the NOC of
the ISP. Most of the SPAM servers are bots running on some poor unsuspecting
user's computer. I never reply to the domain the email lists as where it came
from.... |
| Can I restrict email sent in Outlook without using Exchange? |
Alan Moseley |
0 / 4 |
18 Nov |
| These lines are where it works out if the recipient is in the Contacts folder:-
If ((ct.Email1Address = mi.To) Or (ct.Email2Address = mi.To) Or
(ct.Email3Address = mi.To)) Then
Exit Sub
End If
Your code needs to be more detailed here. Each email has a recipients
collection, so you need to iterate through these really, for example:-
For Each rc In Mi.Recipients
If (rc.... |
| having a sent e-mail expire at the recipients after it is read |
Michael Bauer [MVP - ... |
0 / 2 |
18 Nov |
| You can set the expiry only by date.
--
Best regards
Michael Bauer - MVP Outlook
: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>
Am Mon, 17 Nov 2008 13:11:01 -0800 schrieb KODA:
> can someone show me a good way to do this?... |
| Incorrect received date on some messages (using Redemption) |
Ken Slovak - [MVP - O... |
0 / 10 |
18 Nov |
| Then I'm not sure. I'd probably experiment with getting the DateTime values
and using ToUTC() and play with that for a while to see if things are being
converted as expected and also try converting back, as well as trying the
MAPIUtils methods for local to UTC and UTC to local to make sure everything
is being converted both ways as expected.
--
Ken Slovak
[MVP - Outlook]... |
| Code pause when disconnecting from Terminal Services. |
Trefor |
0 / 1 |
18 Nov |
| I am running some code on a Windows XP PC using Office 2003 and I am
connecting to this PC via Remote Desktop (Terminal Services). While I am
connected everything appears to be fine, but if I disconnect and leave the
remote PC to run by itself I get issues. This code is in an Excel Module that
processes emails from an Outlook folder, so I am not sure if this is an Excel
issue or an... |
| Address Book Control? |
Nathan |
0 / 4 |
18 Nov |
| I think I could resolve my problem this time. O(∩_∩)O~
I think I could resolve my problem this time. O(∩_∩)O~
Dmitry Streblechenko Wrote:
> Use Namespace.SelectNamesDialog (Outlook 2007 specific)
>
>
>
> --
> Dmitry Streblechenko (MVP)
> http://www.dimastr.com/
> OutlookSpy - Outlook, CDO
> and MAPI Developer Tool
> -
> "Nathan" <Nathan.... |
| Two questions about how to use textboxes in userforms |
Michael Bauer [MVP - ... |
0 / 5 |
17 Nov |
| I'm sorry, I have no solution to #2. If the project file is corrupt, this
might help: Export all of your project files, close Outlook, and delete the
*.otm project file. Then re-open Outlook, start the VBA editor, and import
your project files and save, which creates a new project file.
--
Best regards
Michael Bauer - MVP Outlook
: Outlook Categories? Category Manager Is Your... |
| Save Email message as HTML file on Harddrive |
Michael Bauer [MVP - ... |
0 / 9 |
17 Nov |
| Terry, recommended books are:
Professional Programming Outlook 2007, Wrox Press, by Ken Slovak
Microsoft Outlook Programming, by Sue Mosher
--
Best regards
Michael Bauer - MVP Outlook
: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>
Am Tue, 11 Nov 2008... |
| How to set button priority in groups on Outlook 2007 Inspector tab |
Ken Slovak - [MVP - O... |
0 / 2 |
17 Nov |
| No, the ribbon doesn't work that way. You can make your button visible and
invisible, that's about it.
--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm
"a3kumarz" <a3kumarz@discussions.microsoft.com> wrote in message... |
| How to connect a contact to an appointment in Outlook 2007 |
MarceepooNu |
0 / 3 |
16 Nov |
| Thank you.
--
MarceepooNu
"Michael Bauer [MVP - Outlook]" wrote:
>
> Click Tools/Options/Contact Options/Show Contact Linking on all Forms
>
> --
> Best regards
> Michael Bauer - MVP Outlook
>
> : Outlook Categories? Category Manager Is Your Tool
> : VBOffice Reporter for Data Analysis & Reporting
> : <http://www.vboffice.net/product.html?pub=6&lang=en>
>
>
>... |
| Moving Calendar items to a folder |
Michael Bauer [MVP - ... |
0 / 2 |
16 Nov |
| Get the default calendar with the olFolderCalendar constant. As items in a
calendar are AppointmentItems and not MailItems, you need to change the
declaration of the objItem variable.
--
Best regards
Michael Bauer - MVP Outlook
: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.... |
| Displaying Calendar Explorer |
Dan |
0 / 4 |
14 Nov |
| Sorry, my bad. Should have been
Set expActive.CurrentFolder = objFolderCalendar
Thanks, works great.
Dan
"Dan" <dartuso@NOSPAMpagepearls.com> wrote in message
news:O1rh57oRJHA.4916@TK2MSFTNGP06.phx.gbl...
> Hi Ken,
> Thanks.
> I've tried this but it errors out... is this what you meant?
>
> MyStartTime = Now
> Set objFolderCalendar = objNamespace.... |
| open source removing duplicate contacts |
Ken Slovak - [MVP - O... |
0 / 5 |
14 Nov |
| Look at the Navigation Pane when displaying the Folder List. If it says
something like "Personal Folders" or "Outlook Today" at the top of the
folder list you're using a PST file and not an Exchange mailbox. If you're
using Exchange it would say something like "Mailbox - your name here".
The quoting is confusing because of how it works with multiple quote
characters. I usually try to... |
| moving email messages from one folder to another existing fold |
DanWo |
0 / 7 |
14 Nov |
| the message is moved there using a rule.
"Dmitry Streblechenko" wrote:
> Where are these folders located relative to the root/Inbox/etc folders?
> How does the messgae end up in the KanaDaily folder to begin with?
>
> --
> Dmitry Streblechenko (MVP)
> http://www.dimastr.com/
> OutlookSpy - Outlook, CDO
> and MAPI Developer Tool
> -
> "DanWo" <DanWo@discussions.microsoft.com>... |
| Outlook Contacts Macro to Change Info |
Michael Bauer [MVP - ... |
0 / 2 |
13 Nov |
| Use the GetDefaultFolder function to get the folder,then loop through its
Items collection, and change each ContactItem's title property, then call
Save.
--
Best regards
Michael Bauer - MVP Outlook
: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>
Am Thu, 13 Nov... |
| Outlook VBAProject.otm reverted to prior version |
Steve Kiwi |
0 / 5 |
13 Nov |
| Yep, I know that now! When I began I was given a form someone else had
started, and just continued developing from there. As time has gone on, it's
become harder and harder to manage, and for users to install or update.
Today I am starting the process of converting it to a COM add-in, which will
hopefully not be too much more than copying and pasting the code I already
have.... |
| creating and setting userproperties programmatically |
Preston |
0 / 4 |
13 Nov |
| i guess it makes more sense if i consider it in light of the mailitem being
an object. i was thinking along the lines of defining variables and such.
strSweet = "sweet" or even DELETE * FROM tblWasMyLoot;
those are the types of changes that I was thinking of.
thank you for the response :)
"Ken Slovak - [MVP - Outlook]" wrote:
> What's to understand? In any code if you don't save a... |
| What is wrong with drop-down box? |
Ken Slovak - [MVP - O... |
0 / 8 |
13 Nov |
| Did you set the ComboBox.ListIndex property to a valid index value?
--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm
"cinnamngrl" <cinnamngrl@gmail.com> wrote in message
news:39b26398-0c68-4768-a0db-7b18a9f3a7f9@r15g2000prh.... |
| Macro with multiple Lines of text for email OL 2007 |
Winnipeg Michael |
0 / 5 |
13 Nov |
| You mean to try this:
mymail.body = "some text" & vbCrLf & "some more text" & vbCrLf & "yet more
text" & vbCrLf
"Preston" wrote:
> If you have something that you want to append to the body then you might try
> always making the last character in the body be vbCrLf. Then when you append
> things to the body you can use the logic
> mymail.body = mymail.body & "new text to add... |
| Recursively set Auto Archive settings on a sub folder |
Tara H |
0 / 1 |
13 Nov |
| A year or so ago I found a piece of code that, when attached to a toolbar
button, allowed me to set the archive settings on a top-level folder, click
on the button, and it would set all sub-folders to the same setting.
Unfortunately I lost it when I got a new work laptop and now I can't track
this down. I don't have the spare time or expertise to write it myself from
scratch - does... |
| Outlook script macro issue |
Ken Slovak - [MVP - O... |
0 / 8 |
12 Nov |
| Normally it would disable the rule if the script threw an error and since
you have no error handling there I'd expect to see an error message if the
script code did fire an error.
It's possible that only certain items are causing errors, but that doesn't
explain it not showing any error messages. About the only thing I can think
of would be to simplify and temporarily comment out... |
| Link To Outlook Address Book Slow |
Dmitry Streblechenko |
0 / 4 |
12 Nov |
| Why do you want to retrieve *all* the GAL entries? Outlook never does that -
it only retrieves whatever is visible to the user (220-30 entries at a
time).
I would take another look at your design if I were you - more than a dozen
entries in a combo box makes it unusable to an end user. Thousands of
entries is certainly unacceptable.
--
Dmitry Streblechenko (MVP)
http://www.... |
| Modify default incoming Message form |
Ken Slovak - [MVP - O... |
0 / 2 |
12 Nov |
| See http://www.outlookcode.com/article.aspx?id=39
--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.slovaktech.com/products.htm
"Diego" <Diego@discussions.microsoft.com> wrote in message
news:2DB25093-E588-4E0C-B691-7B25EDBD5DCF@microsoft.com...
> Hi,
>
>... |
| Summarizing personal folders |
DKS |
0 / 4 |
11 Nov |
| Seems to be working. I will work out the outputting stuff.
Thanks for your assistance.
"Alan Moseley" wrote:
> You are asking for a fair bit here, and I don't really have the time to write
> a full application. The code below should get you started, just replace the
> Debug.Print line with file output code . Run the 'ScanAllFolders' macro.
> This in turn calls the... |
| How to get the sent mail time stamp using VBA Macros or by rul |
DKS |
0 / 3 |
11 Nov |
| Hi Alan,
This solution looks quite similar to what I am looking for (see my post
Summarizing personal folders that was done just around the same time as you
keyed your solution in).
Only difference in my case is that I want a personal folder to be scanned
and not a SENT folder. In the personal folder, there would be mails SENT by
me and mails RECEIVED by me (as compared to only... |
| CSS formatting of emails |
Graham Y |
0 / 1 |
11 Nov |
| I know this is not VBA, but I couldn't see any better groups to post this
question to!
I am trying to create a html template for our emails, I've tried using
tables and when someone replies, all the table borders suddenly appear, and
if I just use CSS then Outlook seems to throw away all my div deffinitions,
so the result looks awful.
Any advice, or pointers gratefully received... |
| resending an email |
Alan Moseley |
0 / 3 |
10 Nov |
| I would get your Exchange administrator to set the forwarding up for you (in
your Active Directory user properties), it won't take them more than a minute!
--
Alan Moseley IT Consultancy
http://www.amitc.co.uk
If I have solved your problem, please click Yes below. Thanks.
"Rudy L." wrote:
> Hi, pardon the simplicity of the question, but I'm a newbie at Outlook VBA
>
> I... |
| Clean up File Link |
Ken Slovak - [MVP - O... |
0 / 2 |
10 Nov |
| To do that you need to use HTMLBody and not Body and to format your new text
correctly as HTML text using an <A> set of tags. Study some HTML messages
that have text showing for an URL link and see how they do it.
--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.... |
| Need Help for fire department |
Michael Bauer [MVP - ... |
0 / 4 |
08 Nov |
| With the Outlook object model you can't read by which account an e-mail has
been received. You could do that with Redemption (www.dimastr.com) for
instance.
Another workaround would be to create a rule to run a script. The condition
for that rule would be 'through specified account'.
That script could be something like this; you just have to add the
recipients:
Public Sub... |
| Add Hyperlink in Email |
Michael Bauer [MVP - ... |
0 / 5 |
08 Nov |
| That works only with html formatted e-mails. In html it looks like this:
mail.htmlbody=<a href='d:\test.txt'>file</a>
--
Best regards
Michael Bauer - MVP Outlook
: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>
Am Thu, 6 Nov 2008 15:58:21 -0800 (PST) schrieb... |
| Outlook CBA changing Fonts |
Michael Bauer [MVP - ... |
0 / 2 |
08 Nov |
| If that's an html formatted e-mail, you need to write into the HTMLBody
property, and use html tags.
--
Best regards
Michael Bauer - MVP Outlook
: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis & Reporting
: <http://www.vboffice.net/product.html?pub=6&lang=en>
Am Sat, 8 Nov 2008 06:23:03 -0800 schrieb Sean McPoland:
> Hi all,... |
| Sorting Inbox |
Dan |
0 / 4 |
07 Nov |
| Thank you gentlemen!
Dan
"Dan" <noone@nowhere.com> wrote in message
news:%23fp96dNQJHA.5044@TK2MSFTNGP05.phx.gbl...
> Hi,
> I'm trying to time the sorting of the inbox on various fields like this:
>
> Set colItems = objFolderInbox.Items
> MyStartTime = Now
> colItems.Sort "From"
> TimeToSortInbox = DateDiff("s",MystartTime,Now)
>
> Unfortunately this is not an accurate... |
| Display "Last Update on ..." message on Calendar in public folder |
Ken Slovak - [MVP - O... |
0 / 2 |
07 Nov |
| You can't access the information bar or status bar or any of those places.
Your code could not show the menu button or toolbar button when the focus is
in a different calendar folder, just check for which folder will be
displayed by using the Explorer.BeforeFolderSwitch() event.
--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.... |