| Thread | Last Author | Messages
read/total | Date |
|---|
| Changing the sender's email address |
|
2 / 2 |
29 Apr |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| Right on the button as usual Sue, thank you very much!
GP... |
| Moving items in VBA |
Ken Slovak - [MVP - O... |
2 / 2 |
21 Apr |
| 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 |
| 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 |
| 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 |
| ... |
| Accessing Text files stored in Outlook Folder |
GP |
3 / 3 |
14 Apr |
| 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 |
| 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 |
| 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 |
| > 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 |
0 / 10 |
11 Apr |
| 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 |
1 / 3 |
10 Apr |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| 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 |
| ... |
| Create Account and Change Settings on VBA |
Dmitry Streblechenko |
0 / 2 |
03 Apr |
| 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 |
0 / 3 |
02 Apr |
| 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... |
0 / 2 |
02 Apr |
| 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] |
0 / 2 |
31 Mar |
| 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 |
0 / 4 |
31 Mar |
| ... |
| Redemption RDO ICS SyncItems SQLRestriction |
Dmitry Streblechenko |
0 / 2 |
30 Mar |
| 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] |
0 / 8 |
29 Mar |
| 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 |
0 / 26 |
29 Mar |
| 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... |
0 / 1 |
24 Mar |
| 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 |
0 / 3 |
19 Mar |
| 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... |
0 / 2 |
19 Mar |
| 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 |
0 / 3 |
18 Mar |
| 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 |
0 / 3 |
16 Mar |
| Thanks again Sue.
-Ed... |
| CreateObject("Outlook.Application") failing to get outlook |
Ken Slovak - [MVP - O... |
0 / 2 |
14 Mar |
| 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 |
0 / 1 |
13 Mar |
| 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 |
0 / 12 |
13 Mar |
| 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 -... |
| text message icon not showing outlook2007 |
sathai |
0 / 2 |
13 Mar |
| I comment this in the community content at
http://msdn2.microsoft.com/en-us/library/bb277361.aspx
Can anybody advise me on how to fixed this issue.
Thanks... |
| Help writing a macro to move emails |
sandeepthanki@gmail.com |
0 / 11 |
13 Mar |
| ... |
| Access/Excel/Outlook/VBA/VSTO/SharePoint |
jACK |
0 / 1 |
12 Mar |
| I have a huge assignment and right now I am doing research. I need to
design basically a business tracking set of tools, either in Visual C+
+ or C# or Basic; or just Office with VBA. Basically we start a job,
and then when it is complete, I need to have it so someone can just
click a button and set a status, and then have email sent out to
responsible parties, and once they finish their... |
| copy email once it's marked as completed |
limi |
0 / 3 |
12 Mar |
| Thanks a lot.
I got some progress from your direction.
Thanks,
limi
"Ken Slovak - [MVP - Outlook]" wrote:
> For #2, ConversationTopic is the same for all mail items in the same thread.
> ConversationIndex increases by a date/time struct size amount for each new
> item in the thread.
>
> #1 can be done automatically or manually. For manual you'd create your macro
> and then... |
| Help parsing body text |
Klaus Linke |
0 / 7 |
11 Mar |
| I agree. If you want to use the array approach, I had posted sample code to
your question in microsoft.public.word.vba.general.
The different number of cells in the rows should not matter much ... as long
as you can determine which column corresponds to which weekday.
Klaus
"JP" <jp2112@earthlink.net> schrieb im Newsbeitrag
news:81dfca73-9a37-4433-a443-98e79f663e1e@s12g2000prg.... |
| How to add button on Mail editor which is not outlook.?? |
Ken Slovak - [MVP - O... |
0 / 39 |
10 Mar |
| Items in a combobox control are based on the XML you supply for that
combobox when the control is first created and accessed. If you want a
dynamically created control use a dynamicMenu control, that you supply with
the contents using the getContent callback. Otherwise you'd have to create
your ribbon XML dynamically when asked for it and it wouldn't be changeable.
--
Ken Slovak... |
| Newbie - need some pointers about reading email and create calendar invites |
Ken Slovak - [MVP - O... |
0 / 2 |
08 Mar |
| item.Body is the plain text string of the mail item. Code run from an open
item would use Application.ActiveInspector.CurrentItem to get the current
item.
For a button in an Inspector in Outlook 2003 or earlier right-click on a
toolbar or menu bar and select Customize. The Commands tab lets you select
Macros, which you can then rename when they are added to a toolbar or menu.
A... |
| VBA .Move or .Copy Resets All Properties |
Dmitry Streblechenko |
0 / 6 |
04 Mar |
| set Msg = Msg.Move(SomeRDOFolder)
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
"David T." <DavidT@discussions.microsoft.com> wrote in message
news:DFC5A6AF-B250-41BE-9551-113B98CFC22E@microsoft.com...
> Do you happen to have the code as an example. I to am trying to properly
> implement the replacement of the standard .move... |
| Warning dialog when sending mail from Access |
Sue Mosher [MVP-Outlook] |
0 / 2 |
04 Mar |
| See http://www.outlookcode.com/article.aspx?ID=52 for your options with regard to the "object model guard" security in Outlook 2000 SP2 and later versions.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54
"DomThePom" <DomThePom@discussions.microsoft.com>... |
| outlook form error -2147467259 |
Sue Mosher [MVP-Outlook] |
0 / 2 |
04 Mar |
| "wrote an outlook form via VB" -- given that is is not possible to create a Outlook custom form with VB, please clarify what you're actually doing. My hunch is that you are creating a new item that uses a custom form, but we won't know that unless you provide us code or more details. Where the form is published is also very relevant.
--
Sue Mosher, Outlook MVP
Author of Microsoft... |
| How can I assign custom keyboard shortcuts to Macros? |
Sue Mosher [MVP-Outlook] |
0 / 6 |
03 Mar |
| The simplest approach is to try the key combination and see what happens. If nothing happens, try using it for your macro. If still nothing happens, give up on that key combination (because it would seem to be reserved by Outlook for some mysterious purpose) and try another one.
You could also write code to iterate the top-level menus and toolbars to list their captions so you can see what... |