Michael Bednare...0/2 17 Jul 2012
Hi everyone, I have been trying to write a macro in Excel to achieve the following: - search for an item with a particular subject in the Outlook inbox (there will always be only one item to match the search criteria since the items are deleted after being processed) - open that particular item and copy its body to a designated Excel spreadsheet -delete the item So far, the
Bob Allen-Turl0/1 08 Jun 2012
Apologies if this has been "done to death" numerous times but never having used Outlook I need all the help I can get. The following programme was SUPPOSED to send e-mails and cc: mails through Outlook automatically. As shown on the worksheet I set it to mail two of my own addresses, one on Hotmail and one on my website. Code: -------------------- Sub SendWithAtt()
Chew Ling0/1 06 Jun 2012
Hello, I'm having a problem here. Do you know how to check whether the from field of your email has "on behalf of" when you received an email using vbscript? E.g. From: Candy(sender1) on behalf of Yohanes(sender2) The from field is not a string thus I can't find using "%on behalf of%". Can someone please help me here, as I need to complete this ASAP. Thanks.
Chew Ling0/1 06 Jun 2012
Hello, I'm having a problem here. Currently I need to calculate number of emails based on 'on behalf of'. There's multiple mailbox and the user have to choose which mailbox he/she wants to calculate. I do not know how to identify or recognized which mailbox did the user select. Is there anyway that I can know which mailbox does the user select? Please help or reply ASAP as I need it urgently!
thegoddamngman0/1 06 Jun 2012
I'm writing a macro that needs to be applied to a secondary outlook account. Hoever, when I try to run the macro, it always gives me an error message. It works fine with the primary account though, so I know it's not a problem with the code. How do I apply the macro exclusively to the secondary email account? -- thegoddamngman
Michael Bednare...0/2 02 Jun 2012
Good morning and thank you to everyone in advance for your help! I am trying to send an e-mail from a specific e-mail address in Outlook 2010. From what I have read, you can use the .SendUsingAccount to do this, however, it only accepts an object as the parameter. How do you set an object equal to a specific e-mail address. I am on a corporate network and the inbox I am sending from is
NDuarte0/4 31 May 2012
Hey, I have an exchange mailbox here and I want to poulate the subject field with some text every time someone clicks 'New Mail' Is this possible? If so, how do I do it? Google results are not very informative Cheers Tal -- Tallon
Jan T.0/1 20 Apr 2012
How can I edit the xml-file for the Ribbon in Outlook? With the new Excel format in Office 2007 and 2010, it is easy to access the xml file for the Ribbon. That is because the Excel file consist of several files, zipped together. If you unzip the files, you can edit the xml file, even with notepad. I do not have Visual Studio, so how can I retreive the xml-file for the Ribbons in
Michael Bednare...0/2 16 Apr 2012
Hi there-- I have a need to execute some SQL Stored Procedures based on the contents of email messages being delivered to a shared mailbox. I've written code and attached it to "ThisOutlookSession" and it works like a charm. The issue I'm running into is in creating a rule to run this code when messages from a specific recipient are delivered to this shared mailbox. I've created an
Max0/1 16 Apr 2012
How can I convert this string "Yadda Yadda Yadda! Yadda Yadda Yadda (123456789)" to "123456789"?
Tony0/1 10 Apr 2012
Hi, I wrote a Windows Services to access Outlook (version 2010) folder programmatically and save email in SQL database. The service reads each email in Outlook Inbox folder and get details of the emails. The service works fine with .NET Framework 2.0 on Windows Server 2003 with Outlook 2010 installed. After I upgraded the service to .NET Framework 4.0 on Windows Server 2008 (64
marshal_hubs0/3 19 Mar 2012
Prior to my computer crash, I had two 'profiles' in Outlook 2007, which seemed logical, but was actually somewhat of a pain. Using one profile for friend/general emails, and another for soccer/swim emails for the kids' teams. After the crash, I decided it's easier to combine them, and I was right, so much easier having it send/receive 6 email addresses in one profile instead of
Tessmarin0/1 13 Mar 2012
So my administrators at the office just installed some program that overrides the signature blocks for all the users for consistency. Unfortunately my group uses a shared inbox. When the inbox is used to send or reply from it does not default to the actual user and thus unless you manually change the From field or cut/paste a signature in to each email and remember to do this every
kellyhell0/1 13 Mar 2012
I currently log onto Outlook using my personal account. I also have access to a shared mailbox which is showing in my folder list. I have the following code which I cannot get to work. The bit I'm trying to sort out is the: 3. To move the item: ' NOTE: You need to first define olDestFolder where would I define the olDestFolder? TIA Sub ProcessFolder(CurrentFolder As
Jan T0/1 28 Feb 2012
Using Outlook 2007 I want to be able to get the Name of a Contact in our Global Address book in Outlook Exchange (don't know Exchange server version), optional from Excel, using vba automation, or just directly from Outlook (thisOLsession). As argument, I want to use Contact.Nickname property and have the function return the Full Name from the Global Address book. Any help would be
D Fabian0/1 24 Feb 2012
I do not have both Outlook and Exchange on the same machine and I too am getting this same error. I am running outlook 2003. > On Friday, May 11, 2007 10:16 AM gop wrote: > Environment: > -Outlook 2002(XP) > -Added references to "Microsoft Outlook 10.0 Object Library" & "Microsoft > CDO 1.21 Library" > > I have written a VB project using MS Visual Basic 6.0. My intention is to
The Writings0/5 18 Feb 2012
Hi There, Is there a VBA code that I can use to find a user created folder? A bit like serach in Windows exporer. Kind regards TW
Michael Bednare...0/3 13 Feb 2012
I have these 2 great macros from a long time ago: ********************************************************************* Sub TASK_CreateTaskFromEmail_WITH_attachment() Dim olTask As Outlook.TaskItem 'Using object rather than MailItem, so that it 'can handle posts, meeting requests, etc as well Dim olItem As Object Dim olExp As Outlook.Explorer Dim fldCurrent As Outlook.
DawnTreader0/1 06 Feb 2012
Hello All I have a system already set up to import emails fields from outlook to access and it actually works really well. but it is reliant upon access pulling the information and i need to be the one to do it. i would like to turn it around. i would like to have a little outlook addin that i can give to a few people that need it to allow them to hit the button and it would export the
Michael0/1 02 Feb 2012
I'm seeing different PR_CLIENT_SUBMIT_TIME values when I'm not expecting it. Our software depends on these times being the same, at least down to the second. Here's an example: If I send myself an email message and compare the PR_CLIENT_SUBMIT_TIME from the message in my Sent Items folder to the message in my Inbox, they are different. When my company had a simpler Exchange 2007
Michael Bednare...0/2 01 Feb 2012
i have the following code that opens a new mail and adds "UNCLASSIFIED" to the start of the subject and body. What i need is some code that will format the the body instance of the word to be bold and larger than the rest of the text that will appear in the body (organisational rules). Sub Unclass_Msg() Dim msg As Outlook.MailItem Set msg = Application.CreateItem(olMailItem) With msg
c_nixon0/1 26 Jan 2012
Hi, im new to this forum and to vba/macos but am looking for a mcro that will populate the subject line and first line of an email with pre-defined text. As an organisation we are required to send mails with protective markings such as Restricted, Personal etc. This should form the begining of the subject line and in the main body of the text. I'd like a macro that opens a new mail and
Michael Bednare...0/2 21 Jan 2012
Hello everyone, I am new to the group and just baby stepping my way into Outlook macros. I need a simple solution. I run 2003 Outlook and I need to creat a simple macro that will write a reply to a message. I intend to use this macro to reply to certain customers under certain conditions by clicking a icon assigned to the macro. This is a sample of something I like to say when I
CAN0/1 17 Jan 2012
Hello everyone, I am new to the group and just baby stepping my way into Outlook macros. I need a simple solution. I run 2003 Outlook and I need to creat a simple macro that will write a reply to a message. I intend to use this macro to reply to certain customers under certain conditions by clicking a icon assigned to the macro. This is a sample of something I like to say when I
wotme0/1 09 Jan 2012
Hi I am using a small code which sends a reply to a specified sender. I would like to add a line the reply referring to the name of the attachment, if there is one. I also want to add my signature. I have activated the signature in options to be added on a reply, but it doesnt appear. I would prefer if possible, to add the signature via code, rather than it appear on every
DawnTreader0/1 08 Dec 2011
here is a post i put in the access forums, just want to make sure i have it somewhere the right people can answer: Borrowed this code from a few different sources to try and hash something together that would run through the email folders and dump specific information from the emails to a table called tblInbox. at the moment i am trying to get it to work with just one folder with in the
Aldz0/1 09 Nov 2011
Good day to everyone. My boss in the office uses 2 email accounts in his pc (1 exchange server w/o OWA and 1 gmail). He asked me to make it so that he would be able to send emails using gmail to internal email in our exchange server when he's abroad. I found vba to be the answer but i'm currently stuck with a synching problem. The way I set it up is I send a mail using gmail to
hannu0/1 08 Nov 2011
hi. when I try to create new message in Outlook I get everytime a
Jean-Daniel Gas...0/4 14 Oct 2011
Hello, After using AddStore method, a new folder "Personal Folders" is automatically created in Outlook. Even if I rename that folder programmingly, you don't see the change until close and restart Outlook. Is there any other way? Thank you!
kevin_crm0/1 12 Sep 2011
Hi there, I want to lock down the public folders in Outlook, so no one can modify them/their contents - i want changes to be made via an Access application I have. However, if i lock down the folders, then ACCESS can't get at them... is there a way to give an active directory account permissions to the public folder(s), and then have the MS Access application "impersonate" that
Filips Benoit0/1 23 Aug 2011
Dear All, I want to export appointments from Excel to Outlook My code works OK but the user wants to export to a specific calendar named 'Promotions' and overwrite a the previous export of that month. So, delete ALL appointments of a specific calendar in THAT month and export the new appointments. 1. How to open a specific Calendar by name? 2. How to delete ALL appointments in 1
Patrick Graven0/3 05 Aug 2011
I had this code in Outlook 2003 it warned me when I sent email without attachment if it found the word attached in the email. It doesn't work in Outlook 2007, please help. Thanks. Private Sub Application_ItemSend(ByVal Item As Object, Cancel As Boolean) Dim lngres As Long If InStr(1, Item.Body, "attach") <> 0 Then If Item.Attachments.Count = 0 Then lngres = MsgBox(" Found 'Attach'
Steve Whalen0/1 02 Aug 2011
when i try to search my inbox i get results that are 6/30/11 and older...nothing from july or Aug...when I know there should be. It's like I have some kind of date range...this just started to happen in the last month or so...
HammerJoe@gmail...0/1 19 Jul 2011
Hello, Can someone help with my issue. Everytime I write an email I need to copy the FROM email (I use different mailboxes) into the BCC field to have a copy of it in the mailbox. It would be nice that everytime I create a new email or reply to one to have that done automatically. Is that possible and how? thank you.
Mickie2002060/1 28 Jun 2011
Hi Re-Posted as I can't find my original post in the group. Hoping someone can help me out here. I am using Outlook 2003 at work and I have recorded a macro but every tme I run it, the standard toolbar is disabled. The macro is a simple 'find and replace' and I was wondering if there is a line of code I can add to the macro to prevent the toolbar being disabled or any other solution.
Mick Hickson0/1 25 Jun 2011
Hi Hoping someone can help me out here. I am using Outlook 2003 at work and I have recorded a macro but every tme I run it, the standard toolbar is disabled. The macro is a simple 'find and replace' and I was wondering if there is a line of code I can add to the macro to prevent the toolbar being disabled or any other solution. I am using Word as email editor and the macro was
WhytheQ0/1 22 Jun 2011
Hello All, I use the following function in Excel to call outlook before creating an email. Using Office 2010 I'm finding that even with the correct setting in the Mail section of our Control Panel that if OL is not running when the function runs then a window appears asking to Choose Profile. I've tried commenting out the two marked lines below and it all seems to run without asking for
Samira Programm...0/4 22 Jun 2011
Hi I'm trying to something similar only instead of saving the reply I would like it to delete the original message from the inbox. Is this doable? "Robin" wrote: > Hi. I would like to create a custom action that pops up a message box on > sending an email. This will ask me whether I would like this saved to my sent > items folder or not. This will make organising my sent items much
ilona tring0/1 07 Jun 2011
is it possible to read in a loop all the items in the deleted/trash folder ? would someone have an example code snippet ? thank you.
ThomasX0/1 06 Jun 2011
I use Microsoft Outlook 2010 I request to you: if anyone can help me write a macro to save all attachments from different emails from senders "XXX" to a folder on your hard disk "c: \ aaaa" I have no idea how to go about writing a macro: ( thanks in advance for your help
knoell72@gmail....0/1 12 May 2011
hei Har nettop innstalert innboks nr. 2 i min outlook.(to forskjellige e- post adresser) Problemet er at den nye innboksen er plasseret helt i bunnen av mappe herakiet. hvordan for jeg flyttet den op og ned i herakiet. Vil gjerne ha de to innboksene ved siden av verandre.
Mike babb0/1 04 May 2011
Hi All, I've built a Microsoft Access 2010 application that imports data from my Outlook 2010 email account. My email is an exchange email account. I'm connecting to the account through Outlook (the mailbox store) and not to directly to the exchange account. In a nutshell, the program imports email, appointments, contacts, notes, and tasks into several tables in Access. It's a very
cinnamngrl0/1 21 Apr 2011
I would like to run a macro on my address book that would search and scrub corrupted info that is fouling up my ability to sync my email address with my blackberry. I did some work on the blackberry side but I realized that my outlook was unable to export all of the entries to a txt file to look at. there isn't any "iscompliant" function, so would be the suggested steps? I have
ozzy nax0/1 21 Apr 2011
hello i just uninstalled my office 2007 and installed a clean copy of office 2010. (my macros are enabled) i am running into the same recent problem as with outlook 2007. i hadnt until a week ago. as i start outlook, i get an error "microsoft visual basic." -- file not found error. with alt-f11 i get into the vba window however the window is empty with no outlook session, or project.
Jay Brigand0/3 12 Apr 2011
Is there any way to check via VBA if the recipient is a specific group or keywords before sending any email to bring up a pop-up saying "Are you sure you want to send this message to a group" Saving you lapse in picking the wrong group to send emails to. Outlook 2007 - Exchange 2003. Thanks in advance.
anne0/1 11 Apr 2011
in the course of a normal day, I need to filter out all messages coming from multiple senders with "Sent of Behalf of" how can I read that from MailItem ?
Graham Mayor0/2 09 Apr 2011
I'm trying to copy from the clipboard using VBA and Excel. When I run the code you have here is get an error: Compile Error: User-defined type not defined. This is on the command -Set MyData = New DataObject ?? > On Sunday, January 28, 2007 7:47 PM And wrote: > An unusual one this one but please read on. > > If I manually copy a range of cells from an Excel worksheet and then
Graham Mayor0/4 06 Apr 2011
All of our office systems were upgraded from outlook2003 to outlook2007 I used to run for each incoming email, a short vba code that would simply log the headers to a drive but can't remember now how I initialized it? Can someone help me? Basically, I want to run a simple piece of vba code, similar to snippet below and have this run for every incoming email I inserted the code
Thomas Hochreit...0/1 05 Apr 2011
Hello *, I need help to start a macro at outlook 2010 at a specific time, e.g. 1:00 am. I just found the "OnTime"-function for Excel but I did not find anything how to do in Outlook. Outlook is running 24 hours/day so I cannot use the Application_Startup() possibility. Thank you for any ideas. Best regards Thomas Hochreither
Al0/1 02 Apr 2011
Hi, I am involved with two business. One has there own exchange server and its very locked down. I am a mere user on this server and have absolutely no permissions as a admin to change anything - nor are they likely to respond to a request for any such changes. I also have my own personal Microsoft Exchange Online account (BPOS). I am wondering if there is a way, I can make a calendar