How do I create a sample in Excel?
I am trying to create a sample, needing every 20th record out of around 3000
You need a VBA procedure.
Dim RowNdx As Long
Dim DestRng As Range
Set DestRng = Worksheets("Sheet2").Range("A1")
For RowNdx = 1 To 3000 Step 20
Set DestRng = DestRng(2, 1)
Microsoft MVP - Excel
Pearson Software Consulting, LLC
"Mary" <Mary@discussions.microsoft.com> wrote in message
news:ADE0AD7F-B459-41AE-8B2...OE6 can't start due to message store prob
"Outlook Express could not be started. The application was
unable to open the Outlook Express message store. Your
computer may be out of memory or your disk is full
This happens after I try to copy in backed up .dbx files.
...Can't create Organizational Forms Library in Exchange 2003 with SP
I cannot create an Organizational Form in EFORMS REGISTRY folder (from First
Administrative Group->Folders->Public Folders->EFORMS REGISTRY in ESM). When
I right-click the EFORMS REGISTRY folder and select New, there is no
Organization Form. Instead, I only see Public Folder in the popup menu. Do
you have any idea why Organizational Form menu does not show?
My Exchange Server is Exchange 2003 with SP2. The login user is Administrator.
Could you please help me? Thank you very much.
Is that account member of "Enterprise Admins" group?
Yang Zhang wrote:
&...How do I create a click on + symbol to open a root and click on -.
I'm looking to create an excel file with drop down menus.
I'd like to have a category. Click on the "+" symbol and the category opens
up and shows all of the subcategories.
Each category can further be opened if I so choose.
Each category can be have a number total associated with it.
When you click the "-" symbol. The subcategories close and the sum total of
all subcategories is shown in the category total.
example. creating a budget.
Category is utilities
sub categories are: phone, cable, electric, gas, etc...
Monthly utility total ...auto reply to incoming messages
SOS. I am having trouble with my Outlook 2002. I am trying to set up an "out of office assitant". It says i need to have Microsoft Exchange for this to work. So i went back to my Office XP disk and tried adding it in seperately and then i tried reinstalling Office XP, and still nothing. Anyone have any suggestions, thanks!
"Paul" <firstname.lastname@example.org> wrote in message
> SOS. I am having trouble with my Outlook 2002. I am trying to set up an
"out of office assitant". It says i need ...making filtering rules?
hi, i am trying to create a rule that goes something like
if (site1.com OR site2.org OR site3.gov) AND (agri OR agriculture OR
then move to folder X
that is, if it is from any of those sites AND has any of those keywords
then move it. The problem is i can't seem to figure out the specifying
the AND part. Any help/ideas would be greatly appreciated!
...limit the number of outgoing messages
who can I limit the number of concurrent outgoing messages?
for example: if I have a queue of 1000 messages, how can I force
exchange to send only 50 messages at a time?
...how create Quota filter in WIndows 2003 R2 using Script
I need create quota filter in Server 2003 R2 using vbscript. quota
filter should be applied to directories and not by users.
I searched information about it on google without success.
thank's in advance
First you need open your FSRM (File Server Resource Manager), then you
create a quota template, you must specify if your quota is "software" (just
monitoring, but never deny the user) or "hardaware" (deny users when they
use 100% of the quota), you must specify if you want send e-mail to user
when this user use...Creating a chart based on the data in an embedded worksheet
I have a worksheet with several embedded worksheets. I would like to
create a chart based on the data of one of the embedded worksheets
without putting the chart in the embedded worksheet. I have tried
unsuccessfully to do this. I just wondered if anyone knew how to do
You're embedding worksheets within worksheets? Why? Why not just insert
the worksheets in line with the main worksheet? To open or edit the
embedded worksheet, the parent Excel has to open another instance of
Excel, and the chart on the outside of this other instance will never be
able to acce...creating a spredsheet and log the info into another spredsheet
I have a excel sheet that is printed out and a cashier manual enters
information, invoice number, invoice amount, cash amount, check
amount, amex amount.... I would like to have the cashier input this
information on her PC and print a copy to go along with the deposit
and at the same time log the information into a google excel document
I created. Any ideas how this can be done?
...Outlook 2003 rules question again
I have a rule so that after the e-mail comes in, it searches for specific
words in the e-mail header. I set up this rule to search for sober.worm
since I'm receiving a copious amount of spam e-mails which include the
sober.worm attachment. I set the rule to delete the e-mails indefinately
but it does not delete it. It just sends the e-mails to the junk mail
folder. I would like to have it delete the e-mails forever. What can I do
to achieve this?
Nocturnal @ http://www.randomfix.com
Also, I did get it to work a few times but the rule stops working.
Another thing is if ...BCC view of already sent message(s)
Once I did send a message(s) to BCC recipients...How do I review or see whom
I did send the message in my "message sent folder?
Select the message in your Sent Items folder. Press Ctrl+F3.
Gary VanderMolen, Microsoft MVP (Mail)
<FoxBravoMetroDeltaOscar@discussions.microsoft.com> wrote in message =
> Once I did send a message(s) to BCC recipients...How do I review or =
> I did sen...Creating Exchange 2003 organization
Is it possible to have two Exchange Organizations in the same domain? I need
to reproduce a problem and was hoping to install an Exchange server to an
existing domain however I need the organization to be different. Is this
possible? When I installed EX 2003 I wasn't prompted for information other
than location of files.
Thanks in advance
On Mon, 28 Feb 2005 08:09:03 -0800, "RP"
>Is it possible to have two Exchange Organizations in the same domain? I need
>to reproduce a problem and was hoping to install an Exchange server...Carbon Copy of a message
when ever I get an email from 2 specific users the message always Carbon
Copies itself and I cant figure out why. So I end up with 2 of the same
Any help would rock
...Can't create the item #2
I use Outlook from MS Office 2003 Business Edition.
Everything has worked fine until the past few days. Now,
whenever I click on an E-mail address link inside a
webpage, I get a message from Outlook that says "Can't
create the item."
One person on this group gave me the following advice:
>Close Outlook, find and rename the frmscache.dat to .old
I did searches on all my drives and the file named above
was not found. I doubled checked the search to confirm
that it included hidden files and system folders in the
search. Still no luck.
Does anyone have an idea why I get this every week? (all zeros) I have
about 30 active mailboxes...? It should clean them up (I think) which would
be greater than zero!
The Microsoft Exchange Server Mailbox Manager has completed processing
Started at: 2007-02-11 00:05:07
Completed at: 2007-02-11 00:05:07
Mailboxes processed: 0
Messages moved: 0
Size of moved messages: 0.00 KB
Deleted messages: 0
Size of deleted messages: 0.00 KB
DO you have a mailbox cleanup policy in place?
IF so, what folders are you cleaning at what time frame?
"Len A" <nomail@nospa...Previous/Next in Outlook 2003 email message crash
I have Outlook 2003, when I opened an email then after reading it, I clicked
Previous or Next Item within my message, it crashed Outlook. Does anyone
have or seen this problem before, any fixes or solution? Thanks in advance.
...Zero to appear as blank
I have a VLOOKUP formula below. When the value is zero, I want the result to be blank. What do I do.
> I have a VLOOKUP formula below. When the value is zero, I want the result to be blank. What do I do.
In addition to modifying your formula as Dave suggeste...creating template for multiple emails
How or can one create an email template (same subject line
and message)for multiple emails (approx 100's)?
Needing to shorten the time it takes sending 100's of
individual emails (with the same subject line and same
message) to sales staff on a weekly (some times daily)
basis. Company does not want sales force using other
sales persons email addresses (they are contractors).
Try using a Distriburtion List, send one message, it goes to all of them, or
get the message ready, put your address in the TO: field, and put everyone
else in the BCC: field?? That way no one can see wher...Outlook error message
Unable to expand the folder. The rest of folders could not be opened. There are no additional Microsoft Exchange client licenses available. Contact your adminstrator to obtain a client license to use Microsoft Exchange
This is the error message that our clients are receiving when attempting to open outlook version 2000 or above to Exchange Server 5.5 SP3 server. We do have the available licenses and have already set them up in license manager on the server and then license logging service is started. We keep having to stop and start the License Logging Service and then they can get in fi...Duplicate messages coming into inbox
We had a problem with 7040 messages re-coming into our inbox from June 2009
through April 2010 this past Saturday. We had turned our computer off for the
first time in 30 days. We are using 5 different email accounts within the
same version of Outlook and only the MSN email account gave us duplicates. We
called their support and they said there was no server outage or anything
that might have caused this duplication. Now we're trying to find the Outlook
set up that might be causing the problem. All of our email settings use
POP/STMP in Tools/Account Settings on the Email tab....How do I create upper/lower case letters in cells?
I have a large spreadsheet with names/addresses that are all capitalized. I
want to make them upper and lower case (SMITH = Smith). What's the formula?
You could create helper cells with this formula
> I have a large spreadsheet with names/addresses that are all capitalized. I
> want to make them upper and lower case (SMITH = Smith). What's the formula?
...Rule Wizard: "Rules In Error"
I have a blackberry, and I have my outlook forwarding
emails to it, but about once a day, I get a message that
says "Rules in Error: Error in Rule Execution" and it
won't forward any emails after that. I only have one
single rule, so it's not a rule conflict. Does anyone
know the deal? This is extremely frustrating as sometimes
I'll be out of the office during the weekend or at night
and won't receive any message for hours on my blackberry,
only to find out later that this "Rules in Error" dialog
box popped up and it won't forward emails. It see...Result in message box
this is second time iam posting this ,,kindly help me
a form contains button which runs a query like
select count(field1) from table t1 ... then normally we will get a spread
sheet window containing result in a single cell, let say answer is 85.
now when command button is clicked then a message box should appear
displaying the result 85..
please give coding also if required.....
naveen prasad wrote:
> this is second time iam posting this ,,kindly help me
What was wrong with the reply you've already received? Please reply in
your origina...Add message to customers on printed invoice
We should be able to add a message to customers (holiday hours, holiday
message, etc.) to an invoice. Even QuickBooks has this ability, why doesn't
Director, Information Technology
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.