Email trouble with New User in Active Directory
Below is a trail of posts that have been made. My
problem has yet to resolved and I need some help
quickly. The only other thing I can think of is to
reinstall Exchange Server 2003. Hopefully someone will
know the answer.
Subject: Re: Email not Setup when new user created in
From: "Bryan Hill" <email@example.com> Sent:
8/15/2004 12:30:21 PM
We have other clients that are working fine. Just when
we try to set up new ones - it will create the SMTP
address but not the X400 address. I tried manually
forcing the X400 but it will...Detecting Shift key when form is opened
What is the best way to tell if the Shift key is held down when a form is
opened? The form is being opened from a toolbar. I don't want to react to
the Shift key's being pressed after the form is opened. I only want to react
if the Shift key was being held down when the toolbar option was clicked.
Also, is there a way to do this for reports?
Thanks in advance.
...macro-import another xls file
Hi, i need a macro to import another xls file.When i run macro i need a
window to appear and to browse to the file i need to import. I allways open
another file, so i want to browse for the file.
Can this be done?
Try some code like the following:
Dim FName As Variant
Dim Filter As String
' Excel 2003 workbooks
Filter = "Excel Files (*.xls),*.xls"
' Excel 2007 workbooks workbooks
Filter = "Excel Files (*.xlsx;*.xlsm;*.xlsb),*.xlsx;*.xlsm;*.xlsb"
' Excel 2003 and 2007
Filter = "Excel Files
(*.xls;*.xlsx;*.xlsm;*.xlsb),*...xml file attachment will not open
i can not open an xml file attachment to a mail message.
it started to fail after installing a critical update.
...Trouble with the template.
I want to reset the 'normal' template to default to "Times
New Roman" 10point font, and the pages numbered centre top.
This seems to work when I set and reopen Word2003 from the
Administrator Template vis:
C:\Documents and Settings\Administrator\Application
But it will not work when I open Word2003 normally from the
I have deleted the "Normal.dot" from the following and
copied in the "Normal.dot" from the Administrator above:
C:\Documents and Settings\All Users\Application
Data\Microsoft\Templates...trouble with CrmIsapi.dll
I was experiencing the same problem with the SDK as many have posted
to this group ...
"the WhoAmI() call results in a http error 405 when running sample
I followed some of the advice; checked my .srf mapping to CrmIsapi.dll
and re-registered the CrmIsapi.dll.
when I re-register CrmIsapi.dll I get an error 80004005 - unspecified.
I copied it to various places and retried it ... same result.
I got the original from the disk and retried ... same result.
unmapped it from .srf, restarted and retried to register it ... same
Anyone experienced this.
What's up with m...Problem with "att-1.unk" file
I use MS Outlook 2000 SR1 (22.214.171.12421). When receiving e-mail with attached file (extention doesn't matter) from one of my partners I always see this file as "att-1.unk" file. He uses MS Outlook too. This "att-1.unk" may be "stripped" of additional header using programs designed for "winmail.dat" files (for instance tnef.exe). I verified, that my partner used "Plain text", not "Rich text formant" when sending his e-mails. I received the same "att-1.unk" file when I tried to use Outlook Express instead of MS Outlook. Its...M03-WinXP -- Is .MNY file size an issue?
In early 2003 I experienced file corruption problems and an MS support rep
helped me to run the salvage program on my .mny file. He told me that my
problem resulted from the .mny file's growing too large. It was about 4 meg,
which he said was too big. He recommended that I archive every year.
I just looked at my file. Haven't archived since the beginning of 2003, so
I archived. The .mny file only shrunk from 3.9 to 3.5 meg. Started to look
here and read the FAQ page. I see tht some of you recommend against
archiving, so I renamed the archive file back to my primary name...Excel 2007 files not opening properly..
I have Office 2007 installed.. the one that doesn't come with Outlook. So,
I'm still using Outlook 2003.
When I double click an XLS file to open it, Excel opens and the file never
opens. I have to goto FILE, OPEN, then hit CANCEL and the file will display.
This only happens for Excel. Word 2007 works fine.
I have tried to uninstall the software and reinstall it, but it did not fix
Anyone else have this problem or know how to fix it?
We have Office 2007 on a few computers and I'm the only one with this
I found a fix for the problem, which seemed to...file has grown
i have an excel 97 file which has suddenly grown from
about 800K to nearly 4MB, i don't know why.
it is a faily simple file, no formulas, just a big
sortable, filterable list really.
this is making it cumbersome to use across our WAN.
i wonder if it has something to do with recently including
a lot of comments?
any help to reduce it's size would be appreciated.
You may need to look at your files "Used Range."
This is the area of each sheet that you have been into,
and therefore Excel has to remember the whole sheet,
rather than the section you use.
I had a file that w...unexpected conversion trouble
I wanted to open an Excel file I hadn't been working on for a while, an
Excel couldn't do it.
After some investigations, I found that even if the file still had th
.xls extension, it seemed to be conveted in .doc format (in fact, whe
I open it in notepad, I can see at the end some words that look like
MSWord signature). I don't know how this happened, but I'm reall
embarassed beacause i really need the data in this file.
I tried to change the extension to .doc, open the file in Word and the
import in Excel, but I can hardly see part of the file. What's more, i
is a 3-she...Trouble with Outlook 2003 and PST File
We have a user who is using Outlook 2003 and moves most emails to a PST file
which is considered archived email data.
They have reached the Max limited on this PST file of 1.99GBs and its not
letting them open the PST file.
It is trying to repair it when they try to open the PST file.
Here is the message they receive:
"Can't move the items. The file <path>\<filename>.pst has reached its
maximum size. To reduce the amount of data in this file, select some items
that you no longer need, and then permanently delete them."
I can't even get it open to delete...export and open an excel file from access
can any one please help me one more thing please for which im looking over
whole news group!
(1) i want to export many querys to excel using outputto method ofcourse
its doing the job but its creating an new work sheet for every query
how to put all data into one work sheet
(2) or else open an excel file in mydocuments / orelse anywhere and import
all the necessary table and do canculations but
(A) by this method how to use date criteria for importing data from tables
(b) how to access such excel files which will be in the my documents folder
on click event and come...Excel 2000 not remembering recent files
My "recent" files list is not being updated when I open a spreadsheet by
double clicking on the sheet directly.
Is there a setting to change this?
If I recall correctly, xl2002 was the first version to automatically update the
most recently used file list by double clicking on the file in windows explorer.
I don't think xl2k does this.
But if it's really important to you, Dana DeLouis posted some VBA code that
Mark Durrenberger wrote:
> My "recent" files l...ASX file
I received a message with an attached .asx file. None of the programs
I have seems to open it. Please advise what program available for a
Mac will open the file.
<firstname.lastname@example.org> wrote in message
> I received a message with an attached .asx file. None of the programs
> I have seems to open it. Please advise what program available for a
> Mac will open the file.
> thank you
It is a Windows Media file. Depending on the encoding, you can open it with
Windows Media Player for the Ma...Open filtered report
Access 2007. I have a 'summary' report grouped by [request date], no
detailed section. The field in the report design for the group is [request
date by day]. I'm trying to be able to double click on a group date in the
report and open another report with detailed info based on the group date
double clicked on in the summary report.
I tried on dbl click:
dim rd as date
rd=me.[request date by day] 'set date value = group date
docmd.openreport "detail", acPreview, "[request date by day]=" & rd
the "detail" report open...Trouble with Pivot Tables & Named Ranges
Can I use a dynamic named range setup in one file as a range in pivot tables
in another file?
When I have the data source file (with the named range) and the pivot report
files open, the pivot reports update just fine. But the moment I close the
source data, the pivot reports no longer can update and I get a message that
the source can't be found. If I reopen the source, the pivot tables work
fine again - but as soon as I close it up, the reports no longer work.
The source file is very large and I don't want to open it every time I have
to update all the reports tha...Can I open a spreadsheet If I don't have excel
My friend sent me a spreadsheet....but I dont have excel.
How can I open it.
If you do not have Excel, you can download an Excel viewer from Microsoft.
The viewer will allow you to read but not edit a workbook.The viewer is
freely downloadable from:
Another possibility would be to download the freely available OpenOffice
suite which can read and write Excel workbooks. The download is > 60MB
(IIRC), but the suite can also be obtained on CD.
For OpenOffice go to:
A third ...I am in trouble
I am a student in Cambodia.I don't have any girlfriend. I tried everything.
I looked at them wrote poem to them it doesnt work. I got an account from
facebook, hi5 friendster myspace. I have 0 girl friend. What should I do? I
am so desperate. I am good looking and 250 kg only. Please help me or at
least send me some foood I am hungry
__________ Information from ESET NOD32 Antivirus, version of virus signature database 4944 (20100314) __________
The message was checked by ESET NOD32 Antivirus.
You're tr...Opening attachments 01-28-10
When I open email attachments a popup window appears labeled "Opening Mail
Attachment" and has the options to "open", "save" and "cancel". There is a
check mark in the box "Always ask before opening this type of file" but I am
unable to uncheck the box.
How do I stop this window from appearing?
Sounds like you are running either Windows 7 or Windows Vista.
Right click on the Outlook shortcut in the Start Menu and choose Run as
Administrator. Make the change and then start Outlook normally again.
Robert Sparnaaij [MVP-Outlo...Refresh on Open
Can i get a worksheet to refresh after a set amount of time or as i
opens. or both
i have also posted this on
'also posted here
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
used this link to complete
~~ Message posted from http://www.ExcelTip.com
~~View and pos...What is best way to read binary file into string?
I am now building a routine that reads a small (no larger than 100 bytes)
and saves the contents in a string. The file can contain characters anywhere
0 - 255 ASCII range. After looking at MSDN Lib. and on the 'net I found a
approaches to this problem. I selected one; the resulting code:
Dim strBuf As String = ""
Dim i As Int32
'Check to see if file exists.
If System.IO.File.Exists(strFile) Then
'File exists. Read it.
Dim fs As New System.IO.FileStream(strFile, System.IO.FileMode.Open)
...Trouble with "time" in formulas
I have a time sheet that looks something like this:
A1 and A2 are set up as dropdown lists and the times in the list are i
increments of 15 minutes. WHat I'm trying to accomplish is (in cell A4
if A3 is between 15 minutes and 4 hours, then return 4 hours. if A3 i
0 or greater than 4 hours, return A3.
If I enter enter times in A1 around 00:00 and A2 a little after 00:0
it works fine... example:
A1=00...converting .ics file to Publisher
I am trying to convert my internet calendar into a Publisher document. How
can I make that conversion?
Copy/paste? Print screen and insert as an image? Any particular reason why you
cannot use Publisher's calendars?
Mary Sauer MSFT MVP
"RevJon" <RevJon@discussions.microsoft.com> wrote in message
>I am trying to convert my internet calendar into a Publisher document. How
> can I make that conversion?
I tried the c...saving file as text(tab delimited)...
I use Excel 2003. For example I write test;test1 in A1 and save as the file
text(tab delimited)(*.txt). I open the saved file, it write "test;test1".
If a cell contains semicolon between text, after saving file as text(tab
delimited)(*.txt), it places quotation marks.
Why it puts quotation marks? And how can I configure excel not put quotation
Note: Replacing quotation marks in saved text file is not a solution for me.
Thanks and best regards.
I think it's because your windows list separator is a semicolon.
I put test;test in A1 (and have a comma as my ...