ThreadLast AuthorMessages
read/total
Date
Can you cache shared mailbox folder for efficient local operations
Ken Slovak - [MVP - O...
0 / 2 21 Oct 2008
Have you tried using MAPIFolder.CopyTo() or the Redemption equivalent to test whether it works? -- 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 "Tadwick" <Tadwick@discussions.microsoft.com> wrote in message...
Automating sending mail through Outlook2003 with VB6 requiring a p
Alan Moseley
0 / 2 21 Oct 2008
Your problem lies within the NameSpace.Logon method, by default it will diplay the logon box. Take a look at the following article:- http://msdn.microsoft.com/en-us/library/bb219914.aspx -- Alan Moseley IT Consultancy http://www.amitc.co.uk "send mail through Outlook2003 using vb6" wrote: > Is this possible? I am modifing some code that sends mail through Lotus > Notes...
.Find fails for .Outlook._Items
Jan Hyde (VB MVP)
0 / 6 20 Oct 2008
"Ken Slovak - [MVP - Outlook]" <kenslovak@mvps.org>'s wild thoughts were released on Fri, 17 Oct 2008 11:31:05 -0400 bearing the following fruit: >No Set for VB.NET code. Gets me *every* time. -- Jan Hyde (VB MVP) https://mvp.support.microsoft.com/profile/Jan.Hyde...
Attach a word.doc
Curt
0 / 5 18 Oct 2008
Thanks much I did finally figure a way around my problem Thanks Again for your resonce "Michael Bauer [MVP - Outlook]" wrote: > > > If the group you're talking about is a DistributionList, you can add that to > the MailItem.Recipients.Add function. For code samples, please see the VBA > help for Recipients.Add and Attachments.Add > > -- > Best regards > Michael Bauer - MVP...
Default Signature added by macro
Michael Bauer [MVP - ...
0 / 2 18 Oct 2008
After creating the e-mail, call its GetInspector method, which will insert the signature. Then place your text at the beginning of the body like this: sig=htmlbody htmlbody = yourtext & sig -- Best regards Michael Bauer - MVP Outlook : VBOffice Reporter for Data Analysis & Reporting : Outlook Categories? Category Manager Is Your Tool : <http://www.vboffice.net/product....
unreplied mails in Outlook-2007
Michael Bauer [MVP - ...
0 / 2 18 Oct 2008
I don't think that's possible with a rule. You could write some code to loop through all of items and look for the property PR_LAST_VERB_EXECUTED. A value of 102 indicates that the last action on that item was a reply to the sender. But you can't do that with the Outlook object model, instead you might use Redemption from www.dimastr.com. -- Best regards Michael Bauer - MVP...
Outlook form checkbox populate To field
archon
0 / 1 17 Oct 2008
Hi, I have an outlook form with 5 checkbox and would like the checkbox to populates the "to" field. Ex. If I check chk1 chk4 and chk5 then I would have recipient1, recipient4 and recipient5 in the "to" field. Any idea how I could accomplish that? I would also like to maybe assosiate a Cc or two with each checkbox. Box would have to remain checked for the reader. Thanks...
contacts
Curt
0 / 3 16 Oct 2008
No I didn't set the ab property Thanks "Ken Slovak - [MVP - Outlook]" wrote: > When you click on it where? What do you mean you "created a group"? > > If this is a contacts folder, and it has items in it with either email or > fax addresses and you have it set to show as an Outlook AddressBook it > should work. Did you set the ShowAsOutlookAB property of the contacts folder > to...
Have Replies Sent To: VBA code
JP
0 / 4 16 Oct 2008
...
Comment r袵p豥r les boutons de cde sous VBA outlook ?
Michael Bauer [MVP - ...
0 / 2 16 Oct 2008
Salut, in this group write in English, please. Or you might visit e.g. microsoft.public.fr.outlook -- 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, 15 Oct 2008 20:56:32 +0200 schrieb Roland: > Bonsoir, >...
Exchange 255 RPC Connection Limit
OutlookIssueMan
0 / 3 15 Oct 2008
Yes, we are (generally) very careful about that. I was hoping that there would be a system call, WMI, networking monitoring tool, or something that I could use to monitor the connections. Michael "Dmitry Streblechenko" <dmitry@dimastr.com> wrote in message news:OOiDiAwLJHA.6000@TK2MSFTNGP04.phx.gbl... >I don't think there is a way to monitor open RPC connections. > Another thing...
Question abt Outlook 2003 VBA application by Sue Mosher*10152008
Sue Mosher [MVP-Outlook]
0 / 2 15 Oct 2008
Please see my response on your original thread at http://www.microsoft.com/communities/newsgroups/en-us/default.aspx?dg=microsoft.public.outlook.general&mid=26857935-6d73-45a0-9093-6e45b4a4454e . You don't need to start the conversation over in another newsgroup. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and...
Saveas method
Dmitry Streblechenko
0 / 8 15 Oct 2008
What is olMSGHTML? You are accessing the very first item in the folder; keep in mind the very first item in the MAPIFolder.Items collection will not necessarily be shown first (or last) in the Outlook UI. Look at the Subject property to make sure you are dealing with the expected message. I bet you have an old RTF message that Outlook refuses to save in the HTML format. --...
Custom Rule that Opens Incoming Message Meeting Conditions
Chris Dunbar
0 / 3 15 Oct 2008
Yes. As long as Outlook is open, I need the message to open up if received from a specific sender, even if it means interrupting the user. Cheers! -- Christopher Thomas Dunbar, MBCP "JP" wrote: > You want messages from a certain sender to automatically interrupt the > end user? > > --JP > > On Oct 14, 4:13 pm, Chris Dunbar <Chris > Dun...@discussions.microsoft.com>...
VBA Editor Keeps Opening On Its Own-Outlook 07
Dave_V
0 / 1 15 Oct 2008
I've created a script that automatically saves attachments to a specified folder, using the date portion of the ReceivedTime to name the attachment (the email arrives daily with the attachment always titled "mail.rtf" I've setup a rule to run this script when the appropriate email arrives. It works beautifully. However, since I started utilizing this script, the VBA editor will...
Opens new mail from Excel but won't send the message
Gina_28 via OfficeKB.com
0 / 3 14 Oct 2008
I think I figured it out!! Was missing a (.Send) before the ('Or Use Display). Thank you!! Sue Mosher [MVP-Outlook] wrote: >Outlook version? Exactly what happens when the code executes your >MailItem.Send statement? Is your macro in Outlook or Excel? >> Hello, >> >[quoted text clipped - 6 lines] >> missing a partial code that I need to add to the end of my macro? Or could >>...
Direct mail merge documents to drafts folder
Curt
0 / 6 14 Oct 2008
Trying to follow but I get lost. I am trying to attach a word.doc to all entries in a contact group in outlook Have never tryed this befor. Your code gives me a start Thanks "JP" wrote: > Sue is right. You may need to re-write your routine to use Outlook to > attach the messages. I use Excel to find the attachment, open Word and > do the mail merge, then tell Outlook to craft a msg...
send email with Outlook's default text format and default signatur
Jan Hyde (VB MVP)
0 / 2 13 Oct 2008
sam <sam@discussions.microsoft.com>'s wild thoughts were released on Sun, 12 Oct 2008 09:23:00 -0700 bearing the following fruit: >i'm useing access for sending emails. >while useing the Outlook object model how can i send the email with >Outlook's default text format and default signature ? > >thanks I take it you are setting the e-mail body? Outlook tends to add the signature...
Macros - Program to insert text only into body of email
JP
0 / 3 11 Oct 2008
...
Help with OL07 macro to fix invalid entryid
genegiannamore
0 / 8 10 Oct 2008
Can't figure out how to edit my prior post. I changed the little macro to hopefully make a little more sense, I wonder if this new macro is ok, or will it cause damage? Option Explicit Sub FixEntryIDs() Call FixEntryID End Sub Sub FixEntryID(Optional ByVal contacts As folder) Dim item As ContactItem Dim subf As folder Dim changed As Boolean If...
User-defined property in .msg persisted item not updating
Ken Slovak - [MVP - O...
0 / 2 10 Oct 2008
If it's only one user my guess would be some other code running on their machine that interacts with Outlook that's causing the problem. Check for any addins, synch software and A-V addins. Make sure to check for addins in the registry in both HKCU and HKLM to make sure you spot all of them, in versions earlier than Outlook 2007 you don't see addins registered in HKLM in the COM...
Changing the subject line of a message to a set format
Ken Slovak - [MVP - O...
0 / 4 10 Oct 2008
' start of the code re.Pattern = "(.*-.*$)" If re.Test(Item.Subject) = False Then Item.Subject = Format(Date, "yyyyMMdd") & "-" & Item.Subject & "-" & userName & "-?" End If End If Item.Save Else strMsg = "Correct Formatting Options:" & Chr(13) & Chr(10) 'rest of the code -- Ken Slovak [MVP -...
Filtering Meeting Invites As a Delegate
Tarebare
0 / 1 09 Oct 2008
I support multiple managers and have been delegated and given permission to manage their calendars. I receive so many meeting invites that it take to much time to go through when I have more important things that need to be done. My company has a space limit so I need to go through in order to receive and send e-mails. It would be nice to have a way to create a rule to filter...
Disabling links in particular folders
Dmitry Streblechenko
0 / 2 09 Oct 2008
I don't think you can do that, this is waht Outlook does for messages in the Junk E-mail. You can programmatically disable images in HTML meszages, but that's about it. -- Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool - "ptr@home" <ptrhome@discussions.microsoft.com> wrote in message...
Changing the flag status
Sue Mosher [MVP-Outlook]
0 / 3 09 Oct 2008
Unless you also have an objMail.Save statement, your changes to the item will be discarded. Your Outlook version might also be useful information. -- Sue Mosher, Outlook MVP Author of Microsoft Outlook 2007 Programming: Jumpstart for Power Users and Administrators http://www.outlookcode.com/article.aspx?id=54 "Mark J" wrote: > Hi > > I've written some code to...
Outlook vba errror message says Access can't find my userform
Michael Bauer [MVP - ...
0 / 6 08 Oct 2008
...
Send to Mail Recipient to Outlook 2007
Ken Slovak - [MVP - O...
0 / 2 08 Oct 2008
This is a peer to peer forum, not a place to make suggestions to MS. In addition, that's how Simple MAPI items work, they are opened modally. It's been that way since Outlook came out and isn't likely to ever be changed. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007. Reminder Manager, Extended Reminders, Attachment Options....
sending emails from access
Ken Slovak - [MVP - O...
0 / 4 08 Oct 2008
For HTML emails you just construct what you want as valid HTML text, bearing in mind the HTML limitations in Outlook, and then set the HTMLBody property of the email to your HTML. Or you can get HTMLBody as a text string and parse it as HTML and add whatever you want to the existing HTML string, then replace HTMLBody. For WordMail you can do the exact same thing as for Outlook editor...
Create a macro to open a MS access database
Ken Slovak - [MVP - O...
0 / 2 08 Oct 2008
How do you want to talk to the Access database, DAO or ADO or pure Access code or what? For DAO: Dim dbEmployees As DAO.Database Dim rstEmployees As DAO.Recordset Set dbEmployees = OpenDatabase _ ("C:\Program Files\Microsoft " _ & "Office\Office\Samples\Northwind.mdb") ' Use an SQL statement to get the data from the Employees ' table into a recordset. Set...
Getting Attachments from SafeMailItem returns 1st item twice
Ken Slovak - [MVP - O...
0 / 3 08 Oct 2008
For future reference all Outlook collections start at 1, unlike pure managed code collections. -- 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 "Chris Miller" <ChrisMiller@discussions.microsoft.com> wrote in message...
Send to Distribution List in Contacts
Ken Slovak - [MVP - O...
0 / 2 07 Oct 2008
Just add the DL to the Recipients collection of the email item. -- 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 "Steve" <Steve@discussions.microsoft.com> wrote in message news:CFCAFF60-DA27-48DE-B125-897AD7219C2D@microsoft.com......
Hyperlink breaks when there's a space
Ben
0 / 3 07 Oct 2008
Sue, Thanks so much. It worked. Ben -- "Sue Mosher [MVP-Outlook]" wrote: > Try using a valid URL, replacing spaces with %20 e.g. > > <a href ="file://\\SERVER\Path\Month%20Year\SomeExcelFile.xls"> > > -- > Sue Mosher, Outlook MVP > Author of Microsoft Outlook 2007 Programming: > Jumpstart for Power Users and Administrators > http://www.outlookcode....
is there a way to not disable a rule with incoming messages
Michael Bauer [MVP - ...
0 / 2 07 Oct 2008
Try if this helps: Sub CustomMailMessageRule(ByVal Item as MailItem) On Error GoTo Quit Quit: End Sub -- 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 Tue, 7 Oct 2008 20:07:00 +0300 schrieb Tom: > I...
Code for moving Sent Items depending on From Field
SueD
0 / 1 07 Oct 2008
We are running Outlook 2000 in CW mode and use communal departmental mailboxes as well as our own. I need some code to automatically move Sent Items that have been sent from the departmental address to the departmental Sent Items folder instead of each individual one. The department address appears in the From Field....
E-mail are Unreadable Format
Dmitry Streblechenko
0 / 2 06 Oct 2008
Tell the sender to use software that does not send malformed messages? There should be a tab/space before the "boundary" line. -- Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool - "Bala Krishna" <Bala Krishna@discussions.microsoft.com> wrote in message news:5E1630F2-A159-4ABC-A5C0-E55399FC5EC9@microsoft.com... > One of The User...
Refering to a folder
Bre-x
0 / 3 06 Oct 2008
Thanks, it works fine. now, if you dont mind, how to add and Item? thnks "Sue Mosher [MVP-Outlook]" <suemvp@outlookcode.com> wrote in message news:4207ACCA-B65B-4F19-9A26-A875A1E04AAC@microsoft.com... > Use the GetDefaultFolder method and Parent and Folders properties to walk > up > and down the folder hierarchy, e.g.: > > Set inbox = Application.Session....
outlook 2007 warning message when emailing from Access
Sue Mosher [MVP-Outlook]
0 / 3 06 Oct 2008
In Outlook, look in Tools | Trust Center | Programmatic Access. Is the antivirus status listed as "Valid," and are the three warning option controls enabled? If so, then you don't need Redemption to avoid security prompts. Instead, you can just use Outlook automation (e.g the Application.CreateItem method from the Outlook object model) to create an send a new message. I don't know...
Outlook macro return Runtime error : operation failed for mail
Shiv
0 / 4 06 Oct 2008
@Michael The problem persists even with a folder ex: "test" @GP Yes .. the item may not be a mail item.. but the error is same even if it is... I use watch to see what is happen with the objects... i found all folders within inbox return "Operation Failed " for all properties in the Object Ex : ObjFolder => "Inbox" Folders=>Item(1)=> "operation failed" this is same for all...
Macro to rename Subject of E-mail on exchange server(2007)
JP
0 / 5 05 Oct 2008
...
drag and drop
Michael Bauer [MVP - ...
0 / 2 04 Oct 2008
You can't do that with Outlook. -- 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 Fri, 3 Oct 2008 15:53:12 -0700 schrieb Joel Allen: > Outlook 2003 SP3 > > Hi, > > I want to drag and drop a file into the...
Is this possible?Shared calendar reminders between 3 people &remin
Mitch
0 / 2 03 Oct 2008
I found this bit of code. I assume if I replaced Public Folder path with say. Calendar/Shared It would load the secondary Shared Calendar (I made a second calendar for these reminders specifically) ' GetFolder - Gets a Public folder based on a string path - e.g. 'If Folder name in English is 'Public Folders\All Public Folders\Europeen Workflow 'The just pass in "Europeen...
Newbie- is this possible? (code to save attachments from serve
GP
0 / 4 03 Oct 2008
VBA is a macro language for applications, in other works an application that supports VBA needs to be running (typically Word, Excel, Outlook, etc). You can't run a client side VBA macro if the PC is turned off. Even with a shared mailbox, at least one user with access to the mailbox needs be be logged on to run a VBA macro. I'm sure other programming languages can get arund this, e.g....
Advice needed
Anrey Terkin
0 / 1 02 Oct 2008
i need help on my download scam site the who is dns server is not working with my php database. can anyone help? you can email me directly or use this address Address: Truda 14-1 City: Saint-Petersburg State: Saint-Petersburg ZIP: 188934 Country: RU Phone: +7.9113234634 the site is www.quicksoftupdate.com thanks...
get the clipboard value into a vba string
oldyork90
0 / 5 02 Oct 2008
...
Outlook integration with custom .Net application?
Ken Slovak - [MVP - O...
0 / 11 02 Oct 2008
See if the information in Misha Shneerson's blog (he's a member of the VSTO team) at http://blogs.msdn.com/mshneer/archive/2007/09/04/deploying-your-vsto-add-in-to-all-users-part-i.aspx helps with deploying for all users. If Add-In Express is involved you might also want to contact them or review their FAQ's or KB articles to see if they have any information. -- Ken Slovak [MVP...
Change the Default Message Format for Outlook Application via Inte
Ken Slovak - [MVP - O...
0 / 2 02 Oct 2008
That value is set in the registry at HKCU\Software\Microsoft\Office\xx.0\Outlook\Options\Mail\EditorPreference as a DWORD. The exact path depends on the version of Outlook. for 2002 it would be 10.0, for 2003 it would be 11.0 and for 2007 it would be 12.0. The value you set there would depend on whether or not WordMail is being used and also if it's Outlook 2007. Since you don't...
Redemption and Outlook 2007
MA
0 / 9 01 Oct 2008
Thanks, email sent. Looking forward to receive your response. Regards, MA...
change outlook calendar folder name
MiataMX5
0 / 3 01 Oct 2008
"MiataMX5" wrote: > what VBA do I use to change a folder name many thanks...
Do Loop to build Dynamic Table and insert into HTML body
Michael Bauer [MVP - ...
0 / 2 01 Oct 2008
You may use the Offset function in Excel. Set a Range variable to the upper left cell you want to start with, e.g.: Set rn=Cells("a1") Now do the loop, and for a new row call: Set rn=rn.Offset(1,0) For every column use a For Next loop, and write the value of column 1 to rn.Value, the second to rn.Offset(0,col).Value, etc. That works but is pretty slowly. A lot faster...
Set Send Receive Setting using code or PRF
Dmitry Streblechenko
0 / 4 30 Sep 2008
See http://technet.microsoft.com/en-us/library/cc178987.aspx and http://office.microsoft.com/en-us/ork2003/HA011402661033.aspx -- Dmitry Streblechenko (MVP) http://www.dimastr.com/ OutlookSpy - Outlook, CDO and MAPI Developer Tool - "Skylark_28" <Skylark28@discussions.microsoft.com> wrote in message news:0537A8E3-A0F0-45A4-9A59-62FC98C93A9D@microsoft.com... > oops - yeah that...
Contact Us
All times are in (US) Eastern Daylight Time (GMT -4:00)