ThreadLast AuthorMessages
read/total
Date
display sender name using contact list info
roberto21
0 / 3 19 Oct 2010
On 14 Ott, 20:54, "Ken Slovak" <kenslo...@mvps.org> wrote: > Please note that this is a group for programming questions. Outlook usage > questions can be posted in the forums athttp://social.answers.microsoft.com/Forums/en-US/category/officeoutlook > > -- > Ken Slovak > [MVP - Outlook]http://www.slovaktech.com > Author: Professional Programming Outlook 2007. > Reminder Manager, Extended...
Form with button "imitating" arrow up/down
Andreas
0 / 3 19 Oct 2010
Hello Ken, > Probably about the best way, and it's a total hack that I find really ugly, > would be to use SendKeys and pass along the up or down arrow keys. It might in fact be a ugly hack but works fine for me!!! Thank you very much!!!! Andreas...
change font size of incoming emails
Ken Slovak
0 / 6 18 Oct 2010
That sounds like the Document is locked for editing. If you cannot unlock it you won't be able to use the Word object model on the Document object. If that won't work then you might have to parse the HTMLBody property and look for where the font size is defined and change it there using text and string parsing functions. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com...
Problem automating Outlook in Windows 7 from VB6 and Access
Ken Slovak
0 / 11 14 Oct 2010
I misunderstood what you were getting at. I thought the problem was when starting your app directly versus via a batch file. So it's how Access is started, and then the Access code starts Outlook. OK, I understand now but I'm still mystified. Other than the security aspects that were already discounted I can't think of any reason for what's happening. -- Ken Slovak [MVP - Outlook]...
How to copy files from a file server to public folders in Exchange server t...
Ken Slovak
0 / 2 13 Oct 2010
Outlook folders hold Outlook items. You can instantiate a DocumentItem, but I never liked the way those objects worked and they're not well supported for 2007 and later (you don't mention your version, which would have been helpful). You could also attach documents to items stored in Outlook folders. The real question is why do you want to store documents in Outlook/Exchange, where...
open appointment item - how to change time?
news.chello.at
0 / 6 11 Oct 2010
hi - ok, now I've got it... .... For Each mInspector In myinspectors If mInspector = ActiveInspector Then Debug.Print mInspector.Caption End If .... Thank you!! "Ken Slovak" schrieb im Newsbeitrag news:i8vs2j$n6m$1@news.eternal-september.org... ActiveInspector would be null if no item window was opened or nothing was active. If you activate an Inspector it...
Emails returned when sent initially - ok if resent
Ken Slovak
0 / 2 11 Oct 2010
Please note that this is a forum for programming questions. Outlook usage questions can be posted in the forums at http://social.answers.microsoft.com/Forums/en-US/category/officeoutlook -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007. Reminder Manager, Extended Reminders, Attachment Options. http://www.slovaktech.com/products....
Unique ID in outgoing mail, that can be found on the exchangeserver later...?
Dag Sunde
0 / 3 05 Oct 2010
...
automating outlook address book from Word
Ken Slovak
0 / 4 05 Oct 2010
Use NameSpace.GetSelectNamesDialog() to get a SelectNamesDialog object and use that to get back one or more recipients. -- 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 "Liz" <lgewirtz5@yahoo.com> wrote in message...
Sub or function not defined
gkoliver
0 / 3 04 Oct 2010
...
Help Customizing a Macro to send an email encrypted
Mr.Frog.to.you@google...
0 / 2 30 Sep 2010
Have you tried: Sub encypt() Set objItem = Outlook.Application.ActiveInspector.CurrentItem objItem.Subject = objItem.Subject & " <ENCRYPTED>" objItem.Send End Sub Its just swapping the ENCRYPTED label to the end of the line. The & symbol basically adds to strings of text together (concatenation). The objItem.Subject is a text 'field' (property actually) of the currently selected...
This is Vegas - Get $2400 Free
http://thisisvegas.co...
0 / 1 14 Sep 2010
This is Vegas - Get $2400 Free http://thisisvegas.com/get/a/179639 Click here to download over 400 Free Games http://thisisvegas.com/get/wd/206052...
Redemption with ReplyTo Using Template
ds sd
0 / 8 13 Sep 2010
My current project requires ability to display choice column value via color or image associated with a choice But Sharepoint standard packaged misses that control I am looking for available solutions on market I came across http://sharepointfields.com> Does anybody has experiece using it?...
Are you still pay a lot when using Microsoft Exchange Server?
lala chen
0 / 1 10 Sep 2010
As we know, Exchange is a very demanding solution, and in many if not all cases requires a dedicated engineer for maintenance. Everything is OK if you are working in a big company. However, to some small company, it will cost a lot to them. Just leave it behind and consider WinPST, which has the exact functions as the exchange server but only charges you a little money. Sharing Outlook...
Standardized telephone format
Ken Slovak
0 / 2 07 Sep 2010
No, there's no function like that, you'd have to write one. It wouldn't be difficult at all, just get the ASC() value of the string character at a position and compare it to the ASC() values of 0 and 9. If it's between those it's a number. Anything outside that range (48 to 57) is something else. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional...
Sending email from Access or MySQL address list
Ian Millward
0 / 3 04 Sep 2010
Bruno, Many thanks for that. It should get me up and running. Ian Millward Edinburgh "Bruno Campanini" <BC@gmail.com> wrote in message news:4c82d8fe$0$31384$4fafbaef@reader1.news.tin.it... > "PhredBear" <ThisIsNotMyAddress@yahoo.com> wrote in message > news:q_-dncm8GrTt3x_RnZ2dnUVZ7rmdnZ2d@posted.lumison... >> Hi there, >> >> I would like to use Outlook to send out a...
Accessing IMAP Gmail account
Bruno Campanini
0 / 3 03 Sep 2010
>Ken Slovak" <kenslovak@mvps.org> wrote in message >news:i5qvo1$mdp$2@news.eternal-september.org... > Please note that this is a forum for programming questions. Outlook usage > questions can be posted in the forums at > http://social.answers.microsoft.com/Forums/en-US/category/officeoutlook Read well before replying! I'm in the right site and that's the answer to my question: Dim...
how to sort groups by date?
Ken Slovak
0 / 2 03 Sep 2010
Please note that this is a forum for programming questions. Outlook usage questions can be posted in the forums at http://social.answers.microsoft.com/Forums/en-US/category/officeoutlook -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007. Reminder Manager, Extended Reminders, Attachment Options. http://www.slovaktech....
Refresh IMAP folder list automatically OUTLOOK 2010
carl2222cc
0 / 1 01 Sep 2010
Beginner, want to do simple task in Outlook 2010. Macro will run in Outlook, not from elsewhere. 1) Do Send/Receive IMAP email account only....let's call it "dog" 2) Do an UPDATE FOLDER LIST. Same as when you right click your IMAP account and select. So far figured out the Send/Recieve, but does not do anything...doesn't bomb either. Tried it for "All Accounts" too. Here is...
Help with Assigning Existing Group IDs to Group Members
robboll@hotmail.com
0 / 1 30 Aug 2010
Problem: Assigning a pre determined ID to members of three groups. Given --Three Groups: Group1 (members 1 thru 7) Group2 (members 1 thru 5) Group3 (members 1 thru 4) Their corresponding (but unassigned) IDs are: G1_1 G1_2 G1_3 G1_4 G1_5 G1_6 G1_7 G2_1 G2_2 G2_3 G2_4 G2_5 G3_1 G3_2 G3_3 G3_4 Whenever each member of a group gets selected he gets assigned one...
Outlook generates error when accessing rules - Please help.
Dennis Macdonald
0 / 2 18 Aug 2010
PS - Outlook 2010 is being used....
VBA programer
Dennis Macdonald
0 / 2 18 Aug 2010
We offer such services via consulting service from Australia. We have performed this function for many international clients before and they are very happy. Reply directly if you are interested....
Cursor location in email item
Ken Slovak
0 / 5 18 Aug 2010
Use the Selection object, which is a Range object. -- 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 "Gabriel Fineman" <gfineman@advsol.com> wrote in message news:201081814112usenet@eggheadcafe.com... >I am using Outlook 2007...
Printing Tiff/JPG attachment
syed rizwan shah iqbal
0 / 5 17 Aug 2010
Hi i know the top post is so old but i use that example and doing batch print from outlook using VBA code. My Code is: Dim blnPrinted As Boolean blnPrinted = False Dim strCommand As String strCommand = "C:\Program Files\IrfanView \i_view32.exe " & vstrPathAtt & "/print" Shell strCommand, vbHide 'Sleep 10000 blnPrinted = True Finally:...
Macros not showing when trying to Customise toolbar
freeman642@gmail.com
0 / 1 13 Aug 2010
When you right click the toolbar select "Customise" then select the "Commands" tab then select "Macros", no macros appear in the right hand window, but when you go to tools and Macros there are all the macros listed?!?!?!? Also when I add a button to the toolbar using code in the application_startup event it doesnt work. On a network of 130 PC's this is only happening on 2 of them so it is...
Vbscript sends e-mail via Vista/Outlook 2007, but mail stays in Outbox until ...
Ken Slovak
0 / 2 11 Aug 2010
For 2007 you will need to display an Explorer. Get a folder like Inbox and use the GetExplorer() method, then display it. That will let the items send. -- 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 "leom" <leo@systemetricsinc....
Macro to recode midnight appt as All Day Event
DrBrock
0 / 1 08 Aug 2010
Greetings all: I have some basic familiarity with VB, mostly in the Excel environment. I imported some calendar items a few years ago from an old program. All of the "all day" events imported to midnight. I would like to run a macro that finds every appointment that starts at 12:00 am and recodes it to an All Day Event. Any assistance greatly appreciated. drbrock --...
Show Message Count in Group Header
acsg
0 / 3 05 Aug 2010
...
Outlook saves sent messages when it is not supposed to
Ken Slovak
0 / 2 03 Aug 2010
What needs to be done is to set a property on the mail item before it's sent, DeleteAfterSubmit = true. That will delete the item rather than put it in Sent Items after the item is sent out. The SaveSentMessageFolder property, which is set to a MAPIFolder, will save the item to the specified folder instead of to Sent Items. Either property can be set using VBA code, or in the...
Macro & buttons to reply Dear ..., Regards ...
Ken Slovak
0 / 4 02 Aug 2010
For that I'd use Instr() with a search for a space. Any return value greater than 0 indicates a space was found and where. There may be more than one space, but the first one will be returned. -- Ken Slovak [MVP - Outlook] http://www.slovaktech.com Author: Professional Programming Outlook 2007. Reminder Manager, Extended Reminders, Attachment Options. http://www.slovaktech....
Automating Paste In Outlook 2007
Neil
0 / 11 30 Jul 2010
Thanks, Ken. I'll give it a shot. Neil "Ken Slovak" <kenslovak@mvps.org> wrote in message news:i2rv1i$dhu$1@news.eternal-september.org... >I would set up a a more global Outlook.Application object and check it and >only instantiate it if it's nothing. In the initial code when Access is >started I'd put Set objOutlook = Nothing. Then I'd set it and check it >whenever I needed to...
Macro & buttons to reply Dear ..., Regards ...
Mark
0 / 1 29 Jul 2010
Thanks to members of these board for help in creating this For the sake of anyone else who wants to play with it, the following is what I came up with and it works for me, but no guarantees for anybody else. I have put buttons on my task bar. Actually I have a few: Dear, Reply_all, Hi, Hello, Many thanks. All have differing salutations etc. I've also added shortcut keys to the most...
macro to reply sometimes fails - why?
Mark
1 / 10 29 Jul 2010
Thanks all for your help. For the sake of anyone else who wants to play with it, the following is what I came up with and it works for me, but no guarantees for anybody else. I have put buttons on my task bar. Actually I have a few: Dear, Dear_reply_all, Hi, Hello, Many thanks. All have differing salutations etc. Dear_reply_all uses Set NewMsg = myItem.ReplyAll...
Yes
Rich Fiekowsky
3 / 3 29 Jul 2010
I do it, but each machine has to install your certificate as a trusted certificate. In some companies that might be considered a security hole. IMO, if they trust your code, they may as well trust your certificate. Also, each new release of Excel twists this process a new way. And of course it may vary on different releases of Windows - I do not know. Details are all over the web....
Insert First Name in Reply
Ken Slovak
2 / 4 29 Jul 2010
Would you want it to be more automatic or do you want the code only to run from a button? -- 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 "Brian B." <brianblanchett@gmail.com> wrote in message...
Mail merge from Word saving emails to Drafts
Ken Slovak
0 / 2 27 Jul 2010
Anything other than that behavior would require you to code the merge yourself using Outlook and Word automation code. You couldn't use the built-in merge. -- 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 "TWrench" <thomas....
How to set the Email address in the To field with MailOpen Event
Mark
0 / 4 22 Jul 2010
...
How to capture contacts 10 times faster from Outlook?
Dhan
1 / 1 22 Jul 2010
Generally small business owners and sales & marketing professionals receive leads from various sources like emails, web pages, online directories, and customer and sales enquiries. They spend a majority of their time in manually copying and pasting each and every contact detail into the respective fields of the contact database.AddressGrabber uses its patented contact capture technology...
Insert File As Text Using Automation
Ken Slovak
1 / 2 21 Jul 2010
You would need to read the file as a text string and insert it into the item's Body or HMTLBody. That's what that command does for you. -- 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 "Neil" <neil.ginsberg+newsgroup@gmail.com>...
Saving attachments from encrypted email
Ken Slovak
1 / 2 15 Jul 2010
There's nothing that you can do with Outlook code with encrypted messages. -- 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 "PDAlma" <juvey@icpnet.pl> wrote in message news:i1mpnu$4g9$1@opal.icpnet.pl... > Hello! > (Outlook...
Make use of Events in Outlook
Ken Slovak
0 / 10 09 Jul 2010
Ah, spelling and typo errors. That makes sense now. -- 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 "Jan T." <noreply> wrote in message news:aqqdnYv0m_D-a6vRnZ2dnUVZ_g6dnZ2d@posted.comnet... >I found out what was wrong I think....
Send All emails in Outbox and Quit using VBA
Jan T.
0 / 4 07 Jul 2010
What error do you get? If you use Create object, using late binding, you must make objOutlook an object. Same for objCB. Comment out your error trap so you can watch eventual error code or description to see what is going wrong. You probably still have to check you buttonID because i don't know what is the right code her. Try someting like this: Public Sub SendReceiveNowDev()...
Outlook saves sent messages when it is not supposed to
Frank
0 / 4 01 Jul 2010
I have tried changing the .oft file with the subject line being vuvuzela but it does not work either....
Outlook 2000 programically Permanently Delete mail, how to?
steve
1 / 1 29 Jun 2010
I want to create a menu item to permanently delete mail. I'm not a vba person per-say although am familiar with how to create a menu item once a macro is create, and how to enter data into a macro. Often I just use the MS word record macro and then make a few changes to it to do what I want. Having said that can someone give me the code to delete a selected mail message. eg I...
Outlook 2007 'section1' style
chappers77
0 / 1 25 Jun 2010
Hi One of our users is having an issue when replying to external emails. The email comes in and the formatting is fine, the user then replies and all seems to be OK until she looks at the sent email and all text has been changed to Times New Roman instead of Calibri. I have checked the users font settings and all are corrently set to use Calibri (no +Body etc). After a net search I...
Insert NAme and jod title in Body of the mail
wolfman.mahesh
0 / 1 24 Jun 2010
Hi !!! i am a total amateur where coding is concerned here is what i need i need a macro that will run automatically when a mail is sent wherein the recipient name job title company name is inserted in multiple places in the body of the mail... the name, job title and department should be retrieved from the contacts the subject and the rest of the body of the mail remain the...
Outlook macro - new email - how to set font
Ken Slovak
0 / 4 17 Jun 2010
The best way to see what to do is to view the existing HTMLBody property in an email formatted the way you want. Select an email like that in the folder view and then open the Outlook VBA project (Alt+F11). Show the Immediate window if it's not open and enter the following there: ? Application.ActiveExplorer.Selection(1).HTMLBody Place your cursor in that line and press Enter to...
Outlook add-in that captures contacts from email, web page and documents and ...
Dhan
0 / 1 11 Jun 2010
Are you are looking for an effective way to automate capturing contact information from e-mail signatures, web pages, online directories or documents, we have a Software for you.AddressGrabber uses its patented contact capture technology to identify contact details such as First Name, Last Name, Company, Address, City , State, Zip, Phone, Fax, e- mail address, web site and transfers them...
Why Does GetObject Create New Instances of Outlook 2007+
rob
1 / 2 08 Jun 2010
rob wrote on 06/07/2010 11:39 ET : > I'm using GetObject to automate an existing instance of Outlook using VBA from > Excel to open the address book and allow the user to select a group of > recipients. > > When I do this with Outlook 2007 or 2010 an new Outlook window is opened each > time the code is run. If I quit the instance of Outlook I'm holding then > Outlook is shut down...
Simple hack to get $500 to your home.
SUHASINI
0 / 1 06 Jun 2010
Simple hack to get $500 to your home at http://mastidunia.tk Due to high security risks,i have hidden the cheque link in an image. in that website on left side below search box, click on image and enter your name and address where you want to receive your cheque.please dont tell to anyone....
Contact Us
All times are in (US) Eastern Daylight Time (GMT -4:00)