Macro Not Working
Hi can any please advise me why my Macro is not working
The Macro allows users to Input dates via a message box which shoul
then be input in cells B1, B2, B3 & B4 - but this does not happen - I
addition when I try to change the sheet name in the macro from Sheet2 t
another name i.e. mydata it displays an error
MyName = InputBox("Please Enter Date for Q1")
If MyName = "" Then
Sheet2.Range("$B$1").Value = MyName
MyName = InputBox("Please Enter Date for Q2")
If MyName = "" Then
E...2007 compatibility pack not working
I have Windows 2000 SP4 running Office 2000 SP3. I installed the latest
2007 office compatibility pack (incudes SP1 and SP2), however I am still
unable to open Office 2007 files, specifically .xlsx and .docx. I have tried
repairing and reinstalling Office. I have downloaded and installed all the
Microsoft Security updates and Office 2000 Updates. I even uninstalled and
reinstalled the compatibility pack. Still no luck. I get the following
error when opening a Word 2007 doc. "There was an error opening the file".
Excel just says the file is an unrecogni...Test Mail...Please Ignore #2
Testing NNTP Client,
Please ignore message
...Junk E-Mail Lists Error in Outlook 2003 with Exchange 2003
I have seen several people post about this error message that comes up
in Outlook, but so far I haven't seen anyone respond. I am running an
Exchange 2003 server with SP1 and my client is Outlook 2003. I
installed IMF a few weeks ago, and it appears that this message
started soon afterwards. I have now uninstalled IMF, but am still
receiving the message. My end users are getting frustrated, as am I.
There also appears to be an error in the IMF deployment guide about
adding a registry key to increase the list size in Exchange. It
states to "right click System", but there is n...Blank body on E-mails received with signature and attachment
When I get an e-mail that has an attachment and a signature, either the
message body will be blank or the body will have text but the signature will
not appear in the body. There will be a .txt file along with the attachment
which is probably the signature but when I click on it I get "access is
denied". Are there settings that will allow the signature to be displayed in
the body of the text? The sender is using Eudora 7.
Do you have a virus scanner installed which integrates itself with Outlook?
Uninstall this integration part of your virus scanner and try again; you...Merging tables
Hello, I do not have deep knowledge of Excel. That is why my proble
might appear a bit strange:
I have two tables, list1 and list2. In both tables there is a colum
with unique ID numbers. The rest of the columns contains differen
information in both tables. Example:
ID name email
101 bob firstname.lastname@example.org
102 rita email@example.com
999 jim firstname.lastname@example.org
What I would like to get as a result is a combined table, with selecte
columns from both tables in it. I.e.:
ID name salary
101 bob -
102 rita 2500
Anyone who can ...Working hours
Every month we make a list of our employees working hours.
monday 10.00 - 16.00 = 6h
tuesday 16.00 - 20.00 = 4h
how can i calculate the hours together, some employ can have only 30 hours
per week, now calculate by my fingers....sorry for my bad english
Day in Column A,
Start time in Column B,
End time in Column C,
Start in Row 2.
Make sure time entries are TRUE XL recognized times.
Daily total in Column D, using this formula:
Say weekly total is in D9.
Format D9 to Custom
And use this formula:...FilesystemObject doesn't work anymore. How to fix?
I think that scrrun.dll is messed up (New technical term) somehow. But if I
knew what I am talking about, I wouldn't be bothering you folks.
This line: Set fso = CreateObject("scripting.filesystemobject")
causes this error message to appear:
Error: (null) Code: 8002801D
I've dragged scrrun.dll onto regsvr32.exe several times (just to be sure I
actually had done it) , each time getting the message: DllRegisterServer in
I'm running WinVista Ultimate 64bit, completely updated.
Does anybody have any ideas a...Windows Mail recovering messages
I need to reinstall Vista so what is the best way to save/recover existing
See www.oehelp.com/backup.aspx You need to backup the message store and the
relevant registry keys. Then, once reinstalled, just replace the location
of the message store and merge the registry keys. Then before starting
Winmail make sure the "Store Root" value in the registry correctly lists the
location of the message store and if so then start Winmail and it should
work fine, except you will have to put in your passwords again.
"Therealdaddydo" ...Merging mass e-mails between word and Outlook (XP)
When sending a mass e-mail from Word to Outlook, a
message appears stating that 'another program is trying
to automatically send e-mails' You choose 'Allow access
for 10 minutes' and click OK
Then, a similiar message appears for each of the e-mails
being sent. You need to click Yes for each of the e-
mails. I have tried adjusting security levels with no
luck. Any ideas??
...Trouble getting Bill Pay to work with Money 2005
I upgraded from Money 2004 Deluxe to Money 2005 Premium
this evening. I had Bill Pay working in the 2004 version.
I went to enable the "Access your Money data on the Web"
option in Settings. It said that I had to disable Bill
Pay first before it would continue and that it would
enable Bill Pay again once the process was complete.
Unfortunately, now I can't get Bill Pay enabled again. I
can go to the Bills screen and see my scheduled bills,
but I can't do ePay through Bill Pay in Money anymore.
When I go to Manage Online Services, I see my bank
accounts that are ...How to highlight the mail was sent by bcc
How to highlight the mail was sent by bcc?
anyway is acceptable, ex: move them into a special folder, or make the mail
up a color, or add a flag with is .....etc.
Please share a way to do management of bcc mail.
> How to highlight the mail was sent by bcc?
> anyway is acceptable, ex: move them into a special folder, or make
> the mail up a color, or add a flag with is .....etc.
> Please share a way to do management of bcc mail.
Out of curiousity, do you mean highlight it to the person receiving the
email or highlight to the person sending ...external mail
We have one exchange organization with two exchange servers. The e2k is the
master and the 1st exchange in the organization and we installed the e2k3 as
a member of this exchange organization. Both exchange server has a public IP
with an A Record and a MX Record with the e2k having the lower MX. In the
Routing Group, there is a connector that route out-going email with the e2k
being the bridge head server for the entire organization. The configuration
of the connector has the e2k with the address space of * and a cost of 1. As
I understand it, the E2K3 should be able to handle mail...Deleting over-large outgoing mail
I accidentially attached a 6 MB file to a mail item that
was to go out on my Hotmail account. Now that it's in the
outbox, Hotmail won't take it (it's too large) and I
can't delete it (permission denied).
Any help would be appreciated.
Thanks in advance, J.
Create a new .pst file and make it the default. Close and reopen Outlook.
Go into your outbox and delete the message. Close the new .pst file. Close
and reopen Outlook.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the SWEN virus, all mail sent to my pers...default mail format based on domain
After 20_ years of Eudora and Thunderbird (in that order), I'm looking
at Outlook for the first time (we're moving to an Exchange backend,
so...worth a look, for obvious reasons). In Thunderbird, if I want to
set a default HTML format for emails sent to a certain domain, I can
specify that. For any other domain(s), plain text.
Is there an easy way to do that in Outlook (I'm using 2007)?
Basically, I want emails sent to my enterprise domain (i.e., my place
of employment) to be in HTML or perhaps RTF, but mail sent to other
domains to be plain text only.
Again, I want ...get a list of file in a directory
what would be the best way to return a list of files in a directory.
I know in VB you could use the dir function, but what should
i use in MFC.
Doen anyone know of a class available where I could say return all the file
in a certain directory and its sub directories
Take a look at the CFileFind MFC class.
Check Abdoul [VC++ MVP]
"Dylan Franklin" <email@example.com> wrote in message
> what would be the best way to return a list of files i...Multiple e-mail account in MS Outlook 2003
I have 4 e-mail accounts set up (all from the same server) and can send from
all accounts but I only receive mail for the default account. Any
Does each account use the same account properties? (e.g. same mailbox name,
userid, and password.)
"Crazy Squaw" <Crazy Squaw@discussions.microsoft.com> wrote in message
>I have 4 e-mail accounts set up (all from the same server) and can send
> all accounts but I only receive mail for the default account. Any
...Is there a work-a-round i can use for making a datagrid....
Hey all, I am trying to make a datagrid on a form that the user would input
info, and once completed, it would be put in correct area's of the workbook.
I cant use a datagrid as job doesn't alw downloads for net so i cant get the
update needed to alw me to use datagrids( see post sugj: "Missing Control In
Addin") is there a way i can use a text box or some other box or tool to do
When you say "form", do you mean UserForm or worksheet set up to look like a
data input form? If a UserForm, then yes, you can use TextBoxes, but you
didn't supp...money for notihng that works
What is $5 and 15 minutes when it can make you earn $100,000 ?
Not much, if you ask me...
You've probably seen a lot of those kind of messages over forums and
and the explanation for this can be given in two words: IT WORKS!
But how on earth, will you ask me, does it actually works? How is such a
This is a simple pyramid scheme. To explain it to you with realistic
lets take a simple example:
Imagine you folow the instructions given below, and post your message to
newsgroups (wich isn't much). 10 people read your message and also folow
ins...Using tild-n in e-mail
Using Win XP/OLK 2003, and NOT using Word as the editor, does anyone know
how to insert the 'enya' (n with the tilde ~ over it) into an email? My
users typically have default email set to HTML although some prefer plain
text. Would that make a difference?
da-moe <firstname.lastname@example.org> wrote:
> Using Win XP/OLK 2003, and NOT using Word as the editor, does anyone
> know how to insert the 'enya' (n with the tilde ~ over it) into an
> email? My users typically have default email set to HTML although
> some prefer plain text. Would that mak...Rules don't work for Spammer terms in Outlook 2003
I sure hope someone can help. It seems no matter how many rules I have set
up for the term "viagra" and it's derivatives to be sent to the junk folder -
I'm still getting them in the inbox. I've blocked every address they come in
on, and set a rule for each version (lower case, all caps, space between each
letter, etc) and for each of these rules the #&* thing still goes to me
inbox. The rules have always worked before and still do for other spam
terms, but for this one word it won't work to put the email in the junk
folder. PLEASE HELP - I'm...Deleting of Recurring E-Mail's Outlook 2000
How do you delete recurring e-mails in Outlook 2000?
Do you want to keep the history of the recurring?
Do you want to "Cancel" future meetings and let other
Do you just want to delete it entirely?
Nikki Peterson [MVP - Outlook]
<email@example.com> wrote in message
How do you delete recurring e-mails in Outlook 2000?
...Can you work this backwards
Previously I used 3 simple formulas (if statements) to calculate a
charge, so if E9 =3D=A33000 then the formula for the charge was
Total Cost ... of above 3 items plus E9 (=A33000)
Now people are asking to spend a total of =A33000 including the charge,
so now Total Cost is to be =A33000 and then I have to work back to find
How is the best way to do this please.
Use the "Solver" utility in Excel.
Let us suppose ...how do I get the if function to return a blank cell, not 0?
I am trying to create a chart from a series that contains data for each
month. The series is calculated on other worksheets and copied to the
worksheet containing the chart. I would like to have the cells for the
months that have not been updated yet (now is January, there are 0' in all
cells for Feb-Dec) to be blank (to create gaps in the chart) not 0's.
Can this be done?
Unfortunately, what you want, and what many of us have requested but doesn't
exist, is a worksheet function like BLANK() or NULL(). The best we can do is
use NA() in a chart's data source, which is...work out how many trucks came in between the hours of 9am and 3pm
hi there l am after a formula which will calculate how many trucks came in
from the hours of 9 am and 3 pm on any day. the main information is in sheet
1 and l want the value to return to sheet 2. How do l do this? and what
formula is best to use.
A:A time in time out transport coompany amount of
1-Apr 4:00 5:26 LEOCATAS WJT982 BRIAN B 68 TATURA 656223 T15.02 68 1
1-Apr 4:06 5:45 LEOCATAS UMV991 DAVE B 68 TATURA 656224 T13.02 68 1
1-Apr 5:08 6:00 HUNTERS QZW243 RODNEY B 68 TATURA 656228 T17.17 68 1
1-Apr 5:50 6:25 LEOCATA...