Reply:

Importing Data into an Excel Pivot Table via Access
I have set up a query in Microsoft Access which is linked to our AS400 server. I have created pararmeters within Access which asks for certain fields which works. I then go into Excel and create a pivot table with the external data source that I have created in access. When I go to enter a pararmeter within Microsof Query I get a reply saying that "Parameters can not be used with this Query", what I want to do is setup a parameter on the Excel spreadsheet which then goes and gets the data i require from this parameter. I would be very grateful if someone could help me with thi...

Outlook Mobile Access Problem
Hi I've a big problem in Outlook Mobile Access. I've a server exchange standalone withoput a front-end=20 one... I've configured the OWA web form authentication and SSL. For OWA it's all right...everything is going right... The problem is OMA When I try to log on on oma I find the following error=20 message :"Unable to connect to your mailbox" To solve my problem I've found in microsoft web site the=20 following link Microsoft Knowledge Base - 817379 Cannot Access Exchange Server 2003 by Using Outlook Mobile=20 Access When the Exchange Virtual Directory Require...

How do i get outlook to update hotmail account without reopening?
the tedster <the tedster@discussions.microsoft.com> wrote: <nothing> Ask your question in the body of the message. Without reopening what? Outlook? Hotmail? The short answer is "you can't". -- Brian Tillman ...

outlook 2007 runs slow
Hi Outlook 2007 runs slow. Is there a way to speed it up. Thanks Do you have the outlook performance update installed? Are you using a Dell laptop? Did you upgrade from an older version and are still using that profile? http://www.slipstick.com/outlook/ol2007/slow.htm - install the update listed at the end - also make sure all OS and Office updates available through Microsoft update are installed. If it's still slow, try the various solutions that apply to your situation. -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Need Help with Common Ta...

can't send anything in Outlook 2002
I just sent a post asking for help because I can no longer send email with attachments. After sending in the post, I went back to Outlook and clicked on the Send/Receive button just to check if I had any new mail. I got the same message: "The operation failed". So I am totally out of business with Outlook. How to solve the problem? Marilyn Did it work before? Did you change anything in yr settings? Are you sure your internet mail account settings are valid (correct username, pw, smtp/pop3 servers)? ------------ "Marilyn Fogelquist" <fogel@cablespeed........

Outlook 2003
Hello. I copied my PST file from my D: drive to my F: drive. I then went into "Data File Management" to get the new location recognized and to have all future mail sent to that location. After doing this, my custom settings, like new folders, date settings, columns, etc, are all back to their default settings. Is there any way I can get my custom settings working again on the F: drive? Thanks, Dan Could you explain yourself a bit more? What custom settings are you refering to? You mean views? And what new folder settings? Also post your version of Outlook. -- Robert Spar...

Import Palm files
Can anyone help me by telling me how to import palm files (dat files) into outlook. I want to import contact, calendar, etc Depends what you can export to from Palm Desktop. Personally, I've found this messy. Why not just get sync software that can sync your Palm with Outlook directly? Chapura Pocketmirror or Pumatech Intellisync are two ideas....or your Palm CD may have come with this option. F. Carvalho wrote: > Can anyone help me by telling me how to import palm files > (dat files) into outlook. I want to import contact, > calendar, etc ...

Outgoing emails not sending for outlook express 2000
Hi there, Can anyone help me?Everytime I try to send an email these error messages pop up and I have no idea what to do; The host 'SMTP' could not be found. Please verify that you have entered the server name correctly. Account: 'POP3', Server: 'SMTP', Protocol: SMTP, Port: 25, Secure(SSL): No, Socket Error: 11001, Error Number: 0x800CCC0D The host 'POP3' could not be found. Please verify that you have entered the server name correctly. Account: 'POP3', Server: 'POP3', Protocol: POP3, Port: 110, Secure(SSL): No, Socket Error: 11001, Err...

cmbo box on subform fills fields on form when chkbx is yes
I have a multi-tabbed form that details bid data ranging from pricing to contact info to departmental notes. Page two has a subform listing general contractors to whom we bid. One bid may have 10-15 contractors listed. When a purchase order is issued from one of these contractors I select a checkbox indicating that GC. I would like the opening page on this tabbed form to show the address and contact info for that GC when the checkbox is yes. Is this possible? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200803/1 On Mar 17, 3:04=A0p...

