| Thread | Last Author | Messages
read/total | Date |
|---|
| Create task automatically from email |
Murphybp2 |
0 / 8 |
16 Jan 2008 |
| ... |
| Sending a Meeting Invitation Update |
kevin.ingle@americred... |
0 / 11 |
16 Jan 2008 |
| Thank you all for your time and help. I'll give up on this idea and
try another solution.... |
| Count Messages Per Conversation |
Ken Slovak - [MVP - O... |
0 / 2 |
16 Jan 2008 |
| Each message in a thread has the same ConversationTopic value. The first
message in the thread has a ConversationIndex that is 22 bytes long. Each
subsequent member of the thread increases the length of ConversationIndex by
5 bytes (a date/time struct).
So you can filter or restrict an Items collection of item in a folder based
on a ConversationTopic value and then count the lengths... |
| Custom .vcs file: Problem with unicode characters |
Vassilis |
0 / 8 |
16 Jan 2008 |
| I finally got a pretty easy solution.
The .vcs file needs to be saved as UTF-8 and not as ANSI or UNICODE.
"Vassilis" <vc@this_spam_REMOVE_printing.gr> wrote in message
news:uk$ckNeUIHA.4768@TK2MSFTNGP02.phx.gbl...
> Hi,
>
> I'm using vbscript to create custom calendar entries (.vcs files). This
> was working perfectly on outlook 2003 but on the .vcs files of outlook
> 2007 it... |
| Macro for Moving and Copying Mail |
Sue Mosher [MVP-Outlook] |
0 / 4 |
15 Jan 2008 |
| The GetFolder() function at the URL I suggested doesn't care whether you use a / or \. It can handle either (since some of us forget which is used when). Spaces are expected and normal.
We cannot look over your shoulder, however, and see what's going wrong. You have to at least show the relevant code snippet and tell us what unexpected behavior you're seeing. Ideally, you'd also step... |
| Automatically enable journal tracking for new contacts |
Ken Slovak - [MVP - O... |
0 / 5 |
15 Jan 2008 |
| Then you will need to handle the ItemAdd event on the Items collection of
any contacts folder you want to monitor. You can modify any of the ItemAdd
handler examples at www.outlookcode.com to do the sort of thing you want by
changing the folder and adding that code I showed. Search for ZapHTML at
outlookcode.com and use that as a model.
--
Ken Slovak
[MVP - Outlook]
http://www.... |
| Detect Mail Merge from Word |
Eric Legault [MVP - O... |
0 / 5 |
14 Jan 2008 |
| Whoops - I replied to my reply by accident, in case you miss my response.
--
Eric Legault - Outlook MVP, MCDBA, MCTS (SharePoint programming, etc.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/
"Jim Leach" wrote:
> Thanks for your reply Eric,
>
> I was HOPING I could detect the mail merge from... |
| conditional formatting |
Eric Legault [MVP - O... |
0 / 2 |
14 Jan 2008 |
| Conditional formatting can be set in specific Views for a given folder.
--
Eric Legault - Outlook MVP, MCDBA, MCTS (SharePoint programming, etc.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/
"Southern at Heart" wrote:
> I have outlook 2003, with pop access to two mail accounts. I want all my
>... |
| Choose the email account when sending emails via VBA |
Ken Slovak - [MVP - O... |
0 / 5 |
14 Jan 2008 |
| And in Outlook 2007 you can use the MailItem.SendUsingAccount property.
--
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
"Dmitry Streblechenko" <dmitry@dimastr.com> wrote in message
news:%23CvbMItVIHA.3940@TK2MSFTNGP05.phx.gbl...... |
| Actually reading mail from Visual Basic Studio Express Edition |
Dmitry Streblechenko |
0 / 2 |
14 Jan 2008 |
| You cannot programmatically select a message in an explorer (you can *read*
the selection using Explorer.Selection colletion).
To programmatically access a message in Outlook, it does not have to be
selected first.
Dmitry Streblechenko (MVP)
http://www.dimastr.com/
OutlookSpy - Outlook, CDO
and MAPI Developer Tool
"AlanC" <AlanC@discussions.microsoft.com> wrote in message... |
| Save Attachment via VBA |
Eric Legault [MVP - O... |
0 / 6 |
14 Jan 2008 |
| Your welcome Roger!
The AdvancedSearch function is in Outlook:
AdvancedSearch Method:
http://msdn2.microsoft.com/en-us/library/aa220071(office.11).aspx
Info on DASL:
Tips for DASL searches:
http://www.outlookcode.com/news.aspx?id=30
You use the Create View dialog in Outlook as the tool to help build the
search strings for the AdvancedSearch method. Let me know if you need... |
| Appointment in Calendar help - Event triggers - Visual basic |
kneel |
0 / 3 |
11 Jan 2008 |
| Perfect, this is the exact help I needed!! Thanks again!
"Eric Legault [MVP - Outlook]" wrote:
> I think the easiest option would be to monitor the ItemChange event in an
> Items collection retrieved from the Calendar folder and check the
> ResponseStatus property.
>
> --
> Eric Legault - Outlook MVP, MCDBA, MCTS (SharePoint programming, etc.)
> Try Picture Attachments Wizard... |
| Message thread management |
M. Eteum |
0 / 4 |
11 Jan 2008 |
| Brian Tillman wrote:
> M. Eteum <meteum@bluebottle.com> wrote:
>
>> Is there a way to fix this, perhaps running it thru a simple filter
>> that has a bit more intelligent than the outlook engine, e.g. using a
>> pattern matching right-to-left-of-the-subject-line instead of
>> right-to-left to avoid issues such as spaces, double Re: Re: etc.
>>
>> If possible, how do I redirect all... |
| Extracting received time from an email message |
S Shipley |
0 / 3 |
10 Jan 2008 |
| Thanks JP - just what the doctor ordered.
"JP" wrote:
> Sure, how about this?
>
> Sub GetStuff()
> Dim CurrentMsg As Outlook.MailItem
> Set CurrentMsg = ActiveInspector.CurrentItem
>
> MsgBox CurrentMsg.SenderEmailAddress & vbCr & vbCr & _
> Format(CurrentMsg.ReceivedTime, "HH:MM:SS")
>
> End Sub
>
>
> Just double click to open the msg, then run this code.
>
> HTH,
>... |
| set backcolor of AX ctrl |
Ken Slovak - [MVP - O... |
0 / 2 |
10 Jan 2008 |
| You'd have to use Win32 API functions for that. You'd get the location of
where you want to read the color and get the color and gradient used and
then try to match that in your form.
--
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... |
| sending mails from excel...but mail body disappearing |
Jithu |
0 / 1 |
10 Jan 2008 |
| Hi All,
My macro will send mail from excel with an excel attachment.
The body of the message in from the attached spread sheet. The reciepient
will get my mail perfectly.My problem is that when the reciepient tries to
forward or reply my mail all the mail body disappears........ |
| Outlook Script: |
Michael Bauer [MVP - ... |
0 / 2 |
10 Jan 2008 |
| > For Each myItems in myItems
That won't work at all. Either you have myItem declared as ContactItem and
there's also a distribution list in the folder, or you run into the problem
that Outlook sometimes doesn't dispose references.
For the latter this might be a workaround (it's a sample for MailItems,
please adapt the LoopItems procedure):
http://www.vboffice.net/sample.... |
| Distribution list that includes other distribution lists. |
Mike |
0 / 3 |
10 Jan 2008 |
| I'll give this a try. It looks pretty workable, once you see it and realize
that Outlook needs to be fooled a little bit.
Thanks a bunch!
--
Mike
"Michael Bauer [MVP - Outlook]" wrote:
>
>
> Here's a sample:
> http://www.vboffice.net/sample.html?mnu=2&pub=6&smp=61&cmd=showitem&lang=en
>
> --
> Best regards
> Michael Bauer - MVP Outlook
> Synchronize Outlook... |
| hot secret lesbian action |
yenc@yenc-news.co.uk |
0 / 1 |
09 Jan 2008 |
| ... |
| SOLVED.Display does not work when Outlook has not been started yet |
BigBirdNL |
0 / 2 |
09 Jan 2008 |
| Problem solved.
The problem occurred because I did not initialize Outlook. Below is the
corrected code.
Sub SendByMail(cBevNr, cKorteOmschrijving, cBijlageFile)
' creates and sends a new e-mail message with Outlook
' requires a reference to the Microsoft Outlook 11.0 Object Library
Dim ol As Outlook.Application
Dim OLF As Outlook.MAPIFolder
Dim olItem As Outlook.MailItem
Dim... |
| Show this folder as an e-mail Address Book |
Eric Legault [MVP - O... |
0 / 4 |
09 Jan 2008 |
| Yeah, what Ken said. :-)
--
Eric Legault - Outlook MVP, MCDBA, MCTS (SharePoint programming, etc.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/
"Ken Slovak - [MVP - Outlook]" wrote:
> You'd have to use Extended MAPI (C++ or Delphi only, not supported for
> managed code). See
> http://groups.... |
| Problem Adding Recipients |
77m.grub@gmail.com |
0 / 4 |
09 Jan 2008 |
| Apparently the issue is with the "Set objOutlookAddSig =
objOutlookMsg.GetInspector" line. If I comment it out, it works
correctly. Any ideas?
> > I am creating an Outlook mail item from within Access and am adding 3
> > recipients. The code below *should* insert strLeaderEmail in the To
> > field, strApprentice1Email in the CC field, and strApprentice2Email in
> > the CC field. But... |
| HOW TO SET REMINDERS FOR THE MAIL SENT PROGRAMMATICALLY? |
Paresh_Sen_3889e7 |
0 / 1 |
09 Jan 2008 |
| Hi all,
I want to set reminders for the mail being sent programmatically.
I'm able to but the follow up flag using "X-Message-Flag" in internet
headers.
Can any one suggest how to set the reminder for the same?
Or is there any other option for enabling follow up.
Thanks... |
| Import VCF files to an Outlook folder |
Eric Legault [MVP - O... |
0 / 4 |
08 Jan 2008 |
| Another way is to parse the contents of each .vcf file and manually create
the Contacts from scratch in code. Of course, you'd require a firm knowledge
of the vCard specification in order to parse the name-value pairs in the file.
vCard - Wikipedia, the free encyclopedia:
http://en.wikipedia.org/wiki/VCard
vCard 2.1 specification:
http://www.imc.org/pdi/vcard-21.txt
If you want... |
| Send a day view of a calendar in an email |
Eric Legault [MVP - O... |
0 / 4 |
07 Jan 2008 |
| Exchange supports the use of Event Sinks, which is code that runs on the
server and can work on a timer if so desired. However, creating event sinks
is a very advanced operation.
If you're dead set on having an e-mail sent at a specific time only, there
are options but with some limitations and caveats.
Otherwise, a simple macro to run on demand would be your best option.
--... |
| detect archive being opened |
Ken Slovak - [MVP - O... |
0 / 2 |
07 Jan 2008 |
| In Outlook 2007 you can use the Stores.StoreAdd event to know when a user
has opened another Store (PST file or Exchange mailbox). To know when a user
has removed a Store (closed it) you can use the Stores.BeforeStoreRemove
event. You can iterate the Stores collection on close of Outlook before the
collection goes out of scope, but you can't force the user to close the
store or... |
| Disappearing Act - Lost Macros |
Michael Bauer [MVP - ... |
0 / 2 |
07 Jan 2008 |
| Look for an *.otm file in:
c:\documents and settings\[user]\application data\Microsoft\Outlook
--
Best regards
Michael Bauer - MVP Outlook
Synchronize Outlook Categories:
<http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6>
Am Sun, 6 Jan 2008 19:25:00 -0800 schrieb Paul Travis:
> Eighteen months ago, I spent a lot of time writing a VBA macro for... |
| Problem with Object Reference for MailItem |
alexcraig |
0 / 4 |
06 Jan 2008 |
| JP,
Sounds like a pretty darn good tip!
I'll take your advice and maybe save myself a chunk of time in the future.
Thanks.
"JP" wrote:
> If you used "Option Explicit" at the top of all your code modules,
> this wouldn't have happened.
>
> Or in the VBE, click Tools>Options>Editor tab, check "Require Variable
> Declaration" box to add "Option Explicit" automatically to the
>... |
| Import bold face fonts |
Michael Bauer [MVP - ... |
0 / 4 |
05 Jan 2008 |
| Very nice!
--
Best regards
Michael Bauer - MVP Outlook
Synchronize Outlook Categories:
<http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6>
Am Sat, 5 Jan 2008 10:02:20 -0500 schrieb Sue Mosher [MVP-Outlook]:
> Yet another approach appropriate to creating a new message from the
content of a Word document is to use the MsoEnvelope object; see... |
| Logon to Outlook from VB |
Ken Slovak - [MVP - O... |
0 / 2 |
04 Jan 2008 |
| The logon is really only for Exchange mailbox logon and is pretty useless,
certainly for password protected PST files. There's nothing you can do about
that other than not using password protected PST files or being there to
logon manually.
--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007
Reminder Manager, Extended Reminders,... |
| Retrieve Flag For Me values in Outlook 2007 |
Ken Slovak - [MVP - O... |
0 / 5 |
04 Jan 2008 |
| From what I've seen with this sort of thing my guess is that the values
displayed on the InfoBar are cached by Outlook and not written to MAPI
properties until after the item is sent. Then the properties appear in the
item if you look using OutlookSpy or MFCMAPI. I think you'd have to wait
until after send to get them set correctly. The properties on the item
before sending aren't the... |
| Help with - System.Diagnostics.Process.Start |
Ken Slovak - [MVP - O... |
0 / 2 |
04 Jan 2008 |
| Mailto doesn't support an attachment clause, take a look at the MS docs on
that. Use Outlook automation to add the attachment.
--
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
"JimJob" <JimJob@discussions.microsoft.com> wrote in... |
| To get user distingushed name using Default Naming Context.. |
JP |
0 / 4 |
04 Jan 2008 |
| ... |
| VBA Script that copies incoming message to task |
JP |
0 / 3 |
03 Jan 2008 |
| You could use the ItemSend event to grab a copy of the message and
copy it to your default Tasks folder (which would turn it into a
task).
For example:
Private Sub Application_ItemSend(ByVal Item As Object, Cancel As
Boolean)
Dim objNS As NameSpace
Dim TaskFldr As MAPIFolder
Dim recip As Recipient
Set objNS = Application.GetNamespace("MAPI")
Set TaskFldr = objNS.... |
| Email to an MS SQL Table |
Ken Slovak - [MVP - O... |
0 / 2 |
03 Jan 2008 |
| Just set a reference to the ADO of your choice in the Outlook VBA project
and use it all you want. I've used ODBC and ADO many times from Outlook VBA.
What you can't do is use an ADO or ODBC connection to Outlook and expect to
get anywhere near the actual number of properties that exist on an item, and
some properties (email addresses for one) are security restricted for ODBC... |
| help coding message options |
JP |
0 / 2 |
03 Jan 2008 |
| When you create the MailItem and set an object reference, you can add
those parameters. For example:
Dim Outlook As Outlook.Application
Dim OutlookMsg As Outlook.MailItem
Set Outlook = CreateObject("outlook.application")
Set OutlookMsg = Outlook.CreateItem(olMailItem)
With OutlookMsg
.Importance = olImportanceHigh
.Categories = "Something here"
.VotingOptions =... |
| how do I code message send options for voting priority category? |
Eric Legault [MVP - O... |
0 / 2 |
03 Jan 2008 |
| Hi JC. The SendObject command in Access only facilitates basic Outlook
integration. To set values on additional message properties you need to use
the Outlook Object Model directly. Here's a quick example:
Sub CreateHTMLMail()
'Creates a new e-mail item and modifies its properties
Dim olApp As Outlook.Application
Dim objMail As Outlook.MailItem
Set olApp = Outlook.... |
| How do I forward the message from outlook to mobile phone? |
Eric Legault [MVP - O... |
0 / 2 |
03 Jan 2008 |
| Hi Neelima. This forum is for questions about Outlook programming.
You usually send e-mails to mobile phones using
1235551234@cellularprovider.com - check with your carrier.
--
Eric Legault - Outlook MVP, MCDBA, MCTS (SharePoint programming, etc.)
Try Picture Attachments Wizard for Outlook:
http://www.collaborativeinnovations.ca
Blog: http://blogs.officezealot.com/legault/... |
| Attach item from another application |
Ken Slovak - [MVP - O... |
0 / 6 |
03 Jan 2008 |
| If you want that exact dialog the only way to open it is to get the ID of
that command from the menu structure (CommandBars) and call the button's
Execute method. The Insert File button on the Standard toolbar has an ID of
1079 in an Outlook editor email item.
--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Professional Programming Outlook 2007
Reminder Manager,... |
| define a parameter outside the code.. |
Michael Bauer [MVP - ... |
0 / 2 |
03 Jan 2008 |
| You can e.g. use a simple text file. Here's a sample for how to read a file:
http://www.vboffice.net/sample.html?pub=6&mnu=1&smp=14&cmd=showitem&lang=en
--
Best regards
Michael Bauer - MVP Outlook
Synchronize Outlook Categories:
<http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6>
Am Thu, 3 Jan 2008 01:18:02 -0800 schrieb Miri:
> i added a macro that... |
| How to bring Calendar window to top after open? |
Michael Bauer [MVP - ... |
0 / 5 |
03 Jan 2008 |
| Ok, thanks.
--
Best regards
Michael Bauer - MVP Outlook
Synchronize Outlook Categories:
<http://www.vboffice.net/product.html?id=2006063&cmd=detail&lang=en&pub=6>
Am Wed, 2 Jan 2008 09:20:50 -0500 schrieb Ken Slovak - [MVP - Outlook]:
> Sometimes. I've seen that fail to work as expected sometimes, and the
window
> remains on top of the z-order no matter what you do.... |
| Can I transfer MSN email files/folder contents to Outlook emai |
Cally |
0 / 2 |
03 Jan 2008 |
| Hi Eric...
Thanks for taking time out to help me. I started with MSN Mail then I spent
eons trying to set up my Outlook to let me access my MSN account mail, etc..
In the end Outlook mail even showed MSN and an MSN Server mail access points.
However, they did not go anywhere. I would just get the same error! message
telling me I had no MSN account. Go figure. I followed the http: path... |
| Outlook 2003 macro signature help please |
John Kaess |
0 / 4 |
02 Jan 2008 |
| Thanks!! When I stepped through it told me macros were not activated,
something screwy in the macro security. Everything is working now.
Thank You for your help!
On Wed, 2 Jan 2008 17:24:32 -0500, "Sue Mosher [MVP-Outlook]"
<suemvp@outlookcode.com> wrote:
>What happens when you step through the code in the debugger? Do all statements execute? Are you sure that the message isn't... |
| Custom form code not firing |
Sue Mosher [MVP-Outlook] |
0 / 2 |
02 Jan 2008 |
| See my response to your post in the microsoft.public.outlook.program_forms group.
--
Sue Mosher, Outlook MVP
Author of Microsoft Outlook 2007 Programming:
Jumpstart for Power Users and Administrators
http://www.outlookcode.com/article.aspx?id=54
"karlman" <karl@geekclan.com> wrote in message news:e4ff79b9-7663-4337-94d5-b8a3562c9be6@e10g2000prf.googlegroups.com...
>... |
| Outlook email call from Access Runtime 2003 |
Ken Slovak - [MVP - O... |
0 / 5 |
02 Jan 2008 |
| There is no license to deploy any Outlook components at all with VS, just
the ability to create Outlook compatible code. However, Outlook has to be
installed for the code to work.
Late binding lets you work with different versions of Outlook and to call
methods or properties not exposed in the version you have referenced. It
will never allow Outlook object model code to run if... |
| Dist List Listbox |
Ken Slovak - [MVP - O... |
0 / 2 |
02 Jan 2008 |
| Go to www.outlookcode.com and search on "distribution list", you'll see lots
of code samples for manipulating distribution lists with code.
Be aware that DL's aren't the most robust things and most of the time most
of us try to avoid them. They also capture the contact's state at the time
they are added to the DL, any changes to the contact subsequent to that time
will require... |
| Attachment - Downloads |
Ken Slovak - [MVP - O... |
0 / 2 |
02 Jan 2008 |
| Check each attachment for its Type. If it's anything other than
OlAttachmentType.olByValue then it's an attachment that's embedded in the
email and not a "true" attachment.
Be aware that the Type will only be valid for messages that are saved or
received. Also, in some cases you would have to also look at some MAPI
properties on the attachment to really trap every possibility. The... |
| REPLY MAIL - Above orginal mail |
Ken Slovak - [MVP - O... |
0 / 3 |
02 Jan 2008 |
| The Reply() method will show the message being replied to if Outlook is set
that way. If it's not you will need to set Outlook to include the original
message in the reply.
--
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
"Jithu"... |
| ADO Connection Problem |
alexcraig |
0 / 5 |
01 Jan 2008 |
| Norman,
You can disregard my last reply as I managed to get it working. ;-)
For anyone perusing this thread in the future, here is some sample code
which successfully grabs some data from Sql/Server and inserts it at the
current cursor point in an active New Composition Mail Window.
Code:
Dim Source As Variant, Rs1 As ADODB.Recordset
Dim JobOrderNo As String, Srcresult As... |
| Can i set language imput using macro in an event? |
panos |
0 / 1 |
01 Jan 2008 |
| I would like to set the language in greek language using macros in an
event.Is that possible?That is why because i would like to input data in a
textbox only in greek.
Many thanks and Happy new year to everyone!
Panos... |