I cant see emails coming in anymore.
I used to push send/receive and a box would come up telling me 'Receiving 8
of 40 emails' with a green bar going across the centre. Once the emails are
received the box goes. If I push send/receive nothing happens. If I push it
say, 10 times, again nothing happens. Once all the emails are thru the box
that used to come up, than flashes up 10 times, but by than its a little
late. Does anyone know how to get the box back? I would really appreciate
it... KR Mick.
I send this message using the forward procedure to somebody of the group
My problem is likely the same as a lot ...two accounts, sender's name appeared wrong in outbox
I set up two account in outlook 2002(first use, before I use outlook
express). Every thing goes well except sender's name appear wrong in outbox.
For example, I set up two accounts A and B. Accordingly, sender name is
A_sender and B-sender.A account is defult. sender name is A_sender when I
send email by B accout. I don't know how to fix it. Any advice.
"David_Ye" <David_Ye@discussions.microsoft.com> wrote in message
>I set up two account in outlook 2002(first use, before I use outlook
Fisrt of all, I want to thank you for your support :)
My question is: How can I get the path of the current Excel file in
Message posted from http://www.ExcelForum.com/
Dim MyPath As String
MyPath = CurDir
>Fisrt of all, I want to thank you for your support :)
>My question is: How can I get the path of the current
Excel file in
>Message posted from http://www.ExcelForum.com/
Try so...External Data wont refresh on a prtected and shared workbook...
I have a workbook that is used by multiple people over a network. In this
workbook I added some data from a site that i wanted refreshed everytime the
workbook is opened. I found out i can't protect the worksheet or protect and
share the workbook and still have it refresh the data. Is there a way to
protect/share the workbook (due to code inside the book) and still have the
external web data refreshed upon the book opening
...Not able to see all data but can see on another computer
I am using SAP application and if i retrive the excel file from SAP i can
see only 48 lines where as i should see 110 lines but if i opened that same
excel file in another computer then i can see all lines (110 Lines) i don't
know why its happening.
Can anyone help on this? Thanks in advance.
...Query to Access : does'nt see tables
Office 2000 SP3 FR
From Excel / MS Query, I want to read data in Access tables.
I choose the mdb file and so MS Query displays this error message
"This data source does'nt have any visible table".
Original in French : "Cette source de donn�es ne contient aucune table
I transfert my data to a new mdb file : it work's few times (!), then the
error message appears again.
How to resolve this problem ?
MS Query does'nt accept a file name with 2 dot inside !
MyFile.mdb --> Ok
My.File.mdb --> "...how to delete the same columns across a workbook
how to delete the same columns across a workbook
Hold down the CTRL key and click each sheet tab to group them. On the
visible sheet delete the column abd it will be deleted on all grouped
Click a sheet tab to un-group sheets.
On 5 Jan, 19:39, RPM <R...@discussions.microsoft.com> wrote:
> how to delete the same columns across a workbook
...How to see my mail queue?
I have a Exchange 2000 running on Windows 2000 server.
Could you please tell me how to monitor my emails in my mail queue? I can't
find a location on the Windows to see the mail queue status.
Thanks in advance,
To view the mail queues follow these steps:
1. Open system manager, Navigate down to the following location
Your organization --> Administrative groups --> Your Admin group -->
Servers --> Your Server --> Protocols --> SMTP --> SMTP virtual server -->
You should then see all the smtp queues and monitor mail.
...Sorting names from a list
I want to highlight all names in a particular column, say column A
starting with an alphabet value, say t, placed in a cell in anothe
column, say B2. So, names are listed in column A, B2 contains t. I wil
like to color all cells in column A that contain names strating with t
I would actually prefer to create a macro. Any help will be mos
Message posted from http://www.ExcelForum.com
Can't help you with a macro but this is very easily done
with conditional formatting.
Select the range to apply this to.
Select Conditional Formatting
Formula Is =LEFT(A1,1)...Copying Named Ranges in Chart Series
I have a workbook with a tab that has charts and data. Because the
number of data points can vary month to month, I have set up the chart
to reference named ranges. The named ranges are columns that vary in
length, defined by language like this:
The X and Y series use the named ranges. If I add or remove data the
chart range automatically changes accordingly. These na...The recipient name is not recongnized
Trying to send out via internet mail. Exchange for local
mail. When sending attachments I get error saying
recipient name not recognized MTS-IS Exchange....When
sending regulare mail it works fine. When sending
attachments via Outlook 2000 it works fine. Any ideas?
Not sure if it relates to your problem, but note that using Exchange &
Internet mail in the same profile in Outlook 2000 and prior versions is not
supported and can lead to all kinds of annoyances. Your Outlook is trying to
send Internet out via Exchange, it sounds like....what's your default mail
service?You can up...Duplicate Record Name (when attempting to add a Team)
I've got a new installation of CRM that I'm trying to learn to
At some point I had a team or queue that was called Field Support, and
deleted it, but now I can't use the name any more and I don't know
where to look to remove said name.
Thanks in Advance,
...Extract First Name From String
How can I extract the First Name only from the String Below? I only want to
pick up 'Veronica'
I can get the Last Name by using CHARINDEX(',',[Patient Name])-1
[Patient Name] = LUNA,VERONICA E
Message posted via SQLMonster.com
SELECT LEFT(@Value, CHARINDEX(',', @Value)-1),
"Brian Conner via SQLMonster.com" <u47161@uwe> wrote in message
> How can I extract the First Name only from the String Be...I see you
Well, not really, but I used Google Earth to zoom in on the Flatiron
Building. You can get so close you can see the utilities on the roof,
the hydrants on the street, the little parkish area across 5th Avenue,
etc etc. Cool! Now tell me where your office is (like where is Peter's
window, what floor and facing what street). Google Earth lets you zoom
in all directions so I'll be able to turn the map to see that window.
Silly I know but still a connection on some level.
Pats looked good but not great last night. I didn't watch much more of
the game. I'm not sold on ...To See or Not To See
I have copied a few tables of text from a web page into Excel. Some of the
information contain word that are hyperlinks or email addresses. Is there a
way to change those columns of information to reveal the web address or email
So is it just displaying plaintext currently?
Have you seen this information from the Help Menu?
When you make changes to the Hyperlink and Followed Hyperlink styles, your
changes apply to all hyperlinks (hyperlink: Colored and underlined text or a
graphic that you click to go to a file, a location in a file, a Web page on
the World Wide Web...Name Tags
I would like to design and print name tags that have a small graphic.
Any help would be appreciated.
...How to get application handle name (show in tilte bar) from *.exe?
Q: When u open any application, then in tilte bar it show the handle name
Program Input Output
Notepad.exe - Notepad
WinWord.exe - Microsoft Word
WordPad.exe - WordPad
i need,it should be work for any *.exe
To specify the application name, you need either pass the desired name
to CWinApp constructor:
CYourApp::CYourApp() : CWinApp("name")
if not specified, to the resource string with the ID of AFX_IDS_APP_TITLE.
If the application name is not found in the resourc...E12 unable to see storage groups through EX MMC
We've been running E12 in a test environment for about 1 month and just today
ran into a situation where the storage groups for a server are no longer
visible from the console on that machine. If we view the server from a
console on a different EX server we see all storage groups and stores.
Any help is greatly appreciated
can you list the storage groups and stores from the shell (EMS) on that
did you try restarting EMC?
MVP - Exchange
NEW blog location:
&quo...Outlook will not open #5
Problem has not happened before. I don't get an error
message or anything. It just does nothing. Can anyone
...Holding a file open in FTP?
We have a user who wants to share an editable spreadsheet on
their web server (IIS5) with others over the internet. So we placed
a spreadsheet file in the FTP directory, established FTP accounts for
the users, and they can open the spreadsheet by opening the FQDN
The problem is that when they open the file this way, the file is locked
only for the duration of the FTP data transfer to the client, after which
it is freed. A second person can come along and open, change, and
save the file while the first one has it open (on their remote machine)
and making changes.
...Name Badges with Graphics
I am trying to create a mail merge in Publisher 2003 that will contain the
same graphic for each badge. My data source is a word table. I don't
understand how to connect the graphic to the mail merge.
Thanks in advance for your help.
Do you have Excel or Access?
Mary Sauer MSFT MVP
"L. Roper" <LRoper@discussions.microsoft.com> wrote in message
>...Nice seeing all of you hopefully I see you in the other forum
really I just wanted to get the last post in prior to it closing today :)
...Opening Excel Attachement Using VBA
I am creating a system that will email a list if people an Excel
spreadsheet as an attachment which is personalised to them. The
recipient then fills in some data and emails the attachement back to a
set email address. At set intervals my system will scan the Exchange
folder for new emails. I need to be able to open the attachement and
capture the data into an Access database. Most of this I am OK with.
The bit I am unsure about is 1. How can I make sure the attachment is
an Excel spreadsheet before I try and open it using VBA code? 2. How do
I then open the file using VBA?
Can anybody pr...Full Name in Workbook Title Bar
I put the following in the Workbook_Open sub of a workbook.
ActiveWindow.Caption = ActiveWorkbook.FullName
It works just fine for that workbook but I really want it to work for
any workbook I open so I tried putting it in the Workbook_open sub of
Personal.xls. I got an error message saying something like "block
variable not set."
What can I do to make the full path name appear for any open workbook
with an entry in Personal.xls?
When you have it in your workbook_open event of a specific workbook, then that
event will apply to that workbook.
You'll want to...Can I see My Calendar as others see it
Can I view my calendar as if I am viewing it by someone with whom I share?
no. Your permission levels are greater.
Why do you want to be able to?
in Canberra, Australia
wrote in message news:46AD6AD8-5B97-4D06-9F73-2D212B626E05@microsoft.com...
> Can I view my calendar as if I am viewing it by someone with whom I share?