outlook 2000 help file
Seems after I did added SP3 from MS upgrade site my help from outlook has quit working. message is msohelp caused error in itss.dll. help works in ALL other programs including outlook address book. I'm running windows 98 SE, Office 2000 SB and IE 6. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.542 / Virus Database: 336 - Release Date: 11/18/03 ...

allowing or disallowing changing the state of check box
Hi, what's the best moment to check if the user has right to change the state of check box and then to allow it or cancel it. I've tried with "before update" event procedure. It seems to work but after, when I press anything else on the form event procedure is repeating? Any help? thanx alekmil One addition: The problem occurs (repeating) when Cancel = True was applied previosly. "alekm" wrote: > Hi, > what's the best moment to check if the user has right to change the state of > check box and then to allow it or cancel it. I'...

How to do a mass download of names to Outlook address book
I have about 800 names and email addresses in an Excel spreadsheet that I need to add to my Outlook address book. Can anyone give me a hint on how to do this? Save the Excel Spreadsheet as a CSV (Comma Separated Value) file and then in the Address Box, Click, File, Import, Other Address Box, then click Text CSV file and browse to it. "Hal Segal" <anonymous@discussions.microsoft.com> wrote in message news:07a601c3b83a$c6d270c0$a001280a@phx.gbl... > I have about 800 names and email addresses in an Excel > spreadsheet that I need to add to my Outlook address book. > C...

MSN accounts dosen't work in Outlook.
Hi! I can't download my e-mails from MSN to Microsoft Outlook 2003. I have setup the account correspondent to Microsoft Outlook 2003 Wizard, but it still dosen't work. Does anyone know where the problem can be? Thanks, Bob Only the paid MSN and Hotmail accounts will work in Outlook and/or Outlook Express. Are you supscribed to the paid service? -- Robert Sparnaaij [MVP-Outlook] www.howto-outlook.com Tips of the month: -What do the Outlook Icons Mean? -Create an Office 2003 CD slipstreamed with Service Pack 1 ----- "hardharut" <test111@test.com> wrote in me...

Contact not importing names of csv lists
Whenever I import a csv file into outlook 2007 it imports only the email addresses, nothing else. I've titled the csv columns with the exact same headings as the outlook contact headings. Still, it imports only the email addresses. What do I need to do to get it to import the full names as well? Is it correct to assume that because you stated that you "titled the csv columns the same as the Outlook contact headings" - that you used "auto-map" to import your data? There is absolutely no reason, benefit or value whatsoever (under any circumstances) in ...

