Limit number of Recipients
Under SMTP, in Exchange 2003, there is an option to limit the number of
recipients. It splits the outgoing mail into multiples of 100 (default).
However, most Service Providers seem to block any email that have more than
25 recipients. This option is not allowed. Is there a way to make this option
accept Limit Number of Recipients to 25 instead of 100?
On Sun, 25 Feb 2007 23:54:05 -0800, Paul
>Under SMTP, in Exchange 2003, there is an option to limit the number of
>recipients. It splits the outgoing mail into multiples of 100 (defau...A big problem for me to synchronizate the data in excel
there are 6 groups of data,each including a datw col and an 'equity'
the beginning date,ending date,and the date in this period are not the
I wanna to match the equity data by the date (that's,make the date
synchronizated)and sum them up each line
(the result of a blank line = the result before it)
for example,there are 2 groups of date
so I wanna...I need a message if number of duplicate records exceeds number allowed
Thanks in advance for any help. I'm trying to create If DCount code on my
form that will count the number of duplicate records and then notify me when
the number of duplicate records exceeds the number allowed. The number of
duplicates allowed is established in tblFloorProgCriteria in the field
FloorProgMaxObservations. Here's what I have so far...It's giving me the
message as soon as I attempt to add the first record.
If DCount("*", "tblFloorProgAudit", "[AuditID] = " & Me.[AuditID] & "
And [FloorProgCriteriaID] = "...Auto Generate Serial Number
We have an issue where an Item is set to Serial Number Tracking. Every
Receipts is around 300 units and need to enter the Serial Number for every
item. The Item has sequential numbers received from the supplier in a given
range e.g. from 1 to 400. the Serial Number is 20 chars long and a bit time
consuming to enter in GP.
Is their a product/function that can do this?
How about going into the serial number setup for the item before entering
the receipt, changing the starting value, then during the receipt entry
having the system auto-generate the numbers? This will only work if they
ar...hovering cursor over footnote number in text
Operating System: Mac OS X 10.5 (Leopard)
I used to be able to hover the cursor over a foot/end note number in the document, and a mini window would show me the note text. All of a sudden, my cursor no longer works this way. I don't think I changed any settings, but can anyone tell me how I might fix this? <br><br>Thanks!
Check another document: is that the same?
You may have converted that footnote to hard text at some point, in which
case there is no note text to show.
Sorry: I can't think of anything else...
On 11/03/10 5:32 AM, in article...Number of different cell formats
I have an excel file, which I can't opened because it has already too many
different cell formats, which I solved by formatting, but
is there a way how can I see a statistic of the number of formats used in
one file (out of 4000 I think), in order not to find my self in a same
situation in the future,
thanks in advance
Excel must maintain a count somewhere in order to trigger this error,
but I don't think it is readily accessible.
The thing to do is to cut down on the number of different formats in
your workbook - don't go mad using lots of different type faces and
font siz...Editing Footnotes
How can I change how the footnotes appear at the bottom of the page in a
document that already exists with footnotes in it?
Issues are: (1) Sometimes there is one space, (2) sometimes there is a tab
before the footnote text -- both of which I think I've handled in the code
below, and (3) in rare occassions, there is no space before the footnote text
-- and I have no idea what to do in that case!
I want to programatically edit all footnotes to appear with two spaces
before the footnote text.
Can someone please take a look and advise me (1) have I dealt with the first ...Number of worksheets #3
I am using Excel 97.
Apparently Excel 97 can only support 255 worksheets, but I have a workbook
which has over 400 worksheets!
Can someone please tell me how and why the software has allowed it and what
are the implications if any?
If it does support it without any problems what would be the absolute
maximum number os worksheets it could hold?
The number of WSs is limited only by the memory on your machine.
That 255 number is just the number of sheets that can be created in a new WB
Set the option to 255 sheets for a new WB.
Open that new WB.
Right...numbering text boxes?
Is there a way to number text boxes in a document? I'm trying to create
coupons that I can number, putting 3 to a page, so I'd need to number the
text boxes rather than the pages.
Mail merge... Setup a data base list with numbers.
Lots of help here
Mary Sauer MSFT MVP
"Lisa" <Lisa@discussions.microsoft.com> wrote in message
> Is there a way to nu...Giving a duplicate cell a number
say in column A i had a cell which had "Horse" in it , and it said
"Horse" in randown cells in column A , what formula could i use in
column B so that everytime it recgnised "Horse" in cell A is would
give it a unique number
ie Horse featured in cells
So in the coressponding cell in column B it would have 1,2,3,4 etc
A1 = HORSE B1=1
A4 = HORSE B4=2
A7 = HORSE B7=3
Thanks for any help
scottymelloty's Profile: http://www.excelforum.com/member.php?action...Finding pairs of numbers
Is this possible? I assume this will involve some VB coding also:
Part Num Associated Part Num
Formula in "C" that would find the mate and insert a "Pairing" number
So that the 1st and 4th rows would have a 1
and the 2nd and 7th would have a 2 etc
This subroutine will do it - change the range in first statement to suit you
Set testrange = Range("A1:C20")
For j = 1 To testrange.Count - 1
testA = testrange(j, 1) & testrange(j, 2)
I have a created an Excel spreadsheet for printing labels.
I need to be able to incrementally increase each label count by one, which I
can do with no problem. I can not figure out how to increase by one if there
is a word in front of it.
Example the first label would be: WORD 1001
The second label would be: WORD 1002
The WORD would stay constant, but the numbers would change. I would also
like display a dialog box to ask the user what the starting number would be
and then automatically prefill the sheet.
Any suggestions? Thanks, Jeff
not sure this is the best way but here is how i ...Workbook Numbering
In Excel XP, I have multiple worksheets in a workbook.
In the footer for each worksheet I am trying to insert the page number
regarding the total number of pages in the entire workbook (i.e. Page
10 of 25).
I group all the sheets together yet for each sheet, the page number is
just listed as page 1 or 2 for that sheet.
Can anyone help?
You need to print the sheets as a group. So select all of the sheets and then print
----- Jason S wrote: ----
In Excel XP, I have multiple worksheets in a workbook
I...How do I add footnotes in Publisher? #2
How do I add footnotes or endnotes to a passage in Publisher? Is it
possible? I know in Word you go to Insert->Reference->Footnote, but there
isn't a "reference" tab in Publisher.
Hi kgoff (email@example.com),
in the newsgroups
|| How do I add footnotes or endnotes to a passage in Publisher? Is it
|| possible? I know in Word you go to Insert->Reference->Footnote, but
|| there isn't a "reference" tab in Publisher.
Publisher doesn't have this feature. You have to create them
manually...usually using superscript etc.
...This item has exceeded the budget for account number.
I am getting a recurring error message which prevents a user from entering
in an expense into eReq because the system considers the account over budget,
when in fact it is not. To correct the error, the origin of which we are
still uncertain, we were instructed to run File/Maintenance/PO
Enhancements/Reconcile. We received this message several times today and ran
the utility which did not have any impact on the situation- the error message
continues to pop up (i.e., for 53300-1650-000 Finance Office Supplies).
The exact error message is:
This item has exceeded the budget for...Footnotes
Operating System: Mac OS X 10.5 (Leopard)
How do you restart footnotes with Number 1 in each chapter of a document?
I also can't remember how to do it, but I would do it by first looking
in Word's Help. You can search for "footnotes" and you'll should easily
find the article "Restart footnote or endnote numbers".
On 12/05/10 13:40, firstname.lastname@example.org wrote:
> Version: 2008 Operating System: Mac OS X 10.5 (Leopard) How do you
> restart footnotes with Number 1 in each chapter of a docu...Random number generation
I've got a table of numbers - that are sequential but not consecutive
Is it possible to Randomise them - I.e make them non sequential?
Tel: 0788 151 8442
Take a look at the first technique here:
In article <#MdKkD#OGHA.1312@TK2MSFTNGP09.phx.gbl>,
"Alan Davies" <email@example.com> wrote:
> I've got a table of numbers - that are sequential but not consecutive
> Is it possible to Randomise them - I.e make them non sequential?
The URL needs to have .html at the end of it...Changing footnotes to endnotes
How do I change footnotes to endnotes in Word 97?
Steve Hayes from Tshwane, South Africa
E-mail - see web page, or parse: shayes at dunelm full stop org full stop uk
Not sure about Word 97, but in 2000 and 2003 go to the Footnote reference
create dialog, in 2003 this is under Insert, Reference, Footnote, on this
dialog there is a Convert button, clcik this and you have choice of
Converting All Footnotes to Endnotes, Converting All Endnotes to Footnotes,
and Swap Footnotes and Endnote...Excel number formatting
Operating System: Mac OS X 10.6 (Snow Leopard)
I have a problem formatting some of cell in a sheet to currency of accounting. I've tried everything from copying and pasting the number formats from other cells,but without any success.
Sorry to hear that you have "a problem" but it would be a big help to also
know what that problem is -- How does it manifest itself? Without some
degree of descriptive detail we're even more in the dark than you :-)
Are Office (12.2.3) & OS X (10.6.2) fully updated?
Have you re-launched Excel rece...pick a number from 1 to 10
I would like to have a web page where Internet users can go pick a number
from 1 to 10. However, once a user picks a number that number should not be
used again therefore that number belongs to that user.
How do I manage if, let's say, 2 users happen to pick the same number at the
very same time how do I prevent that from happening? Is that a concurrency
"rodchar" <firstname.lastname@example.org> wrote in message
> Hi All,
> I would like to have a...Comparing numbers in cells and highlighting matching numbers
We have a lottery syndicate at work with fixed numbers that are put on every
week (6 from 49 with 12 rows) These numbers never change so I can put them
into 12 fixed rows. Each week I want to key in the 6 numbers that have been
drawn and if there is a match in any of the rows for each of the 6 individual
numbers I want to highlight the corresponding number in the fixed row, say
blue. If all off the numbers in a row come up (most unlikely) I would want
all of the numbers to flash red and have a sound sample play. I have looked
at the conditional formatting but it will not do it for t...how to use a negative number
I have a client that gave me a deposit for a service. I was paid this deposi
last year. I now have made a invoice for this service with Money Home and
Business 2007. How can I show that I have already received $200 towards this
service? Money will not let me use a negative number So how can I do this?
Can't say for sure as I've never used the * Business * editions, but you may
have to use an income category to categorize the amount. IIRC, it has been
reported that the * Business * editions don't allow calling income expense
and vice versa.
Sadly, next to no users of * B...Transaction by vendor
This would sometimes be quite helpful if in Payables Management. On the
Transactions by Vendor screen, for invoices that have been paid I would like
to see which check(s) paid for each invoice.
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.
http://www.microsoft.com/...Excel deleting some numbers from an excel document
I have a spread sheet that has (example) numbers in a cell 45% (5/11) in a
cell or 60% (60/100) in a cell. I have hundreds of cells each with different
series of numbers all with a 1-2 or 3 diget % and two numbers in (). I want
to delete the number in parenthesis and the parenthesis. I can do it cell by
cell but I figure that there should be some way to reformat the cells to do
it in mass
Microsoft MVP - Excel
"Seth" <Seth@discussions.microsoft.com> wrote in message news:B1383B72-E904-457B-BB5F-EC0573D1...Changing the number format
I am using Excel 2000. I am running Excel with the regional setting
set to Germany. So, Excel interprets "," as a decimal point. What
want to do is make one particular workbook interpret "." as the decima
point. However, I cannot change the regional settings on my PC.
Is there any way to tell Excel 2000 to interpret "." as the decima
point. I went to "Format", "Cells", "Number". However, I cannot chang
the "," to a ".".
I hope I am clear enough. Please let me know if I need to clarify a bi