ThreadLast AuthorMessages
read/total
Date
Help with creating multiple new messages using VBA
Michael Bauer [MVP - ...
0 / 2 04 Aug
Have you seen my answer in microsoft.public.outlook.program_vba? -- 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 Mon, 4 Aug 2008 11:50:14 -0700 (PDT) schrieb Thomas.J.Howe@gmail.com: > I was hoping one (or more)...
How to detect who made changes in Calendar?
Ken Slovak - [MVP - O...
0 / 2 04 Aug
To see if there's any software out there that does that look at the Utilities page at www.slipstick.com. To see if there's already a macro like that search at www.outlookcode.com. If you need to code it yourself then it's certainly possible. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007. Reminder Manager, Extended...
Setting Security Features of Outlook (IsTrusted)
Ken Slovak - [MVP - O...
0 / 2 31 Jul
What are the settings on the Macro Security tab? On the Add-ins tab is the checkbox for Apply macro security settings to installed add-ins checked? -- 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 "Don" <someone@somewhere.net>...
Outlook 2003 Appointments -- drag and drop event using C#
Ken Slovak - [MVP - O...
0 / 6 29 Jul
You always have to be more aware of scoping and possible garbage collection in managed code than in unmanaged code. You'd be surprised at how many problems are solved just by thinking about and following scoping rules. Good, I'm glad things are working now. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007. Reminder Manager,...
Out of Memory adding items to listbox from clipboard-pasted textbox
Ken Slovak - [MVP - O...
0 / 2 28 Jul
Do you want the textbox and listbox to retain their contents from run to run? If not have you tried clearing both on the start of each run? Do you know on what line the error is occurring? -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007. Reminder Manager, Extended Reminders, Attachment Options. http://www.slovaktech....
ACREDITE FUNCIONA!!!!!
JET72@BOL.COM.BR
0 / 1 27 Jul
...
Folder Count
Michael Bauer [MVP - ...
0 / 2 24 Jul
Can't you just set the folder to display the number of items? For that right click the folder, then choose properties. -- 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 Thu, 24 Jul 2008 09:01:56 -0700 (PDT) schrieb...
Outlook disables macros
Michael Bauer [MVP - ...
0 / 2 24 Jul
Please click Help/About/Deactivated Items, and see if vba is listed there. -- 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 Thu, 24 Jul 2008 07:34:35 -0700 (PDT) schrieb michael: > Somehow Outlook disabled macros...
From Outlook to Excel using VBA
Ken Slovak - [MVP - O...
0 / 2 23 Jul
Did you bother to look at the answer I posted a few hours ago? -- 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 "HBruno" <hbruno@pcebr.com.br> wrote in message news:eVZ2zcO7IHA.3652@TK2MSFTNGP04.phx.gbl... > Hi, > > I need to...
From Outlook to Excel using VBA
Ken Slovak - [MVP - O...
0 / 2 23 Jul
There are examples of that at www.outlookcode.com. Search there for "Excel". -- 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 "HBruno" <heverardo@gmail.com> wrote in message news:ubYjaxM7IHA.2064@TK2MSFTNGP02.phx.gbl... > Hi, >...
How to eliminate signature from new email
Sue Mosher [MVP-Outlook]
0 / 2 22 Jul
After you create your new message, set its Body or HTMLBody property to some string, even a blank string. That will replace any prior body text. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook Programming: Jumpstart for Administrators, Power Users, and Developers http://www.outlookcode.com/jumpstart.aspx "Lior schwimmer" wrote: > Hi, > > I would like...
Macro to get name from TO and put in Dear ...
Mark
0 / 1 22 Jul
Hi Newbie playing with Outlook VBA. Using Outlook 2007 I'd like to get the name from TO and copy it to the text to end up with Dear .... when I hit a keyboard shortcut For example, say To is John Brown. I'd like to end up with Dear John when I hit a keyboard shortcut Thanks Mark...
define Format-template for Outlook2007 external created Mailobject
Ken Slovak - [MVP - O...
0 / 4 21 Jul
For a macro you could use the Application_Startup() event in the ThisOutlookSession class module to instantiate an Inspectors collection declared WithEvents when Outlook is starting up. That lets you handle the NewInspector() event which fires when a new Inspector is created. An Inspector is used to display open items in Outlook. When you get that Inspector you can then instantiate...
identifying conflicts
TroutUSA
0 / 8 16 Jul
...
disable security warning by accessing different object model
Dmitry Streblechenko
0 / 2 15 Jul
Did you look at http://outlookcode.com/article.aspx?id=52 ? -- Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool - "Jin" <Jin@discussions.microsoft.com> wrote in message news:DF625708-0D89-48C9-90B8-12589527C3A5@microsoft.com... > Hi Sue, > > I have a macro which is in excel to read other users inbox. I am getting > the >...
creating a new form in outlook to send data to sql server from the calendar
iKER-
0 / 1 15 Jul
Hi! We use the outlook calendar to register our work hours in some proyects. We need to create a new event in the calendar witch ask us to send data to sql server. Example: Togay i worked from 9 to 13 in one proyect. I go to outlook and I created a new calendar note from 9 to 13 and i write a proyect name in the subject and save it. how can i send this data to a sql server or...
herrenmode kaufen hamburg herrenbekleidung bestellen duesseldorf herrenmode k...
sdgvfwe@yahoo.is.com
0 / 1 13 Jul
herrenmode kaufen hamburg herrenbekleidung bestellen duesseldorf herrenmode kaufen erfurt jahre herrenbekleidung bestellen herrenmode kaufen 50er + + + +++ MAENNERKLEIDUNG KAUFEN +++ MAENNERKLEIDUNG ONLINE BESTELLEN +++ + http://WWW.MAENNERKLEIDUNG-KAUFEN-24.INFO http://WWW.MAENNERKLEIDUNG-KAUFEN-24.INFO http://WWW.MAENNERKLEIDUNG-KAUFEN-24.INFO http://WWW....
herrenbekleidung bestellen hanau grosse herrenmode kaufen roemische maennerkl...
sdgvfwe@yahoo.is.com
0 / 1 13 Jul
herrenbekleidung bestellen hanau grosse herrenmode kaufen roemische maennerkleidung policke herrenbekleidung bestellen gmbh aktuelle herrenmode kaufen + + + +++ MAENNERKLEIDUNG KAUFEN +++ MAENNERKLEIDUNG ONLINE BESTELLEN +++ + http://WWW.MAENNERKLEIDUNG-KAUFEN-24.INFO http://WWW.MAENNERKLEIDUNG-KAUFEN-24.INFO http://WWW.MAENNERKLEIDUNG-KAUFEN-24.INFO http://WWW....
Editing contacts (created using custom form in Outlook) from OWA
Adi
0 / 5 08 Jul
The question here is regarding editing Contacts from OWA (Exchange 2007) that were created using custom form in Outlook 2003. When such contacts are opened in OWA (Exchange 2007), they appear read-only. Where as with OWA (Exchange 2003), the contacts are opened in the default Contact form and are editable. The contacts were stored in the Mailbox-Contact folder which are accessible...
Cancelling Tasks Write event removes Send button from inspecto
Adi
0 / 5 07 Jul
Could you explain your problem some more? My problem is very specific to Send button getting removed from the Inspector window....
Retrieving an Outlook Folder using only EntryID
Dmitry Streblechenko
2 / 3 01 Jul
If the parent store hasn't been touched in the current session, GetFolderFromID will fail if no store id is specified - MAPI woudl have no clue which provider is responsible for the given fodler entry id - store providers register themselves when loaded. -- Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool - <manojkurien@gmail....
How to get to email from Word
Matt
24 / 24 30 Jun
This works perfect!! Wow, nice job. Searched everywhere for something like this. "Tony Jollans" wrote: > There ought to be a way to use HTMLBody but it isn't entirely > straightforward. > > What you can do is address the Word editor in Outlook 2007 and paste the > selection in. The downside to this is that the OMG gives you a popup but > that probably isn't a big issue in a...
Hate Your Job?
btb.102@ntlworld.com
0 / 1 29 Jun
Do You Hate Your Job? If You Are Like Me And REALLY Hate Your Job, You Can Do What I have Done And Tell All About Your Company At A Great And CHEAP New Site Called Dont Work For These . Com http://www.dontworkforthese.com This Site Has Chat Rooms, A Joke Section, A Great Story Section Where You Can Tell All The Funny Or Stupid Things That Happen Or Have Happened To You During Your...
VB6 code sample for Outlook 2007 table object
Ken Slovak - [MVP - O...
0 / 12 26 Jun
Hi Steve, I have the same problem, I can't get a consistent repro on it. In all my tries I've been able to repro it here only once and it never happened again. I do have customers who seemingly can repro it easily, maybe I'll open an incident and see if I can get it assigned to you or Bill to work on (I don't think front line support would be much help). When I asked Randy about...
Can I tell if an object exists?
Ed
0 / 17 23 Jun
I was back to the drawing board trying to implement the following routine (which I've posted in about in the past): When I select a new email in the explorer: * Check to see if the last one was flagged. If not, Archive it. I need to handle the case where I delete an email and therefore trigger the SelectionChange event. When I delete an email, by the time I get to the...
Need for speed (parsing all contacts)
Mike
3 / 3 19 Jun
"Sue Mosher [MVP-Outlook]" <suemvp@outlookcode.com> wrote: >For read-only access, the Table object delivers performance similar to that of CDO 1.21. Thanks Sue! -mike...
Senior Software Engineer - MAPI (Email Encryption)
breroger@cisco.com
1 / 1 19 Jun
Please contact me if you are interested in the job opening listed below. Regards, Brent breroger@cisco.com Senior Software Engineer - MAPI Job Description: IronPort Systems Email Encryption Group within Cisco is looking for software engineering talent and experience to participate in the ongoing development effort for its Email Encryption Products. The Email Encryption...
Save Attachments to directory based on attachment name
Michael Bauer [MVP - ...
2 / 2 19 Jun
2, 3, 4) You may use the Scripting runtime for that. Click Tools/References and choose the "Microsoft Scripting Runtime". Then open the object browser (f2), switch from <All Libraries> to Scripting, and select FileSystemObject n the left pane, in the right pane you will see all its methods in the right pane. 5) That moves it to the deleted items. 6) If you have the mailbox opened...
Outlook attachments desaperas
Michael Bauer [MVP - ...
0 / 4 16 Jun
Hi Johnny, I don't know if there's a change in the behaviour of a newer version. But obviously, what you see is that the e-mail gets saved with the changes you make. So, one quick workaround might be to create a copy of the e-mail, save it without some attachments as a file, and then delete it from Outlook (if necessary). -- Best regards Michael Bauer - MVP Outlook :...
Copy retained in Sent Items
Ken Slovak - [MVP - O...
1 / 4 12 Jun
Sorry, I missed that objMsg is a CDO.Message and not an Outlook.MailItem. See if saving the Message after adding that property works, before you send it. However, Send(false) does the same thing for you so you can just use that instead. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007. Reminder Manager, Extended Reminders,...
macro needed
Ken Slovak - [MVP - O...
2 / 2 12 Jun
When you click on the item to select it the Explorer.SelectionChange event fires, that's what you need to handle. In that handler you would check to see that the returned Selection collection only has 1 item and then you would get the and check its Class property to make sure it was a mail item. If it is then you can change the MailItem.BodyFormat property to olFormatPlain. --...
Create new macro in outlook
Sue Mosher [MVP-Outlook]
2 / 2 11 Jun
A macro cannot be distributed as an executable. See http://www.outlookcode.com/article.aspx?id=28 To open a browser window with a specific URL, you can use code like this: strURL = <expression to build the URL you want to navigate to> Set objWeb = CreateObject("InternetExplorer.Application") objWeb.Navigate strURL -- Sue Mosher, Outlook MVP Author of Microsoft Outlook...
Group by in VBA
Amiable
5 / 5 10 Jun
Ya thats what I figured but wanted to be sure if there was a better option existed. "Sue Mosher [MVP-Outlook]" <suemvp@outlookcode.com> wrote in message news:eahXCDyyIHA.2068@TK2MSFTNGP05.phx.gbl... If you're searching multiple folders, using Application.AdvancedSearch could be a better approach. The DASL syntax is a little different; see http://www.outlookcode.com/news.aspx?id=30...
Contacts
Sue Mosher [MVP-Outlook]
0 / 4 06 Jun
>> How do you change each item's MessageClass property? Same way you'd change any other property: You either run your own code to return each item, change the property value, and then save the item. Or, you use a utility that does the same thing. See http://www.outlookcode.com/article.aspx?ID=39 for links to code samples and utilities. -- Sue Mosher, Outlook MVP Author of...
Error Images - Dmitry Streblechenko
Dmitry Streblechenko
2 / 2 02 Jun
Could you refresh my memory please? What exactly are you trying to do? I do not see the beginning of the thread. -- Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool - <Ady Zelter> wrote in message news:20086163921zeltera@yahoo.com... > Hi Dimitry, > I saved the mail and I closed the composer window. If I go to Drafts > folder...
vba import from SQL data base to Outlook Calendar
Michael Bauer [MVP - ...
4 / 4 29 May
That's correct. -- 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 Wed, 28 May 2008 23:32:34 -0700 (PDT) schrieb ottk@bellsouth.net: > That looks good.Thanks very much. > > Let me be sure I understand. > > I...
Binding a Form Field to a RecordSource
0 / 2 26 May
Any database aware ActiveX Controls can be used on custom Outlook forms. See: Connecting Outlook to Databases: http://www.outlookcode.com/article.aspx?ID=25 -- Eric Legault [MVP - Outlook] MCDBA, MCTS (Messaging & Collaboration, SharePoint Infrastructure, MOSS 2007 & WSS 3.0 Application Development) Collaborative Innovations -> Try Picture Attachments Wizard For Microsoft...
Opening a parent message
paul.mansfield@boldon...
1 / 7 23 May
In the end I have settled on approaching the problem the other way round by detecting when the parent message is opened and writing into my own property on the attached message the data I require from the parent message such that when the attached message is opened I have what I need. I did not think before that I could do this as when trying to do it from the Object Model events,...
MAPI error in opening outlook
2 / 2 21 May
It sounds like the MSN Connector or Microsoft Office Outlook Connector is installed or was uninstalled, or the delivery location was changed from or to the Hotmail/Office Live Mail folders. If you are using the connector, reinstall or reconfigure your connection. If not, uninstall it. BTW - this forum is for programming questions only. -- Eric Legault [MVP - Outlook] MCDBA,...
dublicate outlook email
Ken Slovak - [MVP - O...
0 / 2 19 May
Define duplicate. Same subject, body, what, received time, sent time, what? -- 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 "Marcel" <muesahib@gmx.net> wrote in message news:67ff9c9b-8945-4b9e-a0fd-852c5aa3a4df@8g2000hse....
need macro to print 2 copies and send an open message
Sue Mosher [MVP-Outlook]
1 / 2 14 May
Sub PrintMeTwice() Dim msg as Outlook.MailItem On Error Resume Next Set msg = Application.ActiveInspector.CurrentItem msg.PrintOut msg.PrintOut msg.Send End Sub -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "rr"...
Newbie question
Ken Slovak - [MVP - O...
1 / 2 13 May
If the message is HTML you can read the HTMLBody property of the item and use HTML tags to add or change whatever colors you want. You'd have to parse the HTML and find the URL and use or find the <div> or <span> tags that surround the URL and then include or change font and color information. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming...
New Bee: How to add custom menu in outlook message
Ken Slovak - [MVP - O...
2 / 2 12 May
The mail item will be open in an Inspector. Each Inspector in Outlook 2003 will have a CommandBars collection, which includes a CommandBar named "Menu Bar". Under that CommandBar is a CommandBarPopup named File. You add your control to the File CommandBarPopup.CommandBar object. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007....
Adding Modifying Contacts in "Other Contacts" (Shared Contacts)
Sue Mosher [MVP-Outlook]
0 / 6 12 May
If you're building an add-in for Outlook 2003 or 2007, you can also use Outlook objects without triggering security prompts. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Jimmy Jam" <jj@yahoo.com> wrote in message news:%23Vr2DC9sIHA.548@TK2MSFTNGP06.phx....
Response from Outlook dialog box.
Ken Slovak - [MVP - O...
0 / 2 12 May
Please don't multipost. See the answer in the other group you posted in. -- 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 "Adi" <adityajain_bit@indiatimes.com> wrote in message...
defend against Operation Sudden Fall
Dilbert.Ochakovsky@de...
1 / 1 09 May
Law enforcement is now intercepting text messages, as proven by Operation Sudden Fall in San Diego. http://www.usdoj.gov/dea/pubs/states/newsrel/sd050608.html http://www.signonsandiego.com/news/education/20080506-1338-bn06sdsu2.html Don't let your personal SMS/text messages fall into the wrong hands. Encrypt your messages with one of these: http://www.CryptoSMS.org...
From Outlook open a Excel-file, but how can i set focus to Excel?
Ken Slovak - [MVP - O...
1 / 2 09 May
Get the workbook as a Workbook object and call its Activate() method. -- 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 "ExcelLars" <lars.oyangen@hamstad.no> wrote in message news:e632e00e-4371-4f1e-9e8d-64338ed1799d@m44g2000hsc....
task overdue event?
Michael Bauer [MVP - ...
4 / 4 07 May
You can receive Item_PropertyChange only if you have an object variable set to that item. But as I understand you know you won't receive any events. Item_PropertyChange or ItemChange fire if a property of an item has been changed. In your case not an item property changes but the system time. So, what you have to do is write a code that runs once a day and checks all the tasks...
contact list vba
Ken Slovak - [MVP - O...
1 / 2 06 May
Is this a custom Outlook form? You would use the forms designer and add a listbox. To populate it you would get one of the NameSpace.AddressLists as an AddressList, get the AddressList.AddressEntries collection and iterate that collection. You would then use each AddressEntry.Name to fill your list. If you wanted more than 1 AddressList if there is more than 1, you'd iterate the...
Adding Shortcut, Receive: Run-time error '-2147467259 (80004005)'
bryan.powell2@gmail.com
3 / 3 06 May
It looks like DoEvents did it. Thanks!...
All times are in (US) Eastern Daylight Time (GMT -4:00)