Can I use "find / replace" to automatically "Insert Rows" in a do.Have a long column of numbers
Every time I see the number 5, I need to insert two rows. Doing this by
hand is tedious. Can you help me find a shortcut?
The IF function does not do this, right?
Not 25, 35, 5351, just plain old 5?
Option Explicit
Sub testme01()
Dim FirstRow As Long
Dim LastRow As Long
Dim iRow As Long
With Worksheets("sheet1")
FirstRow = 1
LastRow = .Cells(.Rows.Count, "C").End(xlUp).Row
For iRow = LastRow To FirstRow Step -1
If .Cells(iRow, "C").Value = 5 Then
...
Exchange Rules for All UsersHi!
Is there any way to write a rule on the Exchange Server applied to ALL
mailboxes?
I want to write a rule like this:
If sender address domain IS NOT @mydomain.it AND destination_address is
all@mydomain.it THEN DELETE message
I have Googled . but I cannot find anything about ..
TAL!
Is all@mydomain.it an internal distribution group?
Stating your Exchange version when you post such questions helps!
You can simply use Recipient Filtering to drop messages for that recipient.
Also for distribution groups that shouldn't accept mail from
internet/unauthenticated senders, you can modi...
synchronize 2 exchange 2003 serversHello all,
How can i sync. 2 exchange servers ?
Is this possible with InterOrg ? (i want also sync the GAL)
thnx,
Mel.
Since these are 2003 servers, you need to sync AD's, really. I don't think
that the old InterOrg product will work for you, but MIIS might.
http://www.microsoft.com/windowsserversystem/miis2003/techinfo/planning/miisgalarch.mspx
"mel" <anonymous@discussions.microsoft.com> wrote in message
news:1f8fa01c45826$3511d860$a101280a@phx.gbl...
> Hello all,
>
> How can i sync. 2 exchange servers ?
> Is this possible with InterOrg ? (i want also...
Outlook and message rules- can't get one to work?I have set up message rules to divert mail from my inbox to various sub
folders or new folders. I use these:-
Check messages when they arrive\ from people or distribution list \ with
specific words in the senders address \ with specific words in the subject or
body
Now the problem is that some of the messages are recieved from people in my
address book and when they send a message sometimes their name and address is
in the 'from' and other times it is just their name and so the ones with just
their name do not get moved across to the folder I want. I have added their
name or...
Exchange Troubleshooting assistantUsing the exchange troubleshooting assitant. I get to the step where it
wants to collect performance data or use an existing .blg file. What I want
it to is use an existing .etl file that I collected with exmon. Later in the
process as I step through the wizard it does prompt for an existing .etl
file, this is confusing. It makes you choose a .blg or create a new one but
then latter asks you have a .etl file. Not sure what log file it it is using
at this point.
So...is there a way to convert a .etl to .blg so that I can use my exising
..etl log file, or can somebody explain why it...
Exchange data backupI'm worried emails backup of the small office.
Does SBS2008 Exchange server has a direct backup capability of whole mail
database?
How to backup every night Emails from server to external harddisk?
Does Exchange server needs to be stopped before backup?
Thanks
SBS2008 Takes care of it.
http://blogs.technet.com/sbs/archive/2008/11/03/introducing-sbs-2008-backup.aspx
look at the comments section
Russ
--
Russell Grover - SBITS.Biz [SBS-MVP]
MCP, MCPS, MCNPS, SBSC
Microsoft Certified Small Business Specialist
24hr SBS Remote Support - www.SBITS.Biz
Question or Seco...
UNIX and Exchange in the same domainI have an existing SGI UNIX mail server handling mail for our company. I
added a SBS Exchange 2003 server for some of my clients to have Outlook Web
Access and other features. The UNIX server handles the incoming mail for all
the mail recipients. I put a cost on the incoming Exchange SMTP server so it
doesn’t receive mail for the outside. The users have Outlook 2003 running
with and Exchange server installed and the UNIX mail server installed. When
the Outlook 2003 sends mail thru the Exchange server (which it switches to by
default ever time you launch Outlook 2003) to a user that is i...
Problem Opening Notebooks on New ServerI have a small office and we all store and use notebooks on our
server. We moved all of our data to a new server yesterday, and now
when we try to open the notebooks we get a message that says: "OneNote
needs a password to sync some of your notebooks", and we are unable to
open the notebooks. Interestingly, if we open the notebook through a
mapped drive to the location, we get the error. But, if we navigate
directly to the notebook through the network, it will open with no
error. We are having no other problems with this mapped drive.
Thanks!
...
configuring exchange to accept maill from a different domain name...We are setting up a subsidiary company having a completely differnt domain
name. Once our new domain name is registered and our provider has created an
MX record for this new domain, what needs to be configured on the Exchange
server to accept email from this new domain?
Thanks,
Brad
if Exchange 2000/2003, you need to create a recipient policy...see these:
http://support.microsoft.com/kb/285136/en-us
http://support.microsoft.com/kb/318072/en-us
--
Susan Conkey [MVP]
"Brad Pears" <donotreply@notreal.com> wrote in message
news:e21waZZWGHA.4212@TK2MSFTNGP02.phx.gbl.....
Finding intersection point in rows and columnsI am trying to work a macro which will do the work for me (go figure).
Here is the easy example. I have a worksheet which has a 3 columns an
a bunch of rows: the column headings are " ", "total", "add-on"
the rows then consist of "mike","1,000","200"... then next ro
"cindy","1,230","23" etc
I would like a different worksheet to have a macro button that ca
take the data and put it into a new table and stuff.
I was thinking along the lines of creating labels on the top and left
and then referencing the ...
Exchange 2007 and EFORMS REGISTRYHi,
on technet I found the information that custom forms are de-emphasized.
Does that mean that even if I create a public folder store in Ex2007 I
cannot have an organizational forms library for my MAPI form definitions? If
that is true, how am I supposed to manage the GUI of MAPI items of my
message classes in the enterprise?
Please don't tell me that MAPI form configurations have to be published to
each and every mailbox where my message classes should be useable. That
sounds like a deployment nightmare.
Please don't tell me either that one has to keep a pre-Ex2007 server jus...
Can I make my Contacts Folder my DefaultDoes anyone know if I can make my contact folder the default folder rather
than the Global Address List?
On 3/8/2010 7:36 PM, Wendy wrote:
> Does anyone know if I can make my contact folder the default folder rather
> than the Global Address List?
Sure.
Ctrl-Shift-B (or just click the Address Book icon)
Tools -> Options
--
Leonid S. Knyshov
Crashproof Solutions
510-282-1008
Twitter: @wiseleo
http://crashproofsolutions.com
Microsoft Small Business Specialist
Please vote "helpful" if I helped you :)
...
How can I print page 2 of each sheet in a workbook?
If I understand your request, the first point to clarify is that "each sheet"
does not have a page 2 - If there are 10 sheets & each one contains 2 pages
of data, each page is still sequentially numbered 1-20.
One option is to select the area to be printed on each sheet and go to
File>Print Area>Set Print Area. Once you do this for each sheet, go to the
Print dialog box and select Entire Workbook.
HTH |:>)
"sflower" wrote:
>
...
Can't repair CRMHi,
When I try to repair CRM on a few laptops, I get the following message:
Setup failed to locate binary file microsoft.crm.metadatahelper.dll verify
that the source folder is configured with Everyone Read Access.
I am trying to do a repair off the original CRM CD.
Any ideas why this is happening?
Thanks,
Sophie
...
Exchange 2003 SceneI have a Windows 2003 domain with Exchange 2003.
I want to build the following scene:
Commom User: they can't sent e-mail over internet (only internal)
Dept User: can send e-mail over the internet
The commom accounts have their own mailboxes and need to send external
e-mails through dept account only (using from field), but they can't delete
dept mailbox contents.
Is that possible?
On Fri, 28 Apr 2006 12:40:02 -0700, Will
<Will@discussions.microsoft.com> wrote:
>I have a Windows 2003 domain with Exchange 2003.
>
>I want to build the following scene:
>Commom Us...
'Server XXXX Not Available.' When Trying To Add a Process Server in the DPS Server Setup WindowThis is a multi-part message in MIME format.
------=_NextPart_000_0020_01C9BDE1.B1EBED50
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Issue
'Server XXXX not available' occurs when trying to add a process server =
in the DPS Server Setup window.=20
Resolution
If the Process Monitor is not running at the workstation you are trying =
to add as a new process server, you will receive the message 'Server =
XXXX not available'.=20
To start the Process Monitor, drag the Dynamics.set file on top of the =
DPS.exe file in your...
WM5 and Exchange 2003 sp2I have problems getting my QTEK 8310 to work against Exchange
I have a selfsigned certificate installed on the qtek and can access oma
without beeing prompted so that should be ok.
But I get the error 0x85010014 when I try to sync with Exchange, I just
tried to create a new virtual directory for Exchange
and called it exchange-oma just like SBS server does and change the registry
(MAS) to point to this, but no go :(
I have spend alot of time with this now and am really sick and tired of
trying to get this to work, I have alot of customers also wanting this
solution but as long as our o...
Can't find outlook archive.pstI'm constantly getting "can't find Outlook archive.pst"
error message when I launch Outlook XP. Does anyone know
how to get rid of this error message?
Richard <anonymous@discussions.microsoft.com> wrote:
> I'm constantly getting "can't find Outlook archive.pst"
> error message when I launch Outlook XP. Does anyone know
> how to get rid of this error message?
Either create an Archive PST or disable archiving (Tools>Options>Other)
--
Brian Tillman
Smiths Aerospace
3290 Patterson Ave. SE, MS 1B3
Grand Rapids, MI 49512-1991
...
Data Format: how can I re-formatThe spreadsheet that was exported for me to use has the information in
paragraph form:
It is customer ID name and billing info but it is like a long series of
address labels.
I want to be able to have them listed under captions like company name,
contact, address, city, etc.. so I can use the data.
There is an empty row between each entry. Each entry is 3 or 4 rows.
There are about 500 records so i dont want to manually set them up.
Thanks
Try tinkering around with these steps
Assuming your list is in col A,
data in A2 down
(If data starts in A1 down, insert a new row for the co...
97: How can I find duplicate entries in a column?Hello and thanks in advance for any help. This is a very basic question
from an even more basic user. I have a spread sheet with a long list of
ID numbers for skips. Sometimes duplicate numbers arise from paper work
from elsewhere and I get a false total of skips in hand. How can I
organise that column to highlight a duplicate entry please?
Shen
---
Message posted from http://www.ExcelForum.com/
Insert a helper column:
=COUNTIF(A1:A9999,A1)
(adjust the range to suit.)
then the formulas that evaluate to more than 1 will be duplicated.
Chip Pearson has some other techniques at:
http://ww...
Can a user's Worlplace be defaulted to a standard oneHi,
Is it possible to set a standard Workplace that users will see based on
either their role or team?
We have a client who wants to set standard worplaces for respective
teams/users.
TIA
Hi GP,
Ian Watson had a good method--
"simply click on Workplace bar, then just above click on "personalize
Workplace" then tick on or off what you need"
This could also be done through changing the security role to allow
certain privaleges. You cant change a system security role, you have
to copy it and rename it. Settings | Security Roles | highlight the
role you want to copy | ...
whihc microsoft office can i use to determine loan amortizationI am looking for programs wherein I can determine loan amortization
"Justin Reyes" <JustinReyes@discussions.microsoft.com> wrote in message
news:304D4935-F597-4BE9-A290-59C78A19AEBC@microsoft.com...
|I am looking for programs wherein I can determine loan amortization
You need Excel, not Access
--
Len
______________________________________________________
remove nothing for valid email address.
...
Can I access the previous version of a saved file?I overwrote an excel file by mistake, using the save as command to an
incorrect file. Is there any way to recover the previous file before I
"saved as" over it?
Hi!
I'm using Excel 10 (XP)......WinXP.......
If I have an existing file and open it, make some changes, then do a SAVE AS
and give it a different name, the newly "saved as" file is a completely
*NEW* file and the original is still in tact with the previous file name.
Try looking for the previous file name.
Biff
"JCC" <JCC@discussions.microsoft.com> wrote in message
news:9CAD1748-1D5C...
POP3 Emails and Exchange ServerHey all:
I have a virtual POP3 Server running on my exchange server 2000. My company
just purchased a bunch of Treo 600 and want to set them up to receive
corporate emails. What I would like to do is use the POP3 Account instead of
purchasing a package that would work directly with Exhange Server. My
question is how do I find out what my pop3 account name is. I tried using
pop3.mydomainname.com, and mail.mydomainname.com, but that didn;t work. Can
anyone provide me with the steps to locate the name of my pop3 account.
Thanks
...
Deleting Accounts on Exchange 5.5I would like to know how to delete accounts on exchange
5.5 with a NT domain in an automatically way.
http://www.winnetmag.com/Article/ArticleID/39508/39508.html
On Tue, 14 Sep 2004 15:24:25 -0700, Ana Mar�a Pacheco
<ana_pacheco@provincial.com> wrote:
>I would like to know how to delete accounts on exchange
>5.5 with a NT domain in an automatically way.
...