Is there a way to get an auto page break as data changes in Excel.
I list my students by grade and by teacher. Is there a way to force a page
break automatically as a specific piece of data changes (ie; teacher name,
only possib le using VBA.
"george_visalia" <firstname.lastname@example.org> schrieb im
>I list my students by grade and by teacher. Is there a way to force a page
> break automatically as a specific piece of data changes (ie; teacher name,
> grade, room)?
If your teacher n...Outlook 2000 refuses to receive internet email
I've got 1 system running Windows 2000 Professional SP4 with Outlook 2000. It
has account settings for both Exchange and internet email. The Exchange mail
comes through with no problems, and I'm able to send through the internet
mail. However, Outlook will not receive anything from the internet.
I've fixed this in the past by removing the setup and reconfiguring the
accounts, but the last time it has not worked. Outlook Express has no
difficulties receiving the email from the internet account.
Any help would be greatly apprecitated.
Which is the default?
Milly S...repetitious emails
I have recently upgraded to Outlook 2003. I am getting the
same emails into my inbox 7-8-9-10 times and they are not
being deleted from the server.
BigZoo.net is the server. I have tried deleting my POP3
account from Outlook and setting up again--that didn't
solve the problem.
Frustrated in Redmond
Do you have a firewall/email scanning software installed and set to scan
incoming mail? If yes, disable that portion of the program.
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the (insert latest virus name here) virus, all ma...Auto reply #4
I was just wandering if there is a way to Auto reply to
emails you receive, if you are gonna be gone for like a
See if the information on the following page helps:
MVP - Outlook
*** Replies sent to my e-mail address will probably not be answered --
please reply only to the newsgroup to preserve the message thread. ***
"Jeff" <email@example.com> wrote in message
> I was just wandering if there is a way to Auto reply to
> emails you receive, if...Auto reply on sent once to each recipient.
We are using Exchange 5.5 sp4 on Win NT 4.0 server sp6a and varied client
setup of Win 2k SP3 / office 2k sr1 or NT 4.0 sp6a / office 2k sr1.
When Out of office reply is swicthed on, people who send the Out of office
mailbox an email will only receive the out of office autoreply the once.
Every time they send an email after that they do not receive the Out of
office autoreply even though the reply is switched on. If how ever the Out
of office is switched off and on again, the process will start again, only
one auto reply will be sent to each sender.
I have found MS KB article 1579...How can I use my Access list to email selective groups?
How can I use an Access List to email selective groups without having to go
to my Outlook Address Book?
Does anyone know how to set up money so that it will
automatically categorize charges to a particular payee to
a cateogory? Currently only some of my credit card
transactions come with a category and it will be too much
work to categorize the rest of them. Also without
categorizing transactions then the reports do not make
Perhaps personal finance management is too much work as well.
"Jeffrey Sanders" <firstname.lastname@example.org> wrote in message
> Currently only some of my credit card
>...forwarding an email fails to open Word
Outlook seems to work like normal when I open it, until I
try to forward something. I've never had a problem until
When I click on "forward", it attempts to open MS Word and
just hangs there...
Any suggestions for trouble shooting or resetting
...unable to send email #9
When i am at home i can rec and send email with outlook express.
when i am at work on their wireless system I can rec emails but I can not
send them? is there any way to fix this?
now with aol I can rec and send without any problem.
Yes, change the sending (SMTP) server name to the one used by the ISP your
workplace uses. Most (if not all) ISPs require you to be connected to their
network in order to use their SMTP server. At home, you're connected to
your ISP and can use his SMTP server. At work, you're connected to your
workplace ISP, your (home) ISP detects this and prevents yo...Auto Number Concern
While looking at my tables, I noted that the AutoNumber has changed
radically. Expecting the table to continue building on the three digit
autonumber, I was surprised to see 10 digit autonumbers appearing and at
times preceded by a minus sign. What gives? I created a master with a
replica...is this the source for the change? Thanks Cheese
Yup: when you use Replication, the AutoNumber field is changed from
Sequential to Random. There's no way for you to change that behaviour.
Fortunately, it doesn't matter. The only intent of an AutoNumber field is to
provide a (practically ...How do I "auto save" my file in MsOffice2003 Exel?
Dave Peterson's reply to a similar message may help you:
Excel FAQ, Tips & Book List
...Incoming Email processing
Is there a way to change the email color or the icon before the email when a
new email comes in .. only from ppl not from *@mywork.com ?
I'm not sure if this is quite what you're looking for
but it will give you a little information on how to go
about it. These instructions were written using
Outlook 2000 as the model:
OLK - Color SMTP msgs
Click "Using Colors"
Click "Automatic Formatting"
Click "Add a Rule"
Call it something like SMTP
Click "Condition" and select the "Advanced" tab.
Click the &...Need help with Time
Hello fellow Excel users. I've researched this group and view PERSONS
site on time...but I'm not able to come up with the correct formula.
I'm trying to create a project timesheet our tech use in the field.
However I can't get the standard time and the prime time formulas to
A1 = Name - Manually Entered by User
B1 = Travel Start Time - Manually Entered by User
C1 = Travel Stop Time - Manually Entered by User
D1 = Project Start Time =C1 - Locked Cell-Automatically is Travel STOP
E1 = Project Stop Time - Manually Entered by User
F1 = Total Proje...Appending Disclosure to Outbound Email
I need to append a disclosure to all outbound emails on my exchange 2003
server. Could someone please tell me the best way to do this? I can't seem to
get my searches narrowed down on Microsoft.com. I know it has to be there
On Mon, 19 Jun 2006 11:51:01 -0700, slawrie
>I need to append a disclosure to all outbound emails on my exchange 2003
>server. Could someone please tell me the best way to do this? I can't seem to
>get my searches narrowed down on Microsoft.com. I know it has to be there
&g...Auto Forward Problem...
Is there a way to set auto forwarding to an address not in the global list.
I 've tried creating a rule to do this ... but it's not working.
I would just like to check for mail from a specifc user and send any
that come in to email@example.com
thanks in advance...
> Is there a way to set auto forwarding to an address not in the global
> list. I 've tried creating a rule to do this ... but it's not working.
Rules aren't the best way to do this anyway - see
http://www.msexchange.org/tutorials/MF015.ht...Auto protection of cells
I have the Dates in Column A , I want to protect the cells in Cloumn
B , based on todays date .This needs to be done automatically w/o
going to format cells , protection . How to do that ?
I mean noone can make any entry to the date other than Today's date
Try Data Validation.
Select Select cells then to get into data validation:-
xl2007 version: Data tab on ribbon->Data tools block->Data Validation
pre xl2007 versions: Menu item Data->Validation->
In allow field: Select Dates
Data field: Equal to
Uncheck Ignore blanks
In Formula field: =today()
Regards...create a mailing group of 645 contacts for marketing email
i would like to create a mailing group of 645 contacts for monthly marketing
info. any suggestions?
"cweed" <firstname.lastname@example.org> wrote in message
> i would like to create a mailing group of 645 contacts for monthly
> info. any suggestions?
Are these recipients already in your Contacts? If so and if your version of
Outlook supports it, use a Category for that number rather than a
I'd use a commercial newsletter service. Or mail merge.
-- ...Annoying emails
I keep getting around 15-20 emails a day that says things like 'Mail
transaction failed' or 'Here are your bank details' and all have
attachments containing a virus. I believe form reading about it on the
web that it is due to another person having a virus and my email
address or domain name on their computer.
I have Norton scanning all incoming mail and stops the virus before it
attacks, but this takes time. Last night I had 33 such emails, and it
took 5 mins to download rubbish and viruses.
So my question is, is there any way to stop these or do I have to live
with t...Auto tab- Auto fill
I'm looking for a general formula for the entire worksheet. My secretary
spends extra time looking for the proper column each time she subsequently
enters a vendors name .
Is there some formula that would recognize the second (third, fourth, etc)
time a vendors name is entered and auto tab to the column that was last used
for that vendor? Also, the same for many different vendors on the same page.
Same question a different way: if the vendor's name were entered a second
time and a different amount were entered could that amount be auto filled in
the column that was used p...Open email on desktop and/or laptop
Sometimes I open/view my email on the desktop and sometimes on the
Problem is, if I open my email on the laptop yesterday, then open
messages on the desktop today, yesterdays messages will not show on
How do I set outlook to leave messages on the server so both desktop
and laptop will receive all email messages ? Using 2007
Go into your account settings and choose More Settings... . On the Advanced
tab you can set the "leave on server" option. Make sure you set at least one
to eventually delete the message or you might run out...Deleting login email address
Does anyone know how i can change my shared calender login detail from a
hotmail account to a live account?
Go to tools, account settings, internet calendar and delete the hotmail
account. Then add the correct account.
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
EMO - a weekly newsletter about Outlook and Exchange:
Poll: What version...Outlook 2003: No Longer Able to Download Email Pictures
Why after the november security updates do I not have the ability to
download pictures from an email that I know is safe. I have gone into the
security settings and adjusted those buttons but I have no list bar any
longer asking if I want to download the pictures in any email.
If you checked the email settings and they are correct I am not sure
what the problem is but I wanted to let you know I'm running 2003 with all
of the latest MS updates including this weeks changes and I have no problem
with downloading pictures.
Have A Great Day!
I am havin...Bank Reconciliation and posting adjustments to a closed period
We have run into a small "problem" with Bank Reconciliation on GP 7.5.
This is our first month attempting to use a more automated
reconciliation, however, we seem to not be allowed to post the
adjustments listed on the statement if the period is already closed.
Accounting receives the bank statements after the end of previous month
financials are done (they have to have them done within the first week
of the new month -- and the bank statements haven't arrived yet) and
the previous period is already closed.
How would you post the service fees and interest income say for ...email sends YES, reply NO, forward NO
Subject: Re: NO forward or reply in outlookXP
From: "Eileen" > Sent: 7/13/2003 2:40:08 PM
My account server properties ARE set to authenticate. I
CAN send email. What I CANNOT DO is REPLY to or FORWARD
and email. The error pops up immediately upon clicking
the SEND button...before it leaves my PC (or so it seems)
>Simple - you cannot send mail through a server to which
you are not
>connected "relaying denied."
>You need to set your account server properties to allow
you to authenticate.
>...Outlook 2003 SP2
When I receive a reply to an email from one particular person, the email
appears blank in the reading pane and when I open it. If I turn on Auto
Preview I can see the first few lines. If I attempt to reply to he email I
see the following characters appear as if they were in the email 'ÿþ'. I have
the same version of Outlook on two machines, and this problem only occurs on
one of them. I rebuilt the PC and the problem persisted. I've seen various
posts about using the following command line prompt but this appears to make
no difference. Any suggestions