| Thread | Last Author | Messages
read/total | Date |
|---|
| 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... |
| 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.... |
| FlagStatus question |
Ken Slovak - [MVP - O... |
0 / 5 |
07 Nov |
| FlagStatus is available in Outlook 2000, I don't have an earlier version
running here at the moment.
--
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
"Salad" <oil@vinegar.com> wrote in message... |
| OL2007 - determine if shared calendar folder has been cached |
Tadwick |
0 / 2 |
07 Nov |
| From a registry comparison before and after setting this value I get :
keypath is :
[HKEY_CURRENT_USER\Software\Microsoft\Windows NT\CurrentVersion\Windows
Messaging Subsystem\Profiles\<profileName>\13dbb0c8aa05101a9bb000aa002fc45a]
key is : "00036601"
hex value = hex:84,19,00,00 on
hex value = hex:84,11,00,00 off
"Tadwick" wrote:
> It's my understanding that you can... |
| Notes field |
Michael Bauer [MVP - ... |
0 / 4 |
06 Nov |
| First you need to save the attachment as a file, then add the full name of
the file in this notation to the body property:
Body="<file:///d:\test.txt>"
--
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, 4 Nov... |
| add event macro |
Michael Bauer [MVP - ... |
0 / 2 |
06 Nov |
| Yes, I think so. But the main work isn't Outlook related: You need to
automate the IE, and navigate to the site. Then you need to parse all the
HTML that's returned, and find what you're looking for. It's not difficult
but a lot of work.
--
Best regards
Michael Bauer - MVP Outlook
: Outlook Categories? Category Manager Is Your Tool
: VBOffice Reporter for Data Analysis &... |
| Outlook Redemption expand distribution list |
Dmitry Streblechenko |
0 / 2 |
06 Nov |
| Did you see my reply in microsoft.public.office.developer.outlook.vba?
--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-
"Kalyan" <Kalyan@discussions.microsoft.com> wrote in message
news:D64D5C7D-57F5-4043-ACF1-15E94F3D1CD4@microsoft.com...
>I need to expand the distribution list(DL).. both DL in Exchange and
> private... |
| Trapping RDO (Redemption) Events in Delphi |
Dmitry Streblechenko |
0 / 13 |
05 Nov |
| You would need the RDOItems.ItemAdd event, where RDOItems is retreived from
RDOFolder.Items collection, where RDOFolder points to the Deleted Items
folder.
This is the same as in the Outlook Obejc tModel.
--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-
"Andrew Lockwood" <andrew@lockwoods.me.uk> wrote in message... |
| How to get an event when a meeting starts and ends |
Jan K |
0 / 4 |
05 Nov |
| The beginning and end are all I need, but it sounds like I have to use
reminders for this.... |
| Read all folders into an array |
Martin@att |
0 / 3 |
05 Nov |
| I knew it was just a simple matter of wording thanks!!
"Ken Slovak - [MVP - Outlook]" wrote:
> Doing a google search on "iterate Outlook folders" returned this as the
> first response:
>
> http://www.outlookcode.com/codedetail.aspx?id=1748
>
> --
> Ken Slovak
> [MVP - Outlook]
> http://www.slovaktech.com
> Author: Professional Programming Outlook 2007.
> Reminder Manager,... |
| Alt+F1 |
Larry S |
0 / 5 |
05 Nov |
| yeah, i did that. i just can't leave well enough alone. maybe i have ocd, but
i like just one button that simply says "Navigation Pane" to toggle on/off.
if that's not workable guess i'll just have to live with it, and maybe even
seek some counseling. btw, my previous computer was outlook 2007, although it
was an upgrade from 2003.
"Ken Slovak - [MVP - Outlook]" wrote:
> So you've... |
| capturing data on sending emails |
lhhlkh |
0 / 5 |
05 Nov |
| Ken Slovak wrote:
> A recipient would have to be running your software for that to be possible.
>
> "mdlister" wrote
>>
>> Thanks, that works really well on my machine, but if i send an email to
>> someone and they reply is it possible to capture it at there end or is
>> this not possible?
here's how I do this
1. based on words in subject line "Install Software", I send back an... |
| Code to start Word -- now it's not working? |
Ken Slovak - [MVP - O... |
0 / 8 |
05 Nov |
| You can certainly set your Wd and Doc objects to Nothing at the end of your
sub, but that's not likely the problem. You are using CreateObject() on
Word.Application, so each call will create a new instance of the Word
application process.
You might want to look into using GetObject() instead. Use that and if it
returns Wd as Nothing then call CreateObject() to create the instance... |
| Is there a way to get the profile name |
Ken Slovak - [MVP - O... |
0 / 3 |
05 Nov |
| The CDO download is only for Outlook 2007, where there is already a
NameSpace.CurrentProfileName property available. CDO 1.21 for earlier
versions of Outlook is located on the Office CD.
Also, if the code is to be managed code CDO is not supported for use in
managed code.
--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.... |
| Detect which attachment Item(s) is selected in an email |
Ken Slovak - [MVP - O... |
0 / 4 |
05 Nov |
| No, that's not possible in Outlook 2003 or earlier.
--
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
news:3175926D-248A-4507-905C-DEFBD0339A72@microsoft.com...
>I... |
| What makes up a unique id for finding an email? |
Salad |
0 / 1 |
04 Nov |
| Using the Find method you can't use EntryID. Is the best way to find an
email is using the subject and create time values?... |
| automatically show/hide toolbar |
Peter T |
0 / 9 |
04 Nov |
| Yes you're right, I must have missed something somehow.
I never needed to manually add the (selfcert) certificate in IE
Options/Content but it's there.
On reflection I'll dispense with the ComAddin, VBA works just as well and
easier to tweak!
Regards,
Peter T
"Ken Slovak - [MVP - Outlook]" <kenslovak@mvps.org> wrote in message
news:%2382wPKsPJHA.4480@TK2MSFTNGP05.phx.gbl..... |
| Force SMTP CreateRecipient() in Exchange environment |
Dick Watson |
0 / 11 |
04 Nov |
| Imagine my surprise.
Microsoft codes a square wheel and it's always "by design".
"Ken Slovak - [MVP - Outlook]" wrote:
> Looks like "by design".... |
| Email Forwarding |
Ken Slovak - [MVP - O... |
0 / 6 |
04 Nov |
| Something like this, although this has no real error handling and needs to
be tweaked so there's no possibility of an endless loop. This code would go
into the ThisOutlookSession class module in the Outlook VBA project.
You would of course have to sign the project or lower macro security to have
it run.
Private Sub Application_NewMailEx(ByVal EntryIDCollection As String)
Dim... |
| Trying to have code close an open email after it saves. |
Ken Slovak - [MVP - O... |
0 / 6 |
04 Nov |
| See my signature :)
My book does have some on VBA and forms but is geared to more advanced
topics such as COM addins and concentrates on Outlook 2007.
--
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
"DStrong"... |
| Detect Fwd MtgItem on Send event |
Ken Slovak - [MVP - O... |
0 / 2 |
04 Nov |
| Until the item is actually sent the sender properties aren't filled in other
than SenderName. If you save the item in the Send() event handler you can
get that and the ConversationIndex and ConversationTopic properties. You can
then look for items with the same ConversationTopic (based on Subject) and
check for ConversationIndex length. Each new item in a conversation adds 6
bytes to... |
| DLL Hell with the View Control OUTLCTL.DLL |
Ken Slovak - [MVP - O... |
0 / 4 |
04 Nov |
| The old P&D wizard deployments are known for including everything including
the kitchen sink in deployments. Years ago when I used to use that package I
always spent a lot of time customizing what was deployed that wasn't needed.
I never deployed the VB runtime or any standard VB OCX's or DLL's, those are
already installed by Windows or Office, as long as you're targeting Office
98... |