Outlook should be able to email MS CRM advanced find queries (grou
The only way to e-mail a group in MS-CRM is to use the Quick Campaign function. The Quick Campaign has several disadvantages: - attachments for emails are not possible - this takes at least about 10 more clicks compared to sending a standard outlook email - the quick campaign doesn't have the look-and-feel of Outlook to which users are accustomed to Therefore it would be great if you could select the emailaddresses from groups retrieved from MS CRM into the TO:, CC: or BCC: field in a standard Outlook email message. Actually you would make the advanced find queries available to sel...

Outlook 2003 Contact data
Just starting using Outlook 2003. When composing an email, when go to address the note, it appears that there are 2 Contact files - 1 is "blank" and the other has lots of my contacts. It is the latter contact file that I enabled to use as my address book. Initially address book comes up the first one and I get error message. Then I toggle to the second one and all the names are accessible. How do I get rid of the one that appears blank, so only one contact file appears when I go to address an email? Les <lester123_nospam@comcast.net> wrote: > When composing an e...

outlook 2003 memory leak? /messages display as"none" and eats up memory
Hi there; When a certian user opens outlook, and clicks on sort by size, half of her e-mails disappear, and "none" is displayed. She said this happened to her at home, except she was on her normal view which is sort by date. The only way that I can recreate the problem is to click on sort by size. If you click on one of the "none's" or even hover the mouse over it, the memory will spike up! I had the performance tab open while I was doing this, and the memory being used was read at 1.46 GB! And if I close outlook the memory drops down to normal. I took ...

Debugger comes up when attaching files to Outlook 2002
I have a pro bono non-profit client running win xp sp3 & ms office pro. Last week she reported that every time she tried to attach a file to an outlook email, she received a dialog asking her if she wanted to start the debugger. It never allows her to attach the file and if she goes through with starting the debugger, she gets a variety of errors... never a repeating error. Anyone have any experience with this error? Michael ...

Outlook 2002/XP Folder List view question
Any assistance would be greatly appreciated. I have a user still using Outlook XP and has the following issue. Outlook does not remember the folder view settings. User has folders under the Inbox folders and of those folders some are expanded and some are collapsed. When he closes Outlook it does not "remember" the folder settings. The user would like for Outlook to remember the settings because it has in the past. Is there a way I can get this back? Thanks ...

Outlook 2000 #147
Outlook 2000 Everytime I open outlook I receive error: Outlook generated error and will be closed by windows. I can open in safe mode and I can also open in express. I have tried renaming extend.dat file, removed checks from add-in tab and changed profiles. I have even tried re-installing. Can anyone help me. This is a long shot but have you tried using a fresh PST file? "Pam" wrote: > Outlook 2000 > > Everytime I open outlook I receive error: Outlook > generated error and will be closed by windows. I can open > in safe mode and I can also open in expre...

Combo Box Value List/Query Criteria
Hi Folks - I have a combo box with a value list of Option1, Option2 and ALL. I pass this combo box info into a query. Here's a sample of the query criteria: IIf([Forms]![frmSwitchboard]![cboCaseType]="all",Is Null,[Forms]![frmSwitchboard]![cboCaseType]) In other words, if the combo box selection is ALL, then display all records, otherwise use selected option. The above criteria does not work. Any suggestions? Thanks. Michael Michael, Try... (IsNull is an operator, not a value) IIf([Forms]![frmSwitchboard]![cboCaseType]="All", Null,[Forms]![frmSwitchboar...

Add New Record Using Combo Box
I am using 2 different tables: Employee Info and Trip Details. I need to have a blank form open to enter new information, but I would like a combo box to choose the employees name, as there are over 300 employees. Ideally, the first name, last name, and DOB would be populated, but the rest of the information would still be blank to add new data. I could then just hit a button to open the form again to add information about a different employee. I am having a problem doing this and would greatly appreciate if someone could let me know how to accomplish this. Thanks. On Wed, 21 Mar 2007 17:26:03...

Outlook 2007 Missing Mail
I have an office where we are noticing that if we look in Vista Mail that MS outlook 2007 has missed many emails. Program restarts and reboots don't seem to correct the problem, and both programs are using the same IMAP settings. Is there a "helpful" little option in Outlook that prevents it from looking a all email receieved to an account? Does anyone else have the same problem? are there any similarities between the ones it misses? -- "nano" <nano@discussions.microsoft.com> wrote in message news:DC22F7E7-ACB7-4824-A0A1-3329D3C622EA@microsoft.com.....

Exporting-importing email accout (.iaf) doesn't work
Hi, i have an .iaf file that i get exporting my email account at work. Now i have imported that file at home, but when i click on "Send and recieve" i get this message: [quote title=3DQuote:] Fall=F3 la conexi=F3n con el servidor. Cuenta: 'pop3.xxx.es', Servidor: 'pop3.xxx.es', Protocolo: POP3, Puerto: 110, Seguridad (SSL): No, Error de socket: 10060, N=FAmero de error: 0x800CCC0E[/quote] I'm using OL Express 6 in both computers (Windows XP). Any idea? Bye Javi Disable email scanning by your anti-virus application. It provides no addit...

Outlook 2003
Just upgraded from Outlook 2000 to Outlook 2003. Everything seems to be working OK !! BUT ! On the Outlook Today screen no images are shown. If I go into the customise option, there are no images shown for the various styles. Also any changes I make in Outlook today options are not saved.. Any Ideas ??? ...