| Thread | Last Author | Messages
read/total | Date |
|---|
| outlook 2003 sometimes turns off rule |
Penny |
7 / 7 |
01 Dec |
| JP wrote:
> Private WithEvents Items As Outlook.Items
getting an error on the above line and when I turn off the rule, none of the
code executes
Compile error:
Invalid attribute in Sub or Function
I did precisely per your example... |
| Moving messages from inbox |
Calum |
3 / 3 |
26 Nov |
| Thank you so much!
This works perfectly!... |
| Moving inbox-items to personal folder |
Michael Mueller |
3 / 3 |
24 Nov |
| >You can access all of the selected items via ActiveExplorer.Selection. Loop
>trough that collection, and call each item's Move function. See also the
>example for Move in the VBA help file.
Thanks, will have a try.
Michi... |
| Running an Excel macro via Outlook reminder |
Michael Bauer [MVP - ... |
5 / 5 |
24 Nov |
| If you want to run code in Excel, its Application.Run method is probably the
way to go.
--
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, 20 Nov 2008 09:55:49 -0800 schrieb exceldude:
> The problem is, I want... |
| Send an e-mail to a Group e-mail using Excel VBA |
Dmitry Streblechenko |
6 / 6 |
21 Nov |
| If you are using Exchange, simply set the MailItem.DeferredDeliveryTime
property and call Send.
If you are using SMTP, you would need to right code that actually runs at
the specified time and calls Send.
--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-
"exceldude" <exceldude@discussions.microsoft.com> wrote in message... |
| How do I programmatically send a multipart (plaintext/HTML) email? |
Ken Slovak - [MVP - O... |
3 / 3 |
20 Nov |
| You can't do that in Outlook. You'd have to use something like CDOSys or
whatever .NET has for sending emails without 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
"Mark B" <none123@none.com> wrote in message... |
| Move e-mails to another folder and Deleting them in folders us |
exceldude |
3 / 3 |
20 Nov |
| I have lots of folders in a particular folder.
> e.g. say my main folder is Test and then I have test 1, test 2 etc. within
> this folder.
>
> I have copied the whole test folder to an Archive area on the network.
I would like OUTLOOK VBA code as to how to do the following: -
1. to delete all e-mails in the Test folder and all subsequent
> > subfolders in the current area ( i.e.... |
| Running an Excel macro via Outlook reminder |
exceldude |
1 / 1 |
19 Nov |
| Hi
Every week, I need to send an e-mail containing an attchment to a group of
people.
I have the code below and was wondering how I can do this.
Error occurs at **
Help, please.
[code]
Sub Application_Reminder(ByVal Item As Object)
Select Case Item.Class
Case olAppointment
If Item.Subject = "Test" Then
'Set EApp = CreateObject("excel.Application")
'With EApp
'... |
| Delete files in a sub folder using VBA |
Ken Slovak - [MVP - O... |
5 / 5 |
19 Nov |
| Then you need to post in an Excel group.
--
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
"exceldude" <exceldude@discussions.microsoft.com> wrote in message
news:52A17377-2EC7-4ED3-B6CB-F653A0A9485C@microsoft.com...
> Thx for... |
| Moving inbox items Outlook 2003 using vba |
exceldude |
2 / 2 |
19 Nov |
| Thx.
"Dmitry Streblechenko" wrote:
> Set MoveToFldr = Fldr.Folders("Test").Folders("The subfolder of Test")
> --
> Dmitry Streblechenko (MVP)
> http://www.dimastr.com/
> OutlookSpy - Outlook, CDO
> and MAPI Developer Tool
> -
> "exceldude" <exceldude@discussions.microsoft.com> wrote in message
> news:0EE00EB2-FDF3-4F7C-9910-FF948AA264A4@microsoft.com...
> > Hi
> >
> > The... |
| SDRAM muisteja |
Herkko Blomberg |
1 / 1 |
19 Nov |
| ... |
| VBS Redemption - Enumerate/expand Outlook disribution list |
Kalyan |
10 / 10 |
12 Nov |
| Thank you very much for your help on this. We sorted out the issue. The
licensed version seems to have issue.. may be its a older version. We checked
it out with the dev version which is working fine.
"Dmitry Streblechenko" wrote:
> So your code is running under IIS? Or in a client side script in IE?
>
> --
> Dmitry Streblechenko (MVP)
> http://www.dimastr.com/
> OutlookSpy -... |
| Second Catagories Source |
Ken Slovak - [MVP - O... |
2 / 2 |
12 Nov |
| Yes, it's possible. Outlook won't use that control or its values but you can
write code that will do so.
--
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
"PJ" <yournumberplease@sbcglobal.net> wrote in message
news:ryiSk.... |
| Outlook combo boxes to pull data from access or other database |
PJ |
3 / 3 |
07 Nov |
| Thanks JP,
I found the following code below, from a website - thought I bookmarked it
but i couldn't find the website - for outlook 97 & 2000. I have 2003 and
don't know how to change the DBEngine to make it work probably - could you
guys please help. Thanks so much.
Dim rst
Dim dao
Dim wks
Dim dbs
Dim nms
Dim fld
Dim itms
Dim itm
Dim strOfficePath
Dim appAccess... |
| Redemption: DistributionList that reference another Distributi |
Ken Slovak - [MVP - O... |
11 / 11 |
06 Nov |
| If you're getting that error then you have to fix it before you could use
MAPIUtils. The error tells us that either Redemption is not registered
(check in HKCR\Redemption and see if that area exists and shows the various
Redemption classes), or that a script stopper is running that prevents using
CreateObject (or New or GetObject).
--
Ken Slovak
[MVP - Outlook]
http://www.... |
| Faxing problem via Simple Mapi in Server2003/Exchange environment |
Jimmy Hoffa |
2 / 2 |
30 Oct |
| For the sake of others who encounter this, I eventually found a solution.
More info here http://www.dbws.net/blog/
"Jimmy Hoffa" <jimmyHoffa@somewhere.com> wrote in message
news:ge6ivl$j8b$1@energise.enta.net...
> Hi All,
>
> Hoping someone can help me with this issue that has just surfaced at a
> customers who have recently upgraded their server.
>
> Our application sends... |
| Redemption: StartBy, DueBy and Completed properties of flagged items in outlo... |
Dmitry Streblechenko |
5 / 5 |
28 Oct |
| If you don't see a property that holds the value in oUtlookSpy when you
click IMessage, there is nothin you can do.
--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-
"Sandeep" <sandeep.nakarmi@gmail.com> wrote in message
news:73498d37-d1d4-41bc-a023-bacc54ce2d42@d1g2000hsg.googlegroups.com...
>I retrieve the properties by... |
| Retrieve StartBy, DueBy and Completed properties of flagged items in outlook ... |
Ken Slovak - [MVP - O... |
2 / 2 |
27 Oct |
| That means that no time element is present in those properties, so there is
no time to retrieve. Your best bet would be to get the last modified time
and hope that no one modified the item after marking it complete.
--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.... |
| Using Entry ID from Outlook Object Model in Extended MAPI |
Dmitry Streblechenko |
7 / 7 |
26 Oct |
| Opening the parent store first should work in all cases...
--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-
"Richard Gran" <"richard \"dot\" gran \"at\" redoxygen \"dot\" com"> wrote
in message news:uE53LWbNJHA.4116@TK2MSFTNGP02.phx.gbl...
> Yes that is right. I know this will sound a bit silly but I'm writing a
> program... |
| Redemption: StartBy, DueBy and Completed properties of flagged items in outlo... |
Sandeep |
1 / 1 |
26 Oct |
| I want to retrieve the StartBy, DueBy and Comepleted on, properties of
flagged items in outlook 2007. I am using redemption. How can i
retrieve these properties of Mail itemsusing Redemption ?. In outlook
spy, there are properties like StartDate, DueDate and Date Completed
which seem to be the properties i am looking for. But the time section
always is 12:00 AM no matter what time the flag... |
| Rule to Auto-Accept Calendar Invites from select emails |
Mitch |
2 / 2 |
24 Oct |
| Any luck on this issue? I have a similiar problem.
"w.shame@gmail.com" wrote:
> Hey,
>
> I'm trying to set up a rule in Outlook 2003 that automatically accepts
> any calendar invite from a select list of emails. I can set up the
> rule to only apply to Calendar Invites, and only for select people,
> but the Accept calendar invite action isn't an option.
>
> The one option I do... |
| Redemption: Get the FlagDueBy datetime value |
Sandeep |
3 / 3 |
19 Oct |
| yea it is outlook 2007.
So basically flaggeddueby property is the reminder datetime set. If
reminder is set on an item, then flaggeddueby will have value else it
wont.
Yea i looked for outlook 2003 and outlook 2007 and figured out that
startdate, duedate properties appear for flagged items in outlook 2007
only.
I am not setting anything up programatically so it will just show up
the... |
| Trade: Office 2007 Pro NFR for VC2008 Pro. |
B. |
1 / 1 |
16 Oct |
| I've got an unused/sealed Office 2007 Pro NFR to trade. It's a full
version, given to devs at the UK Vista launch event.
I'm looking for an unregistered VC2008 (Pro or better), as given out at the
more recent 'Hero' dev events (eg. UK Birmingham).
If you have one to trade mail me direct at loot68ATntlworldDOTcom.
(NFRs can't be sold, but can be given away, confirmed by MS).
--
B... |
| Politics |
Amy |
1 / 1 |
12 Oct |
| giving paths longgone alphabets wishing dumps guiltware rn sixletterism... |
| Outlook crashes when using PasteFace() method. |
Adi |
7 / 7 |
10 Oct |
| Thanks for your help.... |
| HTMLEditor pasting loses <BR> tags |
BertrandG |
4 / 4 |
09 Oct |
| Hi,
OK ! I feel a bit lost. I work in a support organization, and very often I
have to change only a part of the text in the email body. The mails (html,
RTF,...) are coming from the customers we are supporting.
I tried to find a solution with the clipboard the selection ... but never
sorted it out ...
Have a nice day.
WBR /bertrand
"DaveS" wrote:
> Hi Bettrand,
>
>... |
| Location of personal folder in Outlook |
Bruno News |
2 / 2 |
07 Oct |
| You can retrieve that info from the Outlook session you are in. Another
method would be to pull the data from the profile's registry keys, but I
don't have an example of how to do that. :-)
From within Outlook, you can use the following code snippet to get to all
the stores of the profile you are in and then get the file path of each one.
With the file path, you can then use the... |
| Advice needed |
Anrey Terkin |
1 / 1 |
02 Oct |
| i need help on my download scam site
the who is dns server is not working with my php database.
can anyone help?
you can email me directly or use this address
Address: Truda 14-1
City: Saint-Petersburg
State: Saint-Petersburg
ZIP: 188934
Country: RU
Phone: +7.9113234634
the site is
www.quicksoftupdate.com
thanks... |
| Very simple and basic requirement |
telepath2000 |
3 / 3 |
23 Sep |
| ... |
| Outlook behaving very sluggish and weird |
Alan B. |
1 / 1 |
19 Sep |
| For the past several days Outlook 2000 SP4 on Win 2000 Pro SP4 has been
behaving very strange.
When I delete an open email, it seems to have been deleted, but the open
email stays on the screen until I click the mouse anyplace on the screen -
then the screen updates and the previously deleted email closes.
I've scanned for viruses and don't have any.
Anybody ever experience this?... |
| How to automate backup of outlook files? |
Ken Slovak - [MVP - O... |
6 / 6 |
17 Sep |
| GetObject() would return the running instance of Outlook if there is one,
unless a script stopper was running that prevented that method from working.
You would use "Outlook.Application" as the argument to GetObject() or
CreateObject().
The task would be in the same context as whatever else you're running. If
your code kills an Outlook instance it would kill it for everyone, since... |
| Redemption: FlagDueBy property returns value 1/1/4500 |
Sandeep |
4 / 4 |
15 Sep |
| Ok, thank you michael and Dmitry for your response and suggestion... |
| Update Meeting Requests |
bolzy1981@gmail.com |
1 / 1 |
13 Sep |
| Hi Everyone,
In our exchange environment we have a number of user accounts setup
for meeting room bookings. Recently we had a problem and lost those
mailboxes, the Free/Busy data can still be seen but if you open the
calendar they are completely blank.
I am wondering if anyone knows of a way that I can run a script to:
1) Check a users calendar entries from "today" onwards
2) Look... |
| Need suggestion on VBA Macro Code for use in Outlook |
witwim1@gmail.com |
3 / 3 |
12 Sep |
| That worked great!
Thanks!!... |
| [VSTO] Addin to prohibit to add attachments |
Ken Slovak - [MVP - O... |
4 / 4 |
11 Sep |
| For an open item it's only Inspectors you have to be concerned with.
When WordMail is being used you won't be able to repurpose the original
buttons because they aren't exposed to you as you've found.
--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.
http://www.... |
| Get Clipboard from outlook.mailitem |
Tom |
6 / 6 |
11 Sep |
| this works fine in Outlook VBA
Private Function GetClipBoardData() As String
Dim lngClipMemory As Long
Dim lngHandle As Long
Dim strTmp As String
Dim lngTmp As Long
On Error GoTo PROC_ERR
If OpenClipboard(0&) <> 0 Then
lngHandle = WinGetClipBoardData(CF_TEXT)
If lngHandle <> 0 Then
lngClipMemory = GlobalLock(lngHandle)
strTmp = Space$(mcIntMaxSize)... |
| Determine language of newly composed email |
JP |
2 / 2 |
10 Sep |
| ... |
| Toggle read/unread |
Ken Slovak - [MVP - O... |
2 / 2 |
10 Sep |
| Macros in Outlook don't use shortcuts like that, you'd have to put a custom
button on a toolbar or menu that called your macro.
Did you know that Ctrl+Q will mark all selected emails as read, and Ctrl+U
will mark them as unread? If you want to use those existing shortcuts you
don't need any macros.
There's information on putting a macro on a toolbar at www.outlookcode.com
if you... |
| Handling Meeting Request send in outlook 2007. |
Ken Slovak - [MVP - O... |
4 / 4 |
08 Sep |
| Meeting requests will only be processed in the default calendar folder. If
moving it back to that folder and sending using code doesn't work then you'd
have to do your processing in the item.Send() event handler.
--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.
Reminder Manager, Extended Reminders, Attachment Options.... |
| citrate de sildenafil bon marche ed paquets dessai belgique acheter ed paque... |
sdgvfwe@yahoo.is.com |
1 / 1 |
06 Sep |
| citrate de sildenafil bon marche ed paquets dessai belgique acheter ed paquets dessai commander ed paquets dessai us usa par mail Achetez Le ed paquets dessai canada
+++ SANTE MASCULINE +++ SANTE MASCULINE +++ SANTE MASCULINE +++
+
ACHETER VIAGRA BON MARCHE (ALL CARDS ACCEPTED !!!)
http://jhku.net/ACHETER-VIAGRA-BON-MARCHE/
http://jhku.net/ACHETER-VIAGRA-SOFT/
http://jhku.... |
| on acheter valium us usa a vendre in Newton achat valium Pro Acheter achat va... |
sdgvfwe@yahoo.is.com |
1 / 1 |
06 Sep |
| on acheter valium us usa a vendre in Newton achat valium Pro Acheter achat valium canada en ligne sur internet on acheter valium en France a vendre acheter valium commander en ligne
+++ Anti Inquietude +++ Anti Inquietude +++ Anti Inquietude +++
+
+
+
ACHETER VALIUM BON MARCHE (ALL CARDS ACCEPTED !!!)
http://jhku.net/ACHETER-VALIUM-BON-MARCHE/
http://jhku.... |
| outlook macro |
Ken Slovak - [MVP - O... |
2 / 2 |
05 Sep |
| You might have better luck asking this in an Excel group since the
question's based on specific Excel behavior.
--
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
"Alberto Brivio" <a.brivio@adb.it> wrote in message... |
| How to attack the problem with activeX configuration, when vba programming i... |
Ken Slovak - [MVP - O... |
2 / 2 |
04 Sep |
| You might want to post this in an Excel group since it seems to have nothing
to do with Outlook.
You also aren't presenting enough information for anyone to really help you.
Is scripting installed on the computer where things aren't working? Is an
A-V program running there that might stop scripting operations? Have you run
in debug mode to see where you get errors?
--
Ken Slovak... |
| not found PR_SENDER_NAME |
Dmitry Streblechenko |
6 / 6 |
03 Sep |
| How exactly do you open the message directly from Outlook? Do you create a
temporary profile and connect to the mailbox in the online mode?
--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-
"Liam" <liamhar@gmail.com> wrote in message
news:8b3e812e-c295-45b1-bfaa-5a2e705c0fc7@f36g2000hsa.googlegroups.com...
* Same profile... |
| Save multiple items in selection |
Ken Slovak - [MVP - O... |
8 / 8 |
02 Sep |
| If there is an explanation it's not something I know of. I don't really see
much difference other than of course when the flag status is updated.
--
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
"deschman" <newsscha@gmail.com>... |
| FilesInUse with Visual Studio deployment project |
Dima Pasko |
3 / 3 |
02 Sep |
| ... |
| Adding the users to distribution list in GAL from Outlook 2007 |
Ken Slovak - [MVP - O... |
2 / 2 |
02 Sep |
| You'd have to use ADSI code to write entries to the GAL, you can't do that
using Outlook object model code. Changing GAL entries or adding to a GAL DL
is a server-side operation.
--
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... |
| Attaching events to the folder in Outlook 2007 |
Sunil |
6 / 6 |
02 Sep |
| Thanks Ken. I will put more thought on this approach. Mean time, the item
add event on the folder gets fired even single item is added in the folder.
I am able to retain the event association to the folder by attaching the
event to the folder in the Item send of the Addin.
Thanks,
Sunil
"Ken Slovak - [MVP - Outlook]" wrote:
> The ItemAdd event will fire unless 16 or more... |
| Macro get name from TO and put in Dear ... |
Mark |
8 / 8 |
01 Sep |
| BTW
I have been playing with this concept and learning a bit of VBA in the
process. I decided to try and include fields to look like a reply email from
Outlook (see code below). All works ok for me, though it is a bit slow
somtimes.
If anybody has any suggestions on how to improve this I'd like to hear from
you.
Mark
Sub Dear()
Dim myItem As Outlook.MailItem
Dim... |
| Business Card. |
Ken Slovak - [MVP - O... |
2 / 2 |
29 Aug |
| MailItem.AddBusinessCard(oContact) is how you use it. You must have a
contact item that you supply to the method and that contact must have a
business card. What you get depends on the BodyFormat of the mail item, as
discussed in the VBA Object Browser help on that method.
--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007.... |