Ian Letters0/1 04 May
I am trying to send emails using VBA but using an email account in Outlook 2010 The following code has been working find for sending emails using our Exchange Account in Outlook but when I try to use another account in Outlook 2010 it doesn't. I am not an experienced programmer in VBA but can using work my way around things. The code pasted below is what works fine: The .SentOnBehalfOfName =
Jimmy Chen0/1 23 Apr
Hi there this VBA code works with Outlok 2007 and Windows 7 + XP 32bit. I have just upgraded a PC to win7 x64 and it's not working I receive a "compile error" User-defined type not defined when I try to compile. It's a outlook 32-bit install on Win7x64. I'm not a programmer so I can't figure it out, I've attached the original code below. Thanks in advance. Private Const
Dave0/1 17 Apr
I am opening a userform in outlook and would like the subject to show in a text box, Something like... Private Sub UserForm_Initialize() TextBox1 = Subject End Sub So when I show the Userform, the textbox will diplay the open email's subject. Thanks
For example, I want to show a userform and display the textbox as what is in the email subjct box Private Sub UserForm_Initialize() TextBox1 = thisemail.Subject End Sub Thank you
McKilty0/1 16 Apr
I am looping through sent and received emails and pulling the contact names from each. What I would like is for the name to be what I have in my contacts for that person, rather than what may appear in Suggested Contacts or what the user has chosen his display name to be. For example, I have a contact named Tom Steele who is filed in my Contacts as Steele, Tom. He also happens to
bobh0/1 03 Apr
Hi All, Anyone have vba code they will share that will get the smtp email addresses from Outlook2007/Exchange global address book and add them to an Access2003 table or just output them to a delimited text file? I want to display that list in a combobox on an Access form. Linking to Outlooks/Exchanges global address book directly from Access2003 thru an odbc connection does not display
Rob Samuels0/1 30 Mar
I'm running Office 2007. When I receive an email from a new prospective client. How do I export the single new contact into the client table within an Access DBMS using VBA?
J0/1 20 Mar
I am using Google EarthLib from Access 2010 I can't find an item in the object catalog to hide the sidebar Someone knows how to do it? Regards Juergen
Oren L0/1 06 Feb
Hi All I need some VBA script, and I can't find. How I wish it to be: 1. Select email 2. Click on button that activates the script 3. Popup window will appear with text search input 4. As I type all relevant folders will appear below 5. I will click the wanted folder 6. The email will moved to that folder. How can I find help on that ? Thanks in advance Oren
steeve_dun0/1 21 Dec 2011
Hi all, I want to send via Access and using outlook (VBA) a message containg radio buttons and text areas that can be received back and stored in access. Reading several posts, I can't decide wether to use : html content containing html forms (but my form are displayed correctly in web browser but not in outlook ! ) Word form ? (but how to do this?) other sollution ? Any help
Tony C.0/1 08 Dec 2011
Hi I'm a newbie to Office development but not dot.net. Is it possible to send appointments created in one program to show up in a user's outlook calender who uses Exchange Server? -I'm looking for someone to point me in the right direction.... (I would need to send appointments to different users, presumably with their security credentials etc in order to get it to show up
bill0/1 16 Nov 2011
All, Roughly a year ago I created "something" that runs in Outlook and will send an email periodically if the circumstances are right. Well, it works just great. I get the emails that I expect on a regualr basis. Unfortunately, now I CANNOT FIND the code!. When pressing Alt F11 and checking thru the project, it just is not there. I spent an hour or two today trying to remember what
duadinam1/1 08 Oct 2011
Hello, I'm working on a VBA application to log email correspondances in a spreadsheet. I would like to be able to export email conversations along with dates, and other ppl involved in the conversation in a spreadsheet. Anytime an email is sent to or from select address Outlook will update this spreadsheet. What is the best way to go about this? Is this possible and what API's,
sleepyrajesh1/1 16 Sep 2011
Hi, Whenever we attach a '.MSG' file from Outlook, its extension doesn't appear. Whereas if mail is sent to outlook from mail client other than Outlook , the file's extension is displayed. Does Outlook consider MSG file as a normal attachment?? Please guide me. Thanks in advance. Rajesh
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.
Andy0/2 06 Jul 2011
Hi all, I'm having a rather annoying issue after some users have been updated to Office 2007 (from 2003) Their issue is with the below code, which seems to cause errors whether they already have Outlook open or not. The code below is from Excel, and uses Outlook to find the path to a certain public folder. It seems to be causing a "ActiveX component can't create object" issue.
Peter Sellmeije...1/1 24 Jun 2011
From a macro i do want to open a filedialog. In the Help i can find a example: 'Declare a variable as a FileDialog object. Dim fd As FileDialog 'Create a FileDialog object as a File Picker dialog box. Set fd = Application.FileDialog(msoFileDialogFilePicker) The last line gives in outlook an error. But in Excel it works fine. Why? Is there an alternative for
Azonei0/1 18 Jun 2011
I created a rule to run a custom VBA script to parse incoming emails for specific items and add the data to an Excel workbook. I wrote and tested the code in Outlook 2007 on a WinXP machine (SP3) and everything worked perfectly. When I deployed the macro to the target machine (Outlook 2007 on Windows 7), the VBA code is not running at all. I verified this by removing all of the code and
Howard Solovei0/3 17 Jun 2011
Hey, I'm trying to set up a rule in Outlook 2003 that automatically accepts any calendar invite from a select list of emails. I can set up the rule to only apply to Calendar Invites, and only for select people, but the Accept calendar invite action isn't an option. The one option I do see that may work is to create a custom action that accepts the invite for me. I'm not sure how to do
Dima0/1 15 Jun 2011
Hi all, I'm trying to write macro which picks a folder from personal folders ans save a mail after it is sent instead of in "sent" box. the problem is, that it works fine as long as I pick the folder from Mailbox and not from personal.When I pick a folder from personal folder, the mail stays in sent items folder. this is may code: Public Sub SendAndSave() Dim obj As Object Dim Mail
Adam and Kelly ...0/1 27 May 2011
I'm attempting to automate a calendar pull to populate a product we use (and manually update) extremely regularly. It's essentially 3 screenshots of 3 days of calendars. I'm using various win32 api calls to find the handle of the active calendar explorer (usually have a separate window open since I'm monitoring several shared calendars), pass the focus to that window and grab a screenshot.
McKilty0/3 16 May 2011
I have a routine which loops through a group of emails. If the emails meet a specific criteria, I want to add them to a new email. I do not know how to add an email as an attachment. The following is parts of my code: '---------------------------------------------------------------------- Set mItemCollection = mItemCollection.Restrict("[SentOn] > '" & Format(dteStart, "yyyy-mm-dd
Manu1/1 10 May 2011
I am writing a separate application to send task requests to the client using simple mail. Then the emails should be added to the mail box task list box in MS Outlook. Here I have used vCalender/vTodo format to set values . But when I send the email it is not sending as a task request and it displays as an email but it is not added to the task list box. That is the question I have. 1.
American since ...0/1 25 Apr 2011
When run with an appointment as the current item, the code below prints "Eastern Standard Time" for an appointment created today, starting and ending later today, during Daylight Saving Time. Both Windows and Outlook are correctly set to Eastern Time; Windows is set to adjust automatically for Daylight Saving Time (I cannot find a separate option for this in Outlook 2010, though I'm sure
nina0/1 04 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
Youie0/1 20 Mar 2011
Hi, I'm totally dazed and confused about this. My Outlook 2010 has just woken up one day and decided it won't allow me to access the VBE either through the toolbar or with Alt-F11. Can anyone give me any clue at all, please?
Yorkie1/1 11 Mar 2011
Hi, I have a macro saved in vbaproject.otm, which is distributed across all users at my firm. This works fine when using Outlook and has been for a few years. We recently installed a new telephone system at my firm and with it some desktop software which can read Outlook contacts and dial them. This application is launched at startup for every user. The problem with it is,
HammerJoe@gmail...0/2 08 Feb 2011
Hi, I hope someone can help me. Im using Outlook 2007 and I have one mail exchange account with several mailboxes. Each mailbox has its own signature. I have created the different signatures and I would like for Outlook when creating a new email or replying to one to automatically detect which mailbox it is and add to the email the predefined signature. How can this be done? Thanks.
Uwe Fechner1/1 08 Feb 2011
Hi, I would like to create in Outlook in the Folder view an entry in which then displays in the list view a table from Access. The entry in the folder view to be bold, and as a figure behind it's the number of rows of the DB, which have been added new. I googled already quite long after that, but there is nothing to. Now I can create search folders (also vb) but I can define a search
brightenmyoutlo...0/2 26 Jan 2011
How can I open an Excel Workbook from an Outlook macro and activate that workbook? The goal is to enter a 4 digit number in an outlook userform (txtbox1), press a search button and the outlook macro should open an excel workbook (or if excel is already running, activate excel and open the specific workbook in a specific folder if it's not already opened, if the workbook is already
Thomas0/1 25 Jan 2011
Hi, I'm working in an IT support environment and am connected to 5 different email accounts (all under the same Outlook profile). I manually change the From: email address to reflect which mailbox I'm using. I'm now looking for a way to automatically change the email signature based on the email address specified in the From:. Like if I send an email from addres1@company.com Outlook
Dimithri0/1 11 Jan 2011
Hi, Does anyone know how to search for emails located within public folders in MS outlook? We store all emails in public folders so everyone can access them but when I try to find something its a nightmare. I've tried the MS outlook search but it always returns 0 results even when I know its there. I've heard google desktop can search emails but can it search within public
Mark0/1 13 Dec 2010
I wish to develop my idea further and need help - I've been playing with it but I'm not an expert Presently I fire up the below macro when I have an email highlighted and it enters the "Dear Joe" etc in the email body. I'm wondering if it would be possible to apply this slightly differently. To start an email i.e. new or click reply, ensure that there is a recipient in the 'To' box, e.
veenu0/7 02 Dec 2010
Hello, We are trying to create task in tasks folder of outlook using outlook object model in ASp.net2.0 web application. The code is like this Dim oApp As Outlook.Application = New Outlook.Application() Dim oNS As Outlook.NameSpace = oApp.GetNamespace("mapi") ' oNS.Logon(txtAdmineMailID.Text, txtAdminPwd.Text, True, True) Dim OTask As Outlook.TaskItem = oApp.
Richard0/1 01 Dec 2010
I would like to write a script for a mass mailing that has "Client Accounts" as the from name rather than my name. Is this possible? I don't see anything that would allow this. Thanks in Advance. Rich
Sebastian Wain0/2 23 Nov 2010
Hi, I would like to iterate over all *.pst's in the current profile. How can I accomplish this (on Outlook 2003-2010)? That information seems available at: "HKEY_CURRENT_USER\Software \Microsoft\Windows NT\CurrentVersion\Windows Messaging Subsystem \Profiles" but not readable in a straightforward way. Thanks, Seb
nnichols0/1 17 Nov 2010
Hi All, I hate posting without at least having a starting point but I am absolutely clueless on this one. When a user enters an eleven or thirteen digit number into the subject I would like to do some processing on it. We use a barcode scanner to enter an eleven digit number into the subject line which is then manually reformatted to remove the last digit (a check digit) and add a
Andy1/22 26 Oct 2010
Hey there! I'm currently working on a project that involves merging data from many different csv files into one Excel workbook for analysis. The csv files are sent to a public folder (outlook:\\Public Folders \All Public Folders\etc...) I thought the easiest way to do this would be to import the data straight from Outlook to the Excel file but after much painful testing I couldn't
Ken Slovak0/4 21 Oct 2010
Hi, Can anyone tell how to read the values available in the "Member Of" from the Global Address List? Appreciate your help. Thanks, Sab
OutdoorRuss0/5 18 Oct 2010
I am looking for a way to change the category of the original message once I have replied to it. For instance, I have two categories, "Reply Needed" and "Waiting for Reply". When a message comes in, it automatically gets the "Needs Reply" via a rule. When I reply to it, I want the original message to automatically switch to "Waiting For Reply" so I don't have to remember to
Ken Slovak0/2 05 Oct 2010
Hi all, I want to do the following using VBA, and ultimately using COM/ ActiveX. But since they are similar, lets start with VBA. Lets say I have copied some cells (with formatting) to clipboard from Excel. How do I paste this clipboard to Outlook Word Editor 2003 as an image and send it out using VBA/COM/ActiveX? Thanks a lot!
Ken Slovak0/10 05 Oct 2010
I have created an Outlook 2003 addin using VB2010. I have used the Shim Wizard to create a shim for it. On the machine on which development took place, the addin is loading correctly in Outlook 2003... buttons are working as expected BUT...for some reason the addin does not appear on the list of ComAddins. Please help (I miss the simplicity of VB6). Thanks Sanjay
Ken Slovak1/2 23 Sep 2010
Setup: VS 2010, Outlook 2003, Windows XP The Shim Wizard created all the components properly but when I try and build the Managed Aggregator I get the following error: .Net Framework v3.5 Service Pack 1 was not found. In order to target ".NetFramework,Version=v2.0", .NetFramework v3.5 Service Pack 1 or later must be installed. The computer has VS2010 installed so .Net Framework 4.0
Ken Slovak0/8 21 Sep 2010
I am trying to use XL-Dennis'es tlb file as recommend in Professional Outlook 2007 Programming (Ken Slovak) . I tried to add the tlb file to VB in Vs2010 and got the error: A reference to the <filename> could not be added.Please maje sure that the file is accessible and it is a valid assembly or COM component. I then tried tlbimp.exe on it and got the message: TlbImp: error
Sanjay0/8 15 Sep 2010
Does Microsoft have a shim Wizard available for Visual Studio 2010? Is there any good online documentation available on using Shims for deploying Outlook shared addins. Thanks Sanjay
Sanjay0/1 13 Sep 2010
Does Microsoft have a shim Wizard available for Visual Studio 2010? Is there any good online documentation available on using Shims for deploying Outlook shared addins. Thanks Sanjay
Sanjay1/3 13 Sep 2010
We are investigating using Visual Studio 2010 for developing Outlook addins. It appears that VS 2010 cannot be used to develop addins for Outlook 2003 as mentioned in the link below: http://msdn.microsoft.com/en-us/library/bb772080.aspx Is this true? At this stage we are thinking of creating the addins as Shared Addins instead of using VSTO. Would appreciate any guidance from
Ken Slovak0/2 13 Sep 2010
Is it possible to develop an addin that will work in both Outlook 2007 and Outlook 2010 using Visual Studio 2010? If yes, do we have to have Outlook 2007 installed on the development computer (as it is the earlier version) or is it also possible if the computer has Outlook 2010. Thanks in advance. Sanjay
Jeff0/1 10 Sep 2010
Hi all, Does anyone know how to get at the Account settings for a users PST file? I need to locate it so that it can be backed up. Problem is the end-users are potentially not sufficiently literate to move their files from a network share and so it has to be done programmatically. I know the settings are buried in the Windows Mail (In the XP control panel) rather than in outlook