| Thread | Last Author | Messages
read/total | Date |
|---|
| 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] |
4 / 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... |
1 / 1 |
04 Apr 2008 |
| ... |
| Create Account and Change Settings on VBA |
Dmitry Streblechenko |
2 / 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"... |
| Access to the Outlook address book |
Dmitry Streblechenko |
3 / 3 |
02 Apr 2008 |
| Outlook 2007 - use Namespace.GetSelectNamesDialog
Older version of Outlook - either costruct your own UI or use CDO 1.21
(Session.ShowAddressBook) or <plug> use Redemption (all versions of
Outlook - use RDOSession.AddressBook.ShowAddressBook) </plug>
--
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
-
"Aussie Developer"... |
| Folder Size Query |
Ken Slovak - [MVP - O... |
2 / 2 |
02 Apr 2008 |
| You more or less have to go through each item in each folder and add up
their sizes and that's an approximation of the overall size. It doesn't
include hidden items and other data that usually increase the size by about
10% or so.
--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007
Reminder Manager, Extended Reminders, Attachment... |
| hyperlink in body of appointment/event item |
Sue Mosher [MVP-Outlook] |
2 / 2 |
31 Mar 2008 |
| Because all Outlook 2007 items other than sticky notes use Word as the editor, you can use Word objects to insert a hyperlink. See http://www.outlookcode.com/codedetail.aspx?id=1726 for a VBA code sample that you should be able to adapt to VBScript.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators... |
| the received date changes when I use VBA move in outlook |
btaster7@gmail.com |
4 / 4 |
31 Mar 2008 |
| ... |
| Redemption RDO ICS SyncItems SQLRestriction |
Dmitry Streblechenko |
2 / 2 |
30 Mar 2008 |
| strSQLRestriction = "MessageClass = 'IPM.Note' "
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
"Ian-" <ian.bugeja@gmail.com> wrote in message
news:3436ac8d-a528-423c-904d-9cb6aeffbabe@n58g2000hsf.googlegroups.com...
>I am using Redemption to get the list of emails in a folder on
> Exchange Server. For this i'm using ICS
>
>... |
| Redemption SafeMailItem Sender Is Null |
Sue Mosher [MVP-Outlook] |
8 / 8 |
29 Mar 2008 |
| First, you can add other Exchange mailboxes to your profile by using the Advanced tab on the Exchange account's properties dialog.
However, you don't need to add an Exchange account to your profile in order to send from it. Assuming you have the appropriate permission on the account, all you have to do is put the account alias in the SentOnBehalfOfName property.
--
Sue Mosher, Outlook... |
| Newbie:Another post about moving emails |
HammerJoe@gmail.com |
26 / 26 |
29 Mar 2008 |
| JP, thank you very much for your help.
It is very much appreciated.
Thereason why I used twice to set the folder was just a lazy way of
mine to verify that the folder existed and make sure that the objected
pointed to it correctly by ignoring the error that VBA will
generate. :)
So in two lines I am doing the same as your code in five lines.
It's not pretty but it works. :)
As for... |
| Task Creation Events in Outlook 2007? |
Ken Slovak - [MVP - O... |
1 / 1 |
24 Mar 2008 |
| The best you can probably do is to use the Items.ItemAdd event for the
folder or folders of interest. You will have to set up an ItemAdd handler
for every Items collection you are interested in.
--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.... |
| Conditionally Change Default Form? |
Kevin07003 |
3 / 3 |
19 Mar 2008 |
| Thanks Ken. I haven't used regions yet - I'll explore that.
Kevin
"Ken Slovak - [MVP - Outlook]" wrote:
> You can use code in the form or in a COM addin or in Outlook VBA to change
> the MessageClass of those items to your custom MessageClass, assuming your
> custom form is published.
>
> For viewing in the preview pane (reading pane) a custom form usually won't
> display... |
| Still having issues with the SelectionChange event.... |
Ken Slovak - [MVP - O... |
2 / 2 |
19 Mar 2008 |
| As you've no doubt guessed by now there is no such event. Only the
workarounds presented in your earlier thread are possible.
--
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
<elandau1@gmail.com> wrote in message... |
| Using MSXML2.XMLHTTP in VBA? |
Kevin07003 |
3 / 3 |
18 Mar 2008 |
| Thanks - that was part of the problem. I haven't used VBA since 1998 or so!
Here is the working code that also parses the XML Response:
Private Sub TestXMLHTTP()
Dim strURL As String
Dim oReq As Object
Set oReq = CreateObject("MSXML2.XMLHTTP")
Dim oDOM As Object
Set oDOM = CreateObject("MSXML2.DOMDocument.3.0")
oDOM.async = "false"
Dim oNodeList As... |
| Can I assign Alt-UpArrow as a shortcut key to a macro? |
elandau1@gmail.com |
3 / 3 |
16 Mar 2008 |
| Thanks again Sue.
-Ed... |
| CreateObject("Outlook.Application") failing to get outlook |
Ken Slovak - [MVP - O... |
2 / 2 |
14 Mar 2008 |
| One thing that can cause that, assuming Outlook is installed and registered
correctly is a script stopper. Some A-V software or software firewalls have
script stoppers that prevent CreateObject() and/or GetObject() from working.
It shouldn't be related to whether or not Outlook is the default mail
handler, that doesn't have anything to do with CreateObject().
There have been some... |
| Response Status for each member in a DL? |
melon |
1 / 1 |
13 Mar 2008 |
| Suppose I have a MeetingItem. MeetingItem.Recipients contains 1
member, and it is a DL.
I can extract individual members of the DL using AddressEntry.Member.
However, AddressEntry does not contain MeetingResponseStatus.
Is it possible to obtain the MeetingResponseStatus for each recipient
in the DL? Do I need to do something like
1) Extract AddressEntry from the DL.
2) Add all... |
| Adding Contact to shared Contacts with Redemption |
McKilty |
12 / 12 |
13 Mar 2008 |
| On Mar 13, 10:18 am, "Ken Slovak - [MVP - Outlook]"
<kenslo...@mvps.org> wrote:
> Does the code work on other computers aside from this one?
>
> You can't register stdole directly. How are you installing your VB6 code?
> Just include that dll in your deployment package.
>
> Did you run the Office repair on the problem computer as I suggested?
>
> --
> Ken Slovak
> [MVP -... |