HenrikH0/1 07 Sep 2010
How do i get Excel to show an Outlook Group Schedule from a users Calendar in Excel using VBA?
Ken Slovak0/2 27 Aug 2010
Okay, I'm working on a project that is totally kicking my butt and makes me want to throw in the towel. I would appreciate your thoughts, advice, guidance, code, suggestions, etc with this. My boss has asked me to develop an database in MS Access 2010 in which he will create his Weekly Plan. There are forms for Weekly Notes, Daily Notes, Weekly Budget Notes, and Calendar Items. He
Ken Slovak0/2 27 Aug 2010
I'm trying to write to an Outlook Calendar item user property. The calendar is the local user's calendar and not a public calendar. The purpose of writing to the calendar item is to later read that value back... which seems obvious I guess. It can be an item property or a folder property, I don't care. When I write the value, there seems to be no problem, but when I read the value
Ken Slovak0/16 25 Aug 2010
Whoops! I posted this earlier in the wrong newsgroup: I am writing a routine that will Outlook Appointment items and write them into a database. When an item is recorded, I write the ID created in Access into a custom field in the appointment item. This is kinda working, but there are some strange issues. I have 22 items in the Calendar. My filter is looking for the past 10 days
HOOVERJeannette...0/3 20 Aug 2010
Hi all, I have here Outlook XP / 2003 and 2007. I must check some emails for embedded images. I have found a example code to get the cid over cdo but it work not completly. I have the message id from the selected message but I become no resoltes from the GetMessage. Can me help someone please. Big big thanks for help. Best regards, Tora Sub check_CID_with_CDO() Dim
freeman642@gmai...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
nagamalleswari0/2 09 Aug 2010
My goal is to access my Microsoft Outlook Calendar from a C# program. If you know VB I can work with it. I started with: http://stackoverflow.com/questions/90899/net-get-all-outlook-calendar-items and wrote the following: --------------------------------------------------- Microsoft.Office.Interop.Outlook.Application oApp = null; Microsoft.Office.Interop.Outlook.NameSpace
Ken Slovak0/4 02 Aug 2010
Sorry all, there is a bug. I didn't test it on enough of my email before getting over enthusiastic. The following line of code does not work, so it is useless at this point. If myItem.SenderName, " " Then Obviously I am just a beginner. Somehow I need to have it check if it contains " ". Or alternately if it does not contain " ". I've run out of time for now. Sorry Mark
Mark0/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
Steven0/1 19 Jul 2010
I have a user who often closes Outlook by accident after reading an email. I checked the Quit event, but it doesn't have a Cancel option. I noticed, however, that if there is unsaved VBA code in an Outlook project, the user will be prompted to save the code or Cancel. If Cancel is chosen, Outlook doesn't exit. Is there a way fool Outlook into thinking a VBA project is unsaved,
Ken Slovak - [M...0/4 28 May 2010
Is there code to set a Follow Up Flag for "Call", "Read", etc. for a task or mail item? I know how to flag a mail item as a task with a date, etc. but not how to do custom flags, etc. Thanks!
Rolf G. Bercht0/9 15 May 2010
Hello all, I'm having trouble sorting an items collection. I'm sure that this is a coding issue, but I don't know how to properly resolve it so I'd like your help. What I believe to be the issue is my items collection variable, mItemCollection, is not declared as items, but then when I declare it as such, my other code before it fails. I very much appreciate any help you can give
Ken Slovak - [M...0/4 14 May 2010
Hi, How can I write a macro in Outlook 2003 to perform the menu command "Edit/Paste Special/Text"? Regards M Shafaat
Ken Slovak - [M...0/2 12 May 2010
is it possible to link an email item to bcm programatically? any tips or sites? i haven't seen anything on public.outlook.bcm thanks mark
gkn0/1 04 May 2010
Is it possible to set up a rule that exports a mail message as it comes in into a csv file? If so, how would I do that?
ajkessel0/5 04 May 2010
In Outlook 2007, I had a keyboard shortcut to expand and collapse grouped mail. There doesn't seem to be a way to define that in Outlook 2010, but I thought I could at least set up a macro. Much of the sample VBA code for Outlook 2007 and previous versions doesn't seem to work at all. Can anyone suggest a simple script to "expand all" and "collapse all"?
Russ Green0/2 03 May 2010
I've seen lots of discussion on this but no answers. I have an addin (VB.NET and VSTO) that strips attachements from emails as they are sent. Trouble is, I don't want to strip attachement (usually images) that are within the body of the message. I quite often paste images from the clipboard into my HTML messages and these need to be retained. So when looping through the attachments
Michael Bauer [...0/4 03 May 2010
Hi there, I was wondering if you can give me any information on how I can do this. I am not familiar with VBA programming but have written simple excel macros in the past. I am not sure how to begin or what the best resources on the web to do the following task. Every night, I would like to export all contents of a single folder "XXX" into a single .csv file and then move the contents
rventuradiaz0/3 26 Apr 2010
I try to update appointment's start and end date. On trying to change .start property then error occur. Would you please help me to fix the error or find an alternative solution please? Thanks Rafael The code is below: Dim olAppt As Outlook.AppointmentItem Set olAppt = objSubCalFolder.Items.Item(Subject) Set myRecurrPatt = olAppt.GetRecurrencePattern myRecurrPatt.
rventuradiaz0/3 23 Apr 2010
I am trying to create and add UserProperty in a calendar's subfolder. Code for creation works fine. However when I develop and debug code for checking UserProperty, I found nothing was added. ¿Would you help me to solve this issue, please? I used the following code for set meeting: BEGIN *************************************************************************** Dim olAppt As Outlook.
Ken Slovak - [M...0/4 20 Apr 2010
I am trying to save the body of an email to a text file using vba code Would someone kindly post the code so that I can use it as a worked example I'm using WinXP and Outlook 2003 Regards & TIA
alan parker0/1 15 Apr 2010
adding item.body="" seems to keep it.! .Body = "" .HTMLBody = some htmlcode nan wrote: losing mail body content after close event of mailItem 17-Aug-07 Hello, I have a mail item and I tried to add some text to this mail item by the following code OutLookApplication = new ActiveXObject("Outlook.Application"); MailItem = OutLookApplication.GetNamespace("MAPI").
Dmitry Streblec...0/3 24 Mar 2010
Due to space limitation with my exchange server I move mail older than a month into a pst file via a vba macro. I would like to move the Search Folders as well but can't find the syntax to copy a search folder. I'm using Outlook 2007, can anybody help? Thanks.
Ken Slovak - [M...0/6 23 Mar 2010
i develop a VAR application that sends emails on behalf of the user (using outlook automation usually via outlook redemption). An increasing number of customers are coming up with an error (0x8000405 unspecified error) when same program tries to instantiate a richtext object while emails are still in the outbox (or in drafts folder). Or at least that is my initial diagnosis. The
Ken Slovak - [M...0/2 10 Mar 2010
hello every one, I want to know if there is a posibility to check the timestamp of the "Reply at:" With kind regards Raul
Dmitry Streblec...0/2 08 Mar 2010
I have a question, I'm searching around looking for a good example or thoughts someone has on programmatically mounting PST files. My case example, I have users who travel a large portion of time, and because of the lack of limitations on the size of mailboxes in my organization, the users utilize PST files that can reach upwards of 5G. That being said I was presented a solution to
Black Pete0/7 03 Mar 2010
I have written a macro for Outlook 2010 to modify received messages. I works fine for all formats except rich text but that is the only place I am using the Word Editor. I am modifying an open message and I see the changes take place when using insertbefore. When I try to save the message (objdoc.save) I get a prompt for a file name of attachmentX.docx. The same thing happens if I try to
Graham Mayor0/7 22 Feb 2010
I want to take follow up action on files created /modified by me.So,I want to automatically create an reminder in outlook whenever I create/modify files in Word/Excel.The reminder should be 1 month /15 days from the date of creation/modification of each file.This action may be done in background or with our knowledge.That is, whenever I save a file,an outlook window may pop out so
Michael Bauer [...0/17 19 Feb 2010
I am having the same trouble with this. What I am trying to do is use the .SendUsingAccount property to send an e-mail from an Excel module using a non-default Outlook account. Environment is: • Vista Ultimate 64-bit • Office 2010 Beta 64-bit • E-mail setup is Exchange, NOT POP3 or SMTP • E-mail is setup so my profile has full access to the mailbox “AutoReports”. For
Ken Slovak - [M...0/2 17 Feb 2010
Can I get a dropdown menu of various titles to appear in the subject line of a new email when a particular send to address is selected? -- robzrob
Brian Tillman [...0/2 17 Feb 2010
I created an html signature and i would like to use in several clients. Is this possible and if yes i can i do it ? SA
Graham Mayor0/13 16 Feb 2010
In developing an application for Word which sends e-mail messages using Outlook, I came across an issue that I have not been able to resolve. Hopefully someone will have a plan :) With Outlook's options configured to spell check the message before sending, each message processed creates the message 'Word finished checking the selection. Do you want to continue the remainder of the
Doug Robbins - ...0/10 16 Feb 2010
Based on Sue Mosher's code at http://www.outlookcode.com/codedetail.aspx?id=1333, the following code, which is located inside a With ActiveDocument - End With construction, works fine in Word 2007: Set objDoc = .MailEnvelope.Item With objDoc .To = strEmail .Subject = strSubject
M0/17 10 Feb 2010
Hello: I created a VBS script using CDO to look at all the items in a particular Exchange mailbox calendar between a specific date range. I've almost got eveverything working, but one thing I noticed is that all day events which span several days actually consists of only a single entry in the calendar. Outlook is smart enough to show the event spanning several days, but it only
jason0/3 09 Feb 2010
thank in advance. i am using the below code referenced directly from msdn (http:// msdn.microsoft.com/en-us/library/aa171307(office.11).aspx) but it does not seem to be working. I created and placed in a class file as directed. any help on (if there exists) a simpler way to code this or a way to get this work would be a great help. thank you! ------- Public WithEvents
Sue Mosher [MVP...0/2 09 Feb 2010
I have edited my main appointments form, how do I copy this edited form from my Outlook to other machines? Can I export and import an edited form? If so... how do I do it? Thanks M
JP0/4 09 Feb 2010
I have one PC in my network that is not firing the Application_Startup event when opening Outlook. I have checked it is not disabled and it has vba installed. I have tried running the vba code on its own and it works fine, but I cannot get it to fire automatically on opening, I have 110 PC's this runs fine on, except this one. Any ideas gratefully received? This is driving me mad.
JP0/4 08 Feb 2010
Since I cannot add "File As" options, I would like to find a way to set the File As field to (Company) First Name Last Name or First Name Last Name (Company) Is there a way/code to change the File As field to one of the above through code after someone enters the name or company name?
Sue Mosher [MVP...0/2 08 Feb 2010
Hello, I have a macro that finds all the information that I need, but I don't know how to get it to put the info into text boxes on a modified appointments form. what syntax do I need to use to refer to my text boxes? Thanks m
Michelle0/1 08 Feb 2010
Please ignore this, just setting up
JP0/5 08 Feb 2010
Him I am creating a spezific taskrequest formular. The Due-Date was set outomatic by Item.DueDate = Date + 14 How can i automatically activate the reminder option when the recipient accept the Task I used the folowing code: Item.ReminderTime=Date + 14 Item.ReminderSet=True But it doesn`t work. When i send the Task i get a message which says "the reminder is
Dmitry Streblec...0/6 03 Feb 2010
Hi Guys, I have a problem getting the the value of a ItemProperty which exists (you can see it using OutlookSpy or displaying the column in the mail grid (Customize current view / Fields / New Field) but I cannot get it when iterating through the ItemProperties or UserProperties collection on the Outlook.MailItem object. ALTHOUGH I can overwrite the value by creating a a new
Dmitry Streblec...0/2 03 Feb 2010
Help! I'm getting this error whenever I run any macro. I'm using Office 2003 Small Business and have upgraded it with the latest updates. I have a few dozen macros in a VbaProject.OTM file, which I have deployed to about 50 users simply by copying the OTM file. It is failing only on one user, and it worked for him for about a year before it failed. I have tried re-copying the OTM file,
M0/3 01 Feb 2010
I need to create a vbs or vba script to be scheduled as a batch job to send a specific file to a given recipient every night. Outlook 2007 is installed on the Windows XP Pc where the script should be scheduled, but no user interaction is available (the script should be scheduled to run during the night). The message should be sent via an SMTP server as no Exchange server is available.
andre cloete0/12 22 Jan 2010
Hi: I already have some macros which move emails to predetermined folders and these macros are run with a keyboard shortcut. It works fine. I'd like to write a macro which will do the following: When I close an email (and go to the next one), I'd like to move the email I just closed to folder xyz. So if i did not flag the current email or move it to another folder, I want my macro
bobh0/1 21 Jan 2010
Hi, I'm hoping someone can help me understand what is going on with the following senario. I have posted this in the Access forum but have not recieved any replies so I thought I would try here. I have AccessXP with Outlook2007 and this vba code on a form in Access which sends an email, with Outlook 'closed' this code works as long as I attach a file. If I comment out the .
JP0/2 19 Jan 2010
Hi guys, Just wondering if anyone has any code or knows of any code for a vba or some sort of program to 'hide quoted text' in emails the same way gmail does it?? this way emails people send in reply to emails will only have the latest reply and not all the quoted text... Cheers
Sue Mosher [MVP...0/4 18 Jan 2010
OK, I'm try-and-erroring the following code to help me with keepingmy SentItems Box clean. After clicking the send button, I created a message box to ask me if I wanna delete the e-mail. YES will set the SaveSentMessageFolder as a subfolder "delete" in my SentItems box, which I can delete without looking at each mail again. NO should start further analysis of the RECIPIENT and set the
tyralia0/4 14 Jan 2010
Hello, What I'm after, is for a way to remove certain address from the "To" field whenever I hit reply-all to any message. Any ideas would be appreciated. Thanks!
Dmitry Streblec...0/5 11 Jan 2010
Hi, I have a requirement to drag and drop outlook items to my desktop application in java. In the drop event, I am getting only the message subject and nothing else. Is there any way I can get the mail item? As an alternative, I tried to copy the mail item to a temporary location on dragging the item from Outlook, but unfortunately, there is no event to handle for dragging the mail