| Thread | Last Author | Messages
read/total | Date |
|---|
| Can I tell if an object exists? |
Ed |
17 / 17 |
23 Jun 2008 |
| 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 2008 |
| "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 2008 |
| 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 2008 |
| 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 - ... |
4 / 4 |
16 Jun 2008 |
| 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... |
4 / 4 |
12 Jun 2008 |
| 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 2008 |
| 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 2008 |
| 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 2008 |
| 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] |
4 / 4 |
06 Jun 2008 |
| >> 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 2008 |
| 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 2008 |
| 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 |
|
2 / 2 |
26 May 2008 |
| 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... |
7 / 7 |
23 May 2008 |
| 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 2008 |
| 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... |
2 / 2 |
19 May 2008 |
| 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 2008 |
| 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... |
2 / 2 |
13 May 2008 |
| 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 2008 |
| 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] |
3 / 6 |
12 May 2008 |
| 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... |
2 / 2 |
12 May 2008 |
| 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 2008 |
| 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... |
2 / 2 |
09 May 2008 |
| 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 2008 |
| 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... |
2 / 2 |
06 May 2008 |
| 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 2008 |
| It looks like DoEvents did it. Thanks!... |
| Changing the sender's email address |
|
2 / 2 |
29 Apr 2008 |
| You can use the SentOnBehalfOfName property. See:
OL2000: How to Programmatically Set a Form's From Field:
http://support.microsoft.com/?kbid=232309
--
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 Outlook <-... |
| Changing the Outlook "from" address using VBA |
Tony Jollans |
3 / 3 |
27 Apr 2008 |
| In earlier versions it is more awkward but in 2007 you can use the
SendUsingAccount property of the MailItem.
--
Enjoy,
Tony
"lookatmypie" <lookatmypie@discussions.microsoft.com> wrote in message
news:13C26A28-BE68-43D8-A721-F0037F0863C0@microsoft.com...
>I am developing an application in access 2007. The app needs to send emails
> to customers but the account from which the... |
| Items.Find parameters |
Sue Mosher [MVP-Outlook] |
2 / 2 |
23 Apr 2008 |
| See http://outlookcode.org/article.aspx?id=30 for details on conducting date searches.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54
"Taxidev" <Taxidev@discussions.microsoft.com> wrote in message news:15181537-63EB-4A73-993B-0F237AD1DFC8@microsoft.com..... |
| How do I select a specific folder in Outlook? |
Sue Mosher [MVP-Outlook] |
2 / 2 |
23 Apr 2008 |
| To get a non-default folder, you need to walk the folder hierarchy using the Folders collections or use a function that does that for you. For examples, see:
http://www.outlookcode.com/d/code/getfolder.htm - uses a folder path string
http://www.outlookcode.com/codedetail.aspx?id=492 - searches for a folder by name
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007... |
| How do I create a contact using VB? |
Dmitry Streblechenko |
2 / 2 |
22 Apr 2008 |
| set Items = Application.GetDefaultFolder(olFolderContacts).Items
...
set Contact = Items.Add
Contact.Email1Address = "user@domain.com"
Contact.FirstName = "First"
Contact.LastName = "Last"
Contact.Save
--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-
"duckofprey" <duckofprey@discussions.microsoft.com> wrote in message... |
| Visibility of Items or Folders |
GP |
3 / 3 |
22 Apr 2008 |
| Right on the button as usual Sue, thank you very much!
GP... |
| Moving items in VBA |
Ken Slovak - [MVP - O... |
2 / 2 |
21 Apr 2008 |
| Set up an ItemAdd handler for the Inbox and if the incoming message meets
your criteria move it to the EXTRACT folder (or directly process the item
from the Inbox folder).
--
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... |
| Copy an Outlook Email through Access |
Sue Mosher [MVP-Outlook] |
4 / 4 |
18 Apr 2008 |
| So you've changed the project so that you want it to act on the currently open Outlook message, not one that the user would select from the Access form? In that case, it's much easier:
On Error Resume Next
Set objOL = CreateObject("Outlook.Application")
Set objItem = objOL.ActiveInspector.CurrentItem
If Not objItem Is Nothing Then
objItem.Save <path>, <type>... |
| How to Insert a Signature file at the end of e-mail |
Sue Mosher [MVP-Outlook] |
2 / 2 |
17 Apr 2008 |
| These samples probably will need some tweaking for your specific scenario, but they demonstrate the basics of inserting a pre-defined signature.
Start a new custom form message with the default signature: http://www.outlookcode.com/codedetail.aspx?id=162
Outlook 2003: http://www.outlookcode.com/codedetail.aspx?id=615
Outlook 2007: http://www.outlookcode.com/codedetail.aspx?id=1743... |
| Vba coding with Outlook |
JP |
6 / 6 |
16 Apr 2008 |
| ... |
| Accessing Text files stored in Outlook Folder |
GP |
3 / 3 |
14 Apr 2008 |
| Thanks Sue, that is perfectly clear. I'll add a KILL statement to delete the
stored copy after I've read it.... |
| need read recipience addresses from selected mail item |
Sue Mosher [MVP-Outlook] |
2 / 2 |
14 Apr 2008 |
| I posted a code sample earlier today at http://www.outlookcode.com/threads.aspx?forumid=2&messageid=26381 for reading all the items in the Inbox. IF you want just selected items, then you'd iterate Application.ActiveExplorer.Selection, not the Items collection for the Inbox folder.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users... |
| Create Link in E-mail that opens an Access database |
Ken Slovak - [MVP - O... |
2 / 2 |
14 Apr 2008 |
| I don't know if there's any way to open an Access database using a link in
an email. Someone in an Access forum might know if that's possible at all.
--
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
"Eka1618" <Eka1618@discussions.... |
| Reading Outlook address book in MS Access VBA code |
Sue Mosher [MVP-Outlook] |
3 / 3 |
11 Apr 2008 |
| > Do I understand correctly that since I am using Access instead of Outlook,
> there is no way to rearrange the VB code to eliminate this warning?
Yes, that is correct for versions before Outlook 2007. You would need to recode using the Redemption library (highly recommended) or use one of the utilities that bypasses the prompts.
Since you are using public folders, you could also... |
| Problem reading e-mail from exchange 2003 programmatically |
Dmitry Streblechenko |
10 / 10 |
11 Apr 2008 |
| Is you app running under the same Windows user identity as the owner of the
mailbox specified in te hcall to Session.Logon?
--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-
"Andre Calanas" <Andre Calanas@discussions.microsoft.com> wrote in message
news:6CFACD41-E621-4B60-8AA8-88169FF356C2@microsoft.com...
> I've had this... |
| ThisOutlookSession code disappears |
Mark VII |
2 / 3 |
10 Apr 2008 |
| Arrgh....
Fortunately, most of my code is in my post about the debugger problem, and I
need to do some rewriting anyway to implement your suggestions.
Thanks Sue...... |
| looping through inbox messages / debugger under Outlook VBA |
Mark VII |
8 / 8 |
10 Apr 2008 |
| Sue --
Thanks a million for the suggestions. I'll check them out..
Mark... |
| FaceID Button Icons and PR_ICON_INDEX MAPI Icons Interchangeable ? |
Ken Slovak - [MVP - O... |
2 / 2 |
10 Apr 2008 |
| Inspectors in Outlook 2007 certainly do use the Ribbon.
The indexes for PR_ICON_INDEX are hard coded and you couldn't just use
FaceID images. You'd have to extract the images or create your own, they
must be in certain formats for the large and small icons. Look at the ones
used by Outlook now in the \Program Files\Microsoft
Office\Office12\Forms\1033 folder. Office12 is for Outlook... |
| Outlook and Timesheet Submittal - Critique |
Greg Wilson |
1 / 1 |
09 Apr 2008 |
| Background:
We are trying to automate timesheet submittal and ultimately automatic
export to Quickbooks via a third party utility. I have developed an Excel
timesheet program that enables submittal to an interim text file database.
This works fine. However, we have many field staff that don’t have computers
allocated to them. There will be a huge bottleneck on Monday morning when... |
| Retrieving occurrences of recurring appts within a given time |
vince |
0 / 3 |
09 Apr 2008 |
| Thanks!
"Sue Mosher [MVP-Outlook]" wrote:
> The article at http://www.outlookcode.com/article.aspx?id=30 explains how to search over a date range and get only the occurrences in that range.
>
> --
> Sue Mosher, Outlook MVP
> Author of Microsoft Outlook 2007 Programming:
> Jumpstart for Power Users and Administrators
> http://www.outlookcode.com/article.aspx?id=54
>... |
| Open Access and Click Button with Outlook Code |
Ken Slovak - [MVP - O... |
0 / 4 |
08 Apr 2008 |
| An Access custom form? Again, post in an Access group. I doubt many people
here would know about that sort of thing.
--
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
"Billy Rogers" <BillyRogers@discussions.microsoft.com> wrote in... |
| TaskItem.Write Event not cancelling as expected |
Ken Slovak - [MVP - O... |
0 / 6 |
08 Apr 2008 |
| I don't think you can change the behavior you are seeing, it's related to
how Outlook caches open items I'd think. It's similar to how if you change a
property on an item in code and commit that property you don't see the
updated view of the property in a folder view until you leave the folder and
then return to it. You'd have to live with the misleading display or find
some... |
| 218 bloqueador veicular sem mensalidades -http://bloqueadorgsm.vilabol.uol.co... |
bloqueador sem mensal... |
0 / 1 |
04 Apr 2008 |
| ... |
| Create Account and Change Settings on VBA |
Dmitry Streblechenko |
0 / 2 |
03 Apr 2008 |
| Outlook 2007: Namespaec.Accounts
Redemption : RDOsession.Accounts (Outlook 2002 and up)
Extended MAPI (C++/Delphi): IOlkAccountManager interface (Outlook 2002 and
up)
Neither will let you create new accounts: MS has never documented the
relevant parts.
--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-
"ManuPR"... |