limit number of rows 7 colloms in a worksheet
is there a way to limit or set the number of rows & collums in a
Message posted from http://www.ExcelForum.com/
"davidbrowne17" <email@example.com> wrote in message
> is there a way to limit or set the number of rows & collums in a
> worksheet ?
No. All worksheets have 256 columns by 65536 rows.
You can hide unused rows/columns. But why bother?
Put this in the ThisWorkbook code module. Adjust to suit the area.
Private Sub Workbook_Open()
Wo...Mail merge file sizes
Can anybody help me.
I have produced a 2 page document in Publisher 2003 and when I add mail
merge to it with a database of 500 addresses, when it generates I get the
1. It takes ages to generate (the green progress bar moves very slowly
across the screen as it applies the address to each document
2. The file sizes are at least 300mb for each 10 that it generates (the
original file size is less than 2 mb)
Any help would be appreciated.
This will help
The Registry Fix
for changing the Mail Merge Batch Size
Courtesy of KATMA
http://ed.mvps.org/Static.aspx?=Publisher/r...Outlook Express e-mail
I have lost all of the columns to the right side of "FIND"
including "DELETE" this happened suddenly when I logged on
my computer this morning. This has never happened before
and I am not aware that I did anything to create this
problem. Please advise how to restore to normal. Thankyou.
...Windows 7 Mail Question
Does Windows 7 have an included email application? If so, does it support
IMAP, POP, SMTP, EXCHANGE and HTTP email configurations?
"Frankster" <frank@SPAM2TRASH.com> wrote in message
> Does Windows 7 have an included email application? If so, does it support
> IMAP, POP, SMTP, EXCHANGE and HTTP email configurations?
> Thank you.
Windows 7 does not include an email program.
I use the free Windows Live Mail,(http:\download.live.com) but ther...Rules and Reply-to E-Mail addresses
I have tried searching through the solved questions listed here and did not
find anything that solved my problem, but please let me know if there's
something I've missed!
I receive many e-mails from firstname.lastname@example.org.
The e-mails have a different reply-to address from the one above.
Now normally, I click reply on each of the hundreds of emails, and paste in
the same response. This works fine, but is time consuming.
I thought I could use a rule to simplify the whole process.
My problem is, in my rule, when I select reply using specific template, it
replies to the ...Wrong Massage Size, Mail in Queue, Greylisted Mail
we use a Tool that attach a Disclaimer over SMTP-Sink. The Disclaimer
Original-Massage-Size e.g. 968
after added the Disclaimer Size are e.g. 1464
Then the Exchange try to send the correct Mail incl. Disclaimer with Size
OutboundConnectionCommand SMTPSVC1 MyExchServer - 25 MAIL -
FROM:<email@example.com>+SIZE=1464 0 0 4 0 422 SMTP
The received Mail-Server has greylisting or something and my mail cannot
deliver at first time: (SMTP-Code 451 or 450+4.7.1)
My Mail...What is the Outlook keyboard shortcut for checking new mail
"Steve Jaeger" <Sjaeger1@elp.rr.com> wrote in message
If there is a coded shortcut for a menu item, you will see it on the
rightside of the menu. If you open Tools -> Send/Receive ->
Send/Receive All, you will see F9 listed on the right.
Also, it is considered impolite to use only the Subject line to carry
the body of your message.
** Share with others. Post replies in the newsgroup.
** If present, remove all "-nix" from my email address.
_________...last couple of days mail is in junk e-mail that is safe.
like all @facebookmail.com is going there and I have that on my save senders
list. and people I have been getting mail from for months are now showing
up in junk email. and it doesn't matter that I tell the junk email to not
consider them as junk. I went to junk email properties and switched from
high sensitivity to lower and still facebookmail is going to junk... what
do I do now? charlie
...How do I get my e-mail to be sent to Microsoft Outlook?
I have recently been introduced to Microsoft Outlook. My e-mail address is
from comcast, and I am unsure of how to get my e-mail from my comcast e-mail
address to appear on Outlook. Please help.
In general, comcast will have to support POP3 E-Mail (for E-Mail that
you receive) and SMTP E-Mail (for E-Mail that you send) (there are some
other formats supported as well, but POP3 and SMTP are the most common).
Assuming that it does, you need to enter the proper parameters into
outlook (basically server names, account IDs and logon passwords). Once
you have done this, you ca...How do I limit clients email attachment size
We want to set a limit on users attachments as it kill the bandwidth
available. Is it a group policy setting or is it a client config within
"spbembr" <firstname.lastname@example.org> wrote in message
> Hi All,
> We want to set a limit on users attachments as it kill the bandwidth
> available. Is it a group policy setting or is it a client config within
Seems that would be a quota setting that you would configure in the mail
_____________...Creating Postcard 2 UP & 2 sided with Mail merge
Good morning. I hope that some one can help with the design and setup for
doing the following:
1) Postcard 8.5 by 5.5 (basically half of 8.% X 11 letter paper).
2) Print on both sides
3) Mail merge on both sides
How do I set it up so that I can have 2 postcards to be printed on 1 sheet
using either one of MS Publisher or MS Word? (prefer Word)
I know that my printer does it.
First, I already have the design in both MS Publisher and MS Word.
I also have the mail merge done.
Page Setup: Width 8.5 Height: 5.5
Paper: Letter (8.5 X 11)...Toolbar with different icon sizes
I am developing an Internet Explorer toolbar. Most of the buttons have
icon sizes of 16x16, but one of them has larger width (80 pixels).
Since a toolbar expects all icons to have the same size I have to do
something special if I want to add this button.
The solution that I am currently experimenting with is to make a
second toolbar which is a child window of the first toolbar. This
second toolbar contains only one button.
This seems to work a little. I can position it correctly, but the
problem is that the second toolbar is entirely black. If I move the
mouse cursor of it, it highlights a g...Controlling Workbook File Size?
I have a workbook that has recently increased from 5meg to 30 meg. There are
no pivot tables -- only a couple small macros that involve a few lines of
vba. What could have caused the jumped.. and what can I do to fix it?
The last used cell on each worksheet is way past where you think it should be.
See Debra Dalgleish's site to reset this last used cell.
Any chance you have objects (pictures/buttons/textboxes) in your workbook?
Sometimes pictures get duplicated by error.
> I have a workbook that...SMTP Relay Server and Mail Aliases
I have front-end and back-end Exchange.
I do not want that my front-end Exchange has SMTP relay functionality.
I want to deploy a SMTP relay server in DMZ.
My problem is:
This SMTP relay server is not a member of my Exchnage AD domain and does not
know about mail aliases in my Exchange domain. I do not want that I open
additional ports on firewall which is between my Exchange domain and SMTP
My question is:
How can I inform that SMTP relay server knows about all mail aliases on my
"mustafa" <email@example.com...Exchange 2003 not receiving mail
I have installed exchange 2003 on our network and I am receiving mail from
about 50% of our customers/vendors. They get no errors back when sending
and I see nothing on our servers side to indicate a problem.
It always takes about 5 minutes to receive any messages that come through,
which isn't a big deal but it seems like that should be faster.
We also just moved to a new ISP and have a full T1 connection so the
connection shouldn't be a problem. Today I had them add a reverse DNS
record for our ip because I have read that some servers use that as a spam
blocker. I am not sure...Outlook Express Mail Rules Problem
I'm using OE 6.0 on my home system and have a number of rules setup to
either move incoming mail to specific folders or to delete it based on
subject or message content. The delete rules are the last ones in the list.
I've recently changes a couple of rules and now I find mail being deleted
which should have been moved into a folder.
The rules look okay.
Is there a registry key or a file somewhere in the system which might be the
MS Training and Consultancy
Since Outlook Express is part o...opening forwarded mail
I have looked through all my setting and still can't figure this one out.
When someone forwards me a message that they received, i will sometimes get
it as a small envelope (attachment). When I double click on it, nothing
happens. When I save it to my desktop, it isn't recognized. But, when I open
it with my webmail there isn't a problem. I can double click on pictures and
they open fine, but not these types of email. Does anyone have anything they
can assist with so I don't always have to go through my webmail?
dreamer <firstname.lastname@example.org> wrote:
>...Using a listbox selection to limit records in a form and report
I am trying to use a listbox of names to limit the results of a form to just
those names. On a similar track, I want to use the selected names to limit a
report. I have the listbox created and have added a button next to it to
initiate the next step, but cannot figure out how to do it. Also, would like
to (if possible) use multiple listboxs in the same way (ie, name and/or
"dascooper" <email@example.com> wrote in message
>I am trying to use a listbox of names to limit the resu...reduce size of mail store?
I've been gradually reducing mailbox limits and forcing users to archive to
reduce the size of the mail store. However it does not appear to be
shrinking. I thought daily mainteance routine would compress. Is there
anything to do other than an offline compress and defrag? I really don't
want to have to do that unless as a last resort.
Is your server running low on diskspace or are you having performance
Jason T. Parker
> I've been gradually reducing mailbox limits and forcing users to
> reduce the size of the m...Two e-mail programs simultaneously
I am using gmail for e-mail. I use the e-mail program Windows mail. But I now
have two computers. I would like to open my e-mails on the new computer too,
in a neat e-mail program. Outlook Express is pre installed so I want to use
that. The new computer (a netbook) operates with mobile broadband, they
stationary computer gets internet from cable.
Computer 1: (stationary)
Runs on broadband, Internet Explorer 8, Windows Vista, Windows mail
Computer 2 (netbook):
Runs on mobile internet, Internet Explorer 8, Windows XP, Outlook Express 6
I have configurated my e-mail acc...Recovery of Mail Stores
I have a department in my school who had exchange(2000) server (200) that
I recovered the exchange folders.
No backups were ever made.
We installed windows Server 2003 and exchange server 2003 on a new server
and would like to get the mail from the 2000 server imported / recovered /
migrated into the 2003 server. What is the best way to go about this ?
If you have the MDBDATA folder, then you have your Exhange Databases. You
can build an offline recovery server to recover your users mail or use third
party tool such as Ontrack Power Contro...Mail validation using rules.
I have some questions for Outlook 2000:
- - - - -
I prefer to validate incoming mails using rules checking the sender against
a whitelist of addresses and domains. To my knowledge this is rather
unhandy to implement in Outlook 2000 because the addresses must
be in my addressbook/contact which can not contain domains only
Hereby I have to maintain a long list of rules just for this validation
I wonder if there is a possibility somehow for using simple textfiles
(1 or 2) containg valid addresses and domains handled by 1 or 2 rules.
Or maybe there is another way around i...Outlook Connector and Live Mail Plus
After some fighting, I migrated my Hotmail Plus to Windows Live Mail Plus.
I had to ask the customer care to unlock some issues that avoid this product
After this activation, I quickly checked Outlook Connector to see if
calendar, contacts and mail properly sync with MS Servers (this was tha main
reason to ask for a migration from Hotmail Plus to Windows Live Mail Plus).
Sadly, only partial synchronization allowed.
This is the log:
Outlook Connector Version 1.8.3501.0
Signed in successfully ...Please stop e-mails
The virus found was: W32/Swen.A@mm
...mail does not find temporay directory to open attached .xls file
Since few weeks, I cannot open attached .xls file, for the temporary
directory is not found. I bypass it by saving the xls file in a a folder and
then open it from there. It does't work if saved on desktop. All other
attached files, pps or world, are ok
Are all your Windows Updates current?
I seem to recall there was an update for IE8 a couple of months
ago which fixed the failure to open attachments.
Gary VanderMolen, Microsoft MVP (Mail)
Microsoft MVP program: http://mvp.support.microsoft.com