Copy only certain lines from one sheet to another
Have a sheet that has data in.
I would like to copy all lines from that sheet to next sheet if one column
as a particular ' variable ' in i.e in this case L which represents a live
To try and explain more, say for example sheet1 has 100 names and their
adresses in with a final column with the letter L in. But only a selection
has the letter L in.
Would like to find these letter L and put them in sheet two, of course if
sheet 1 has a letter L deleted or added sheet 2 is updated automatically.
Hope I have explained ok.
p.s sorting sheet 1 and copying and past...cannot get mail
all of a sudden i can't get mail, 6 days now. i have read questions and
answers. please help
Account: 'mail', Server: 'pop.att.yahoo.com', Protocol: POP3, Server
Response: '-ERR [AUTH] invalid user/password', Port: 995, Secure(SSL): Yes,
Server Error: 0x800CCC90, Error Number: 0x800CCC92
First, test your password by logging in to your provider's webmail:
If that works, it proves you have the correct username and password.
A likely reason for the username/password failing in Windows Mail is
account corruption. One thing you...Mail Merge #16
While doing mail merge with Publisher document, using wizard, when I selected
folder to get addresses in one of the contact folder, I got an error, 'dialog
or database engine failure'.
Ed looks left. Ed looks right. No-one is there. Furtively, Ed picks up
a note from GC Publisher <GC Publisher@discussions.microsoft.com>. On
it is written:
> While doing mail merge with Publisher document, using wizard, when I
> selected folder to get addresses in one of the contact folder, I got
> an error, 'dialog or database engine failure'.
a) Try updating your MDAC...Forward from provider or forward from Hotmail?
I currently have my Comcast and Gmail forwarded to my Live account though my
Live account. It is very slow to get email this way on my computer through
Outlook. Does anyone else do this? Does anyone else not do this and have
their mail forwarded from their provider to Hotmail, rather than having
Hotmail handle the forward? Questions? Answers? Opinions?
Thank you very much kind people,
> I currently have my Comcast and Gmail forwarded to my Live account though my
> Live account. It is very slow to get email this way on my computer through
> Outlook. Does anyo...Bogus E-mails
How do STOP the bogus update E-mail messages that is supposed to be from
Microsoft? These E-mail contain what appears to be the official Microsoft
internet page. How can I put a stop from then short of using a SPAM KILLER
can anyone tell me if Access will generate an e-mail from a command button
advising the recipiant that certan information relating to the inputa data
has been added to the database
On Oct 21, 4:57 pm, will07 <wil...@discussions.microsoft.com> wrote:
> Hello All
> can anyone tell me if Access will generate an e-mail from a command button
> advising the recipiant that certan information relating to the inputa data
> has been added to the database
you mean like a web page does? Not directly, since you can't monitor
a table directly, the way you can in SQL Serv...[HELP] Problems forwarding NDR reports to a Public Folder
I have a problem with Non Delivery Reports that tries to be sento
topublic folder with mailbox, but only in a special condition. I think
it is a permission problem, and I would have an help to solve it.
This is the scenario:
There are some USER MAILBOX, for example email@example.com, for which I
have set-up a *forward* to the address of a PUBLIC FOLDER with a
mailbox called firstname.lastname@example.org. The Client Permissions in this public
If user email@example.com sends a mail to an existing server (for example
hotmail), but to an...forwarding emails between accounts in same AD Forest?
I am trying to setup a forwrding address for a user to forward to
another mailbox of theirs which is in a different domain but same
I am selecting the account to forward to in the forward to box in the
delivery options window in their AD account. But I am geting this
A referral was returned from the server
Facility: LDAP Provider
ID no: 8007202b
Microsoft Active Cirectory - Exchange Extension
Any have any ideas on ways around this. Many thanks
Does the account you're using to make this delegation have sufficient rights
in the other domain to look up the alternate recip...cannot send e-mail via WLM
recieve error message 0x8000CCC6F....server error 554...have discovered that
this means my ISP will not support sending via WLM....have downloaded firefox
in attempt to send...nope...cannot change default mail send on WLM.....have
searched for a solution...nothing forthcoming.....anyone got an answer for
this Whizz NEW system?.....
"billmus uk" <billmus firstname.lastname@example.org> wrote in message
> recieve error message 0x8000CCC6F....server error 554...have discovered
> that this means my ISP wi...Can't E-mail from Explorer
When I select an Email address on a website, I get 65
Internet Explorer windows pop up and a message about the
default mail client not properly installed. I have to
close all 65 windows before I can do anything!
...OWA+GFI Mail Essential do not filter Junk Mail
I have a problem with OWA, I install GFI Mail Essentials 11 and it filter
the Spam to junk mail correctly but only with Outlook 2003 clientes, but with
OWA all the SPAM goes to Inbox folder. I active the Junk Mail filter vía OWA
but the problem still occurs.
Does anyomne have an idea of this issue?
> I have a problem with OWA, I install GFI Mail Essentials 11 and it filter
> the Spam to junk mail correctly but only with Outlook 2003 clientes, but with
> OWA all the SPAM goes to Inbox folder. I active the Junk M...My CRM Exchange Mail Router is unable to Route incoming Mails
my mail router is unable to route incoming Mails to the CRM System. I got
the following entries in application event log:
Thanks for Help
A platform error message was encountered. Subject: 'Test 1' Platform Error
Code: 80070057 Platform Error Description: 'Wrong Parameter.
' Literal SOAP Fault: '<error><code>80070057</code><description>Wrong
The message 'Test 1' failed to deli...E-mail Signature
I have set up my signature, and I have selected "black" for the font of my
signature, but when I click on "new" e-mail, my signature comes out yellow
and barely readable. Can you tell me how to fix this?
Which version of Outlook are you using?
How exactly did you create your signature?
If using Outlook 2003 or previous, did you use the "Advanced Editor"?
Which editor did it open for you then?
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
Outlook FAQ, HowTo, Downloads, Add-Ins and mo...Mail Store Size on Bridgehead Server
Had an interesting question and didnt know the answer. On a bridgehead
server we wanted to set the store size to like 10K to keep a mailbox from
being moved there by mistake (user would complain that they cannot send or
recieve and then it would be spotted that they were on a store with no other
users, and flag would be raised). Question is, would this limit also apply to
messages going through the the bridgehead server as well.
The only reason I ask this question is because the SMTP system mailbox is
used to convert messages, and Im wondering if that mailbox can also fall
unde...finding a particular cell in another worksheet whose row number ch
Hi I'm new to macros. I've been trying to make a workbook that I can use at
work to track the progress of numerous projects. I have created a master
copy which will be modified for several different projects. When milestones
are reached the owner of the projects records this in the sheet in a colum
named "Done". This is compared to another column called "planned" and a
percentage can be made called "adherance to planned" This is then tracked for
each month for each ROW, (as each row will represent a new component of the
In another ...A way to set developer edition to behave like another edition
Been awhile since i posted here but here goes.
Got my hands on SQL Server 2008 for awhile now and i am using developer
edition for work.
However, lately i have had the misfortune to use features in my work for a
client that is only available for enterprise edition while the client is
running a standard edition server. Haven't been a big issue but i am just
surprised that a edition feature isn't available in developer edition to
simulate different editions for developers.
Is there way to accomplish this or just for me to keep remembering the
When we used pine email we could easily set it up to send a
copy of ALL emails received to another address
automatically. For the life of me I cannot figure out how
to do this in Outlook.
For more explanation - our students are assigned email
addresses like email@example.com. Many would rather
use their yahoo or hotmail account. They want ALL of their
mail sent on to the other account.
What directions do I give to them to make that happen?
Thanks so much
Outlook is a client, not a mail server. You'd need to set this up on your
server, if you've really decided that this is wh...Creating child domain Exchange Server
We are a branch office of a large organization, and a child domain
(branch.abc.org) in AD, with a different subnet 192.168.25.0/24. All
email accounts reside at the top level (firstname.lastname@example.org) Currently,
our corporate office, with an AD domain of (corp.abc.org) houses our
exchange accounts on a exchange farm (192.168.1.0/24). For fail over
and bandwidth reasons, we are researching the possibility of getting
an exchange server for the branch. Since I am not an exchange expert,
here are the questions i am posing:
1. With an exchange server at the branch...which domain will it join...How do I search specific words/phrases/terms in Outlook 2003's e-mails?
How do I search specific words/phrases/terms in Outlook 2003's e-mails?
For example, "apple juice". Another example, "base" and not baseball. I
tried using quotation marks like on Google, but that didn't seem to
work. I was unable to find anything about this in its help.
Thank you in advance. :)
Senior Software Quality Assurance Analyst
ISP/Symantec Online Services, Consumer Business Unit
Email: email@example.comSYMC (remove SYMC to reply by e...Mail von Ehefrau
ich wollte nur �berpr�fen ob meine Mail ankommt
Bis bald deine Gattin.
...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.
>...mail merge cannot continue
I have been using mail merge in Publisher 2000 on Windows
XP. But it suddenly started refusing to work, giving the
message "mail merge cannot continue". I have tried
reinstalling and uninstalling things I had done recently,
to no avail.
Did you have to relink to your database? If so, try changing your selection
in the checkbox for "First row of data contains column headers".
"Margaret" <firstname.lastname@example.org> wrote in message
> I have been using mail merge in Publisher 2000 on Windows
> XP. But it...Forward Unopened messages?
I'm trying to cut down spam and don't want to open any
spam emails. The FTC has an email address
(email@example.com) where you can forward spam emails that
don't follow the regs or don't have opt-out options
however when I forward the message Outlook opens it. Is
there a way to forward the offending spam email as an
attachment without opening it?
Ted <firstname.lastname@example.org> wrote:
> I'm trying to cut down spam and don't want to open any
> spam emails. The FTC has an email address
> (email@example.com) where you can forward...Signature not displayed in reply/forward
I've tried to search for a similar answers but can't quite find anything.
I've set up an HTML signature for new emails, forwards and replies. All
works fine until an inbound RTF email arrives and the signature doesn't
appear in reply or forward automatically. I've checked the settings, I even
tried the internet format conversion to HTML format for replies to inbound
RTF. In message format I have both 'Use in MS Office Word 2003 to edit email
messages' and 'Use MS Office Word 2003 to read RT email messages' are ticked.
It's happening ...Corrupt mail message
Has anyone heard of receiving a message that looks like this: "A
corrupt mail message, ID 1184275272518 from <my.name@*********> has
been detected." THis message is received seconds after sending
messages and sometimes after replying to emails. It doesnt happen all
the time, and when it does the message is still delivered with no
problems. ANy ideas would be great thanks all.
"Soldier" wrote in message
> Has anyone heard of receiving a message that looks like this: "A
> corrupt mail m...