ThreadLast AuthorMessages
read/total
Date
E-mail are Unreadable Format
Dmitry Streblechenko
2 / 2 06 Oct
Tell the sender to use software that does not send malformed messages? There should be a tab/space before the "boundary" line. -- Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool - "Bala Krishna" <Bala Krishna@discussions.microsoft.com> wrote in message news:5E1630F2-A159-4ABC-A5C0-E55399FC5EC9@microsoft.com... > One of The User...
Outlook vba errror message says Access can't find my userform
MarceepooNu
3 / 3 06 Oct
It occurred to me that I should mention that I am not using Access; so I don't understand why I'm getting the error message refers to Access. -- MarceepooNu "MarceepooNu" wrote: > I'm trying to create a userform in Outlook 2003 vba, that will facilitate a > secretary creating an email message about telephone calls. > > I get the following error message: Microsoft Office...
Refering to a folder
Bre-x
3 / 3 06 Oct
Thanks, it works fine. now, if you dont mind, how to add and Item? thnks "Sue Mosher [MVP-Outlook]" <suemvp@outlookcode.com> wrote in message news:4207ACCA-B65B-4F19-9A26-A875A1E04AAC@microsoft.com... > Use the GetDefaultFolder method and Parent and Folders properties to walk > up > and down the folder hierarchy, e.g.: > > Set inbox = Application.Session....
outlook 2007 warning message when emailing from Access
Sue Mosher [MVP-Outlook]
3 / 3 06 Oct
In Outlook, look in Tools | Trust Center | Programmatic Access. Is the antivirus status listed as "Valid," and are the three warning option controls enabled? If so, then you don't need Redemption to avoid security prompts. Instead, you can just use Outlook automation (e.g the Application.CreateItem method from the Outlook object model) to create an send a new message. I don't know...
Outlook macro return Runtime error : operation failed for mail
Shiv
4 / 4 06 Oct
@Michael The problem persists even with a folder ex: "test" @GP Yes .. the item may not be a mail item.. but the error is same even if it is... I use watch to see what is happen with the objects... i found all folders within inbox return "Operation Failed " for all properties in the Object Ex : ObjFolder => "Inbox" Folders=>Item(1)=> "operation failed" this is same for all...
Macro to rename Subject of E-mail on exchange server(2007)
JP
5 / 5 05 Oct
...
drag and drop
Michael Bauer [MVP - ...
2 / 2 04 Oct
You can't do that with Outlook. -- Best regards Michael Bauer - MVP Outlook : VBOffice Reporter for Data Analysis & Reporting : Outlook Categories? Category Manager Is Your Tool : <http://www.vboffice.net/product.html?pub=6&lang=en> Am Fri, 3 Oct 2008 15:53:12 -0700 schrieb Joel Allen: > Outlook 2003 SP3 > > Hi, > > I want to drag and drop a file into the...
Is this possible?Shared calendar reminders between 3 people &remin
Mitch
2 / 2 03 Oct
I found this bit of code. I assume if I replaced Public Folder path with say. Calendar/Shared It would load the secondary Shared Calendar (I made a second calendar for these reminders specifically) ' GetFolder - Gets a Public folder based on a string path - e.g. 'If Folder name in English is 'Public Folders\All Public Folders\Europeen Workflow 'The just pass in "Europeen...
Help with OL07 macro to fix invalid entryid
Ken Slovak - [MVP - O...
5 / 5 03 Oct
If you declare "item As ContactItem" you shouldn't use it in the For loop. I'd declare something like "Obj As Object" and use that in the loop, then test it for Class before assigning it to the item object. I doubt you reached the end, a For Each item In Contacts.Items would quit when there were no more items. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author:...
Newbie- is this possible? (code to save attachments from serve
GP
4 / 4 03 Oct
VBA is a macro language for applications, in other works an application that supports VBA needs to be running (typically Word, Excel, Outlook, etc). You can't run a client side VBA macro if the PC is turned off. Even with a shared mailbox, at least one user with access to the mailbox needs be be logged on to run a VBA macro. I'm sure other programming languages can get arund this, e.g....
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...
get the clipboard value into a vba string
oldyork90
5 / 5 02 Oct
...
Outlook integration with custom .Net application?
Ken Slovak - [MVP - O...
11 / 11 02 Oct
See if the information in Misha Shneerson's blog (he's a member of the VSTO team) at http://blogs.msdn.com/mshneer/archive/2007/09/04/deploying-your-vsto-add-in-to-all-users-part-i.aspx helps with deploying for all users. If Add-In Express is involved you might also want to contact them or review their FAQ's or KB articles to see if they have any information. -- Ken Slovak [MVP...
Change the Default Message Format for Outlook Application via Inte
Ken Slovak - [MVP - O...
2 / 2 02 Oct
That value is set in the registry at HKCU\Software\Microsoft\Office\xx.0\Outlook\Options\Mail\EditorPreference as a DWORD. The exact path depends on the version of Outlook. for 2002 it would be 10.0, for 2003 it would be 11.0 and for 2007 it would be 12.0. The value you set there would depend on whether or not WordMail is being used and also if it's Outlook 2007. Since you don't...
Redemption and Outlook 2007
MA
9 / 9 01 Oct
Thanks, email sent. Looking forward to receive your response. Regards, MA...
change outlook calendar folder name
MiataMX5
3 / 3 01 Oct
"MiataMX5" wrote: > what VBA do I use to change a folder name many thanks...
VBA toggle Outlook '03 Word email editor on/off
Eric Legault [MVP - O...
6 / 6 01 Oct
The problem is the "IsWordEditor" method you're calling - there's no such thing! Also, call ActiveInspector as below, and *after* the e-mail is displayed: Set OutlookApp = CreateObject("Outlook.Application") Set MItem = OutlookApp.CreateItem(olMailItem) With mItem .display 'creates a blank email Set TestOutlookEditor = Application.ActiveInspector If TestOutlookEditor....
Do Loop to build Dynamic Table and insert into HTML body
Michael Bauer [MVP - ...
2 / 2 01 Oct
You may use the Offset function in Excel. Set a Range variable to the upper left cell you want to start with, e.g.: Set rn=Cells("a1") Now do the loop, and for a new row call: Set rn=rn.Offset(1,0) For every column use a For Next loop, and write the value of column 1 to rn.Value, the second to rn.Offset(0,col).Value, etc. That works but is pretty slowly. A lot faster...
Set Send Receive Setting using code or PRF
Dmitry Streblechenko
4 / 4 30 Sep
See http://technet.microsoft.com/en-us/library/cc178987.aspx and http://office.microsoft.com/en-us/ork2003/HA011402661033.aspx -- Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool - "Skylark_28" <Skylark28@discussions.microsoft.com> wrote in message news:0537A8E3-A0F0-45A4-9A59-62FC98C93A9D@microsoft.com... > oops - yeah that...
how to stop emails from being sent in outlook via code
Greg J
3 / 3 29 Sep
...
Outlook 2003 - Turn E-mail into SharePoint Task
Jonathan Gibson
1 / 1 29 Sep
In Outlook 2007 I followed guidance on creating a script that can through a rule processing incoming mail that takes a message, creates a Task Item and drops it into a folder that is syncronized with SharePoint. I now need to get something setup for Outlook 2003 users. I was thinking about trying to use the web service exposed by SP but I'm not sure how I would handle the attachments....
Good links for learning vba for MS outlook
Boss
4 / 4 29 Sep
Thank-you all...!! Boss "JP" wrote: > I have some sample code here: > > http://www.codeforexcelandoutlook.com > > And there is some good sample code here as well: > > http://www.rondebruin.nl/sendmail.htm > > HTH, > JP > > > On Sep 29, 8:26 am, Boss <B...@discussions.microsoft.com> wrote: > > Hi, > > > > With the help of this forum i can now do good coding in excel...
save attachments
Ken Slovak - [MVP - O...
2 / 2 29 Sep
The following code link shows how to strip attachments from selected items: http://www.slovaktech.com/code_samples.htm#StripAttachments. It could be modified to check for a sender address and to then remove the PDF's. For handling incoming messages, the other part of what you want, search on ZapHTML at www.outlookcode.com to see how to handle incoming messages. -- Ken Slovak [MVP...
Can outlook design a e.g. tasks approval process by using VBA alon
Ken Slovak - [MVP - O...
2 / 2 29 Sep
It can be done with VBA code, but deploying VBA code to other machines is not recommended as a deployment method. The best way to deploy code like that is to use an Outlook COM addin. An alternative would be to use a custom form for the workflow. Check out www.outlookcode.com, where you can find examples of routed forms that can be used for workflow and also examples and information...
Get the date and time when a contact have been added in Outlook
Ken Slovak - [MVP - O...
2 / 2 29 Sep
You can use the CreationTime property of an item to see when it was created and the LastModificationTime to see when it was last modified. -- 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 "José" <jose@discussions.microsoft.com.>...
Retrieve document variable from attached Word document
Michael Bauer [MVP - ...
2 / 2 29 Sep
All of the attachments are in Attachments collection of the MailItem object. -- Best regards Michael Bauer - MVP Outlook : VBOffice Reporter for Data Analysis & Reporting : Outlook Categories? Category Manager Is Your Tool : <http://www.vboffice.net/product.html?pub=6&lang=en> Am Sun, 28 Sep 2008 13:02:44 +0200 schrieb Gordon Filby: > Hallo, > > I receive mails...
How to programatically open Outlook folder list
NicMic
9 / 9 29 Sep
Sorry - should have guessed that one! Thanks again, Nick. "Dmitry Streblechenko" wrote: > It is Outlook.MAPIFolder > > -- > Dmitry Streblechenko (MVP) > http://www.dimastr.com/ > OutlookSpy - Outlook, CDO > and MAPI Developer Tool > - > "NicMic" <NicMic@discussions.microsoft.com> wrote in message > news:D96D9137-DB70-4CCF-8DDB-11267DAED1F9@microsoft.com... > > Thanks...
kredite ohne schufa auskunft Guenstige Kredide online ohne SCHUFA kredite sc...
sdgvfwe@yahoo.is.com
1 / 1 28 Sep
kredite ohne schufa auskunft Guenstige Kredide online ohne SCHUFA kredite schweiz sofortkredit online online credit ohne schufa + + +++ GUENSTIGE KREDITE ONLINE +++ KREDITE IM INTERNET OHNE SCHUFA +++ + http://jhku.net/KREDITE-ONLINE-24/ http://jhku.net/KREDITE-ONLINE-24/ http://jhku.net/KREDITE-ONLINE-24/ http://jhku.net/KREDITE-ONLINE-24/ http://jhku....
Clean Free Busy Programmatically ?
Dan Mitchell
8 / 8 26 Sep
"Ken Slovak - [MVP - Outlook]" <kenslovak@mvps.org> wrote in news:#jePbJAIJHA.728@TK2MSFTNGP03.phx.gbl: > That looks like some of Siggi's EX 5.5 code. and that should give you some idea of how long I've had that saved away for.. I _really_ must sort through my big heap of old code snippets one of these days. > There is no FreeBusy folder at all under IPM_ROOT with cached mode, >...
Auto-reply confirmation email
Sue Mosher [MVP-Outlook]
4 / 4 26 Sep
What can you learn from looking at the contents of rply.Recipients? What happens when you run this procedure from a macro, passing it a received message as an argument? -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Chad" wrote: > Sue, thanks. >...
Refresh outlook folders after mailAdd event fires
MooseMan
5 / 5 26 Sep
Ken, tks for the input. By 'main form; I meant the current folder. I am processing events from the inbox folder. To solve the problem I performed the following code: Outlook.Application oApp; oApp= mapiNamespace.Application; Outlook.Explorer exp = oApp.ActiveExplorer(); //get ActiveExplorer exp.CurrentFolder =...
Move Message Attachments to Inbox
R Tanner
1 / 1 26 Sep
Hi, I have about 500 emails that have been forwarded to me. I need to move the message attachment into my inbox and do away with the forwarded portion. How would I do this? Thanks in advance....
event after marking a mail with a colorflag?
Ken Slovak - [MVP - O...
2 / 2 26 Sep
The item.PropertyChange() event will fire a few times after you set a flag on an item. You can check for the Name string property passed to PropertyChange() and if it's FlagStatus or FlagRequest you know that a flag property was changed. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007. Reminder Manager, Extended Reminders,...
Send Meeting Appointment as someone' else
Send Meeting Appointm...
1 / 1 25 Sep
Hi I want to create an meeting appointment on behalf of someone else using VBA. Seems I cannot change the organizer, and I tried logon as someone else, it still recognize as me. How can I do that?...
SharePoint Considerations
Tadwick
1 / 1 25 Sep
I want to write a method that reads SharePoint calendar items from Outlook. What are the considerations and limitations of OL2003, OL2007 and their object models? Tx...
Cycling through every Email in a Folder and Appending data To a Text File
R Tanner
3 / 3 25 Sep
...
How do you run a function in Outlook?
Ken Slovak - [MVP - O...
2 / 2 25 Sep
What VB? Is this Outlook VBA code? A function is called from some other place in your code. If the function call takes arguments then it's your responsibility to provide the data the function requires when you call it. That's about all anyone can say with the information provided. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook...
Excel as a data source for Outlook to email Word docs
Doug Robbins - Word MVP
4 / 4 25 Sep
The problem is arising because the reference to the Outlook Object Library is not being retained. I would suggest that you place the macro in the Normal.Dot template or in another template that you save in the Word\Startup folder so that it is available to any document that you create. -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my...
Problem automating Outlook 2007 in VB6
Ken Slovak - [MVP - O...
4 / 4 24 Sep
Standalone code then, not Outlook VBA or an addin. You could now go back to using late bound Objects if you wanted with .Logon being used, although early bound objects provide intellisense and are faster. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007. Reminder Manager, Extended Reminders, Attachment Options. http://www....
Add text to body
Michael Bauer [MVP - ...
4 / 4 24 Sep
If you use Word as email editor, you may use the Word object model for that. In that case the Application.ActiveInspector.WordEditor property returns a Word.Document object. If you don't, then use Redemption from www.dimastr.com, the site also has examples for how to use the SafeInspector.PlainTextEditor. -- Best regards Michael Bauer - MVP Outlook : VBOffice Reporter for...
Outlook 2007 VBA and Dumping emails into a CSV File
Eduardo
5 / 5 24 Sep
Hi, there! I have a similar problem, where I have an email message sent by our webform, which body content has to be parsed into an Excel file. I'm not familar with VBA, so I've copied and pasted the code below into my Outlook VBA and tried to run, but first of all, it gives me an error message at line "arrData(i, 1) = .Sensitivity". Would anybody have any clue about why it is...
Application_Startup event not always firing
Patrick Philippot
1 / 1 24 Sep
Hi, I have this problem on multiple systems having different configurations and running Outlook 2007. The Application_Startup event doesn't *always* fire. I couldn't find any pattern until now. However, it seems that most often, the event fails to fire when I launch Outlook very early after logging in when the system is still busily launching other programs or services. This is...
Outlook and SMS/MMS
Sue Mosher [MVP-Outlook]
2 / 2 24 Sep
Microsoft already offers this capability in Outlook 2007, and there apparently are two Outlook 2007 Mobile Service providers that work with Telis. See http://office.microsoft.com/en-us/outlook/HA101549971033.aspx and http://messaging.office.microsoft.com/HostingProviders.aspx -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users...
How do conflict Item appear in Recordset of mapitable query ?
Dmitry Streblechenko
2 / 2 23 Sep
On which folder? Does the message have the PR_CONFLICT_ITEMS property set? -- Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool - "Bert_Bert" <BertBert@discussions.microsoft.com> wrote in message news:6D946ECD-CF49-4304-86A1-E8823E3A3358@microsoft.com... > Does anyone know what happens if there is a conflict on item. > Does it...
Trying to loop through RDOFolders Recursively
Dmitry Streblechenko
4 / 4 23 Sep
Have you tried to call GetAddresses without parenthesis? GetAddresses rfolder -- Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool - "Bill Benson" <BillBenson@discussions.microsoft.com> wrote in message news:BE992320-97A2-49EC-9B66-779AD4215A16@microsoft.com... > Hi Dmitry, thanks but I tried that already and the problem is, if...
Write to Appointment headers??
Ken Slovak - [MVP - O...
2 / 2 23 Sep
The InfoBar is not exposed to your code. You can however modify the Caption property of the Inspector to include "read-only" or whatever. -- 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 "Jim Leach" <JimLeach@discussions....
Running a Macro when email arrives
Irwin Quintana
1 / 1 23 Sep
Great code, you save me from hours of work! Regards from Mexico....
creating Function Macro
laitkens
6 / 6 23 Sep
Thank you very much. He opted for the signature. "Sue Mosher [MVP-Outlook]" wrote: > The reason I recommend Redemption is that with the Outlook object model > itself, it is possible to insert text only for messages in HTML format, using > the HTMLDocument object returned by Inspector.HTMLEditor. SafeInspector, on > the other hand, can handle also RTF and plain text message bodies....
webbrowser
Ken Slovak - [MVP - O...
4 / 4 23 Sep
I'm not sure what forum would handle this, but it's definitely not an Outlook question. You would use the LocationURL or LocationName properties, both are listed in the Object Browser for SHDocVw, the web browser reference. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007. Reminder Manager, Extended Reminders, Attachment...
How To Offset a specific Number of Rows in a Text File
GP
2 / 2 23 Sep
I wouldn't use the "Open File For" method. If you add a reference to Microsoft Scripting Runtime (Tools, References) you get access to the TextStream object. You can use it like this: Dim myFileSytem as Scripting.FileSystemObject Dim myStream as TextStream Dim myLine as String Set myFileSytem = CreateObject("Scripting.FileSystemObject") Set myStream = myFileSytem....
All times are in (US) Eastern Daylight Time (GMT -4:00)