One worksheet has 600 + lines with a lot of expenses, including SOME of the
local expenses. This is a check register..
Another worksheet has 300 + lines with ONLY local expenses.
Trying to get ALL expenses together, but eliminating the duplicates from new
list. Thinking B2=date. C2=name, E2=amount - - SO B2&C2&E2 on first long
worksheet and then the same on short worksheet... Bring BOTH over to new
tab and then stuck. Any ideas greatly appreciated, or another better way to
You could use excel filter:
Data - Filter - Advanced Filter - Unique records on...All + Everyone #2
Is there a simple way to send a message to everyone in my organization that
has a mailbox?
"Fred Stocker" <firstname.lastname@example.org> wrote:
>Is there a simple way to send a message to everyone in my organization that
>has a mailbox?
What release of Exchange?
You can use a "Query Based Distribution List" with Exchange 2003.
MCSE+I, Exchange MVP
MS Exchange FAQ at http://www.swinc.com/resource/exch_faq.htm
I tried that but it didn't work. Thought maybe there was something I was
missing. I'll try again.
Fr...Which Office X 10.1.5 duplicate fonts can be removed from which folders?
Which of these duplicate fonts can be removed from the
Applications/Microsoft/Office X/Office/Fonts folder AND/OR the
All of the following are duplicated in the two folders. Two of them, Times
New Roman and Verdana, also are in OS 10.3.3/Library/Fonts.
Comic Sans MS
Copperplate Gothic Bold
Copperplate Gothic Light
Edwardian Script ITC
Times New Roman
On Tue, 6 Apr 2004 04:42:59 -0400, Norman R. Nager, Ph.D. wrote
(in article <...Wildcards in email address
I would like to flag all emails from a company with a
certain color flag. I thought I could do this by creating
a rule with a wildcard (such as *@microsoft.com) but it
doesn't seem to work. Is there another way of doing this??
Create the rule with a setting that says "senders' address includes" and
just the domain name. Leave the wildcard and @ off.
Ben M. Schorr, OneNote-MVP
Microsoft OneNote FAQ:
**I apologize but I am unable to respond to direct requests fo...opening email
When I double click on an email that I received, the message will not open in
another window. The only thing that happens is that email is displayed as
open in my taskbar. I've always been able to open into another window until
now. Please advise.
It is actually opening "off-screen".
Right click on the minimized window tab on the Taskbar and select Move.
Now use the arrow keys to get it in the screen. Close all other windows
except this one and use the cursor to drag the message to the size you
want. File | Exit, and Windows will remember the size when you ope...Receiving duplicate emails
I have just recently created my email account in
Microsoft Outlook and now when I receive email I get the
same one 15 times (and that is no stretch!) Is there
something I have done wrong? How do I fix this?!
What version of Outlook do you have? What sort of mail account(s)? Do you
only get a single message many times, or all the messages many times?
This posting is provided "AS IS" with no warranties, and confers no rights
"Carrie" <email@example.com> wrote in message
news:firstname.lastname@example.org...managed NG email
If I put my actual email address in my newsreader account setup for this
group, to provide for 'managed' response, doesn't that open the floodgates
for spam? How is everyone handling that issue.
Will MS understand if we use a the standard anti-scanner methods, like 'marc
AT bellsouth dot net', or does MS rely on automated methods to track managed
You have to use something that at least looks like email rather than
spelling it out as you have, but it does not have to be a valid address.
You have to register the address you are going to use on Customer...Release Mode #2
i am facing a very typical problem that is when i execute my program in
debug mode it runs but when i do the same thing in Release Mode it give
error DialogBox with 2 buttons Close and Degug. My program is simple
MFC program with no DLL. Whats Wrong?
Check out this article:
"PARIJAT" <email@example.com> wrote in message
> Hi All,
> i am facing a very typical problem that is when i execute my program i...MSCRM Email Subject ID to Email Header
I have the understanding that there is a patch which instead of turning off
the GUID from outgoing emails, moves it from the subject line to the email
header, but i can't find it anywhere. Can someone please point me in the
right direction and convince me that i haven't made this up... or worse,
In the current release, there is no such patch. You can only turn off the
process that adds the GUID to the subject.
MVP - Microsoft CRM
On Wed, 17 Nov 2004 ...Duplicate data from field into another field in same form?
Can I duplicate data from one field on a form into another field in the same
On our exhibitor entry form, the Program Contact info (fields for name,
address, phone, fax, email) is entered first. Mail Contact info is often the
same, but not always.
Is it possible to autopopulate the Mail Contact with the data from the
Program Contact, but allow me to enter new data if necessary?
If so, can you tell me exactly how?
On Fri, 23 Mar 2007 09:46:24 -0700, Andi <Andi@discussions.microsoft.com>
>Can I duplicate data from one field on a ...Outlook email account, can't delete
I have Outlook 2002 hitting an Exchange 5.5 server on a
laptop that I've given to a new user. The old user's
mailbox remains in Outlook even though it doesn't exist
in E-Mail Accounts\Exchange Server Settings under the
Tools menu. Nor does it exist under the new user's
account as an additional mailbox. How do I remove it?
Additional info: my Exchange server died last week and I
rebuilt Exchange on a differently named server. The
mailbox that I want to remove attempts to connect to the
old Exchange server. Also, I just upgraded the laptop
from Win98 to XP Pro and ...Publisher and tables #2
I am making a booklet. I am putting info in as a table and I need to know if
there is a way to get my table to automatically continue on to the next page.
No, Publisher hasn't this function. Word does...
Mary Sauer MSFT MVP
"Kimmy" <Kimmy@discussions.microsoft.com> wrote in message
>I am making a booklet. I am putting info in as a table and I need to know if
> there is a way to get my table to automatically continue on ...Case & Reply EMail
When a case is created I'd like CRM 4 to send an email using workflow
to a particular email address and when this person has replied to the
email using outlook(this person is not a crm user) I'd like for the
reply to go into the history of the case. What do I need to do to set
Did you confiugred Email Router?
"Ray Bell" wrote:
> When a case is created I'd like CRM 4 to send an email using workflow
> to a particular email address and when this person has replied to the
> email using outlook(this person is not a crm user) I'd like for th...Missing Mail #2
We have just downloaded our email and read 1 message then
returned to outlook to find all mail in our inbox gone
along with our contacts and personal folders.
Is there a virus out there that might have caused this?
Is there anyway we can get the information back?
Natalie <firstname.lastname@example.org> wrote:
> We have just downloaded our email and read 1 message then
> returned to outlook to find all mail in our inbox gone
> along with our contacts and personal folders.
> Is there a virus out there that might have caused this?
> Is there anyway we ca...Exchange Routing #2
I am running EX2K3 with SP2, with 3 bridgehead servers, in Sydney,
Manchester, and Melbourne. My Exchange servers that are located in the UK,
use 3 RGC's with 3 different costings in the following order Manchester
bridgehead (20), Sydney Bridgehead(30), Melbourne Bridgehead (40). For some
reason my Exchange server continues to use my Sydney bridgehead server
through the second RGC, and not my default Manchester RGC which has a lower
cost. However, if I delete the Sydney RGC it works via Manchester, or if I
make Sydney RGC more expensive than Melbourne RGC it will also use...Retrieve email from another computer
My husbands computer in office is down, he wants to
retrieve his emails from home.
How can I do this quickly?
That depends on the type of mail system they use at work (server based
postoffice, or Internet mail, or what). Can you give us some more
MVP - Outlook
*** Messages sent to my e-mail address will NOT be answered -- please
reply only to the newsgroup to preserve the message thread. ***
> My husbands computer in office is down, he wants to
> retrieve...Duplicate, Duplicate, dupli ...
I'm new to the group, so hope I don't disgrace myself.
I have a list of names in the first column, and their respective postal
codes in the second. Unfortunately, many of the names, (and respective
codes), are duplicated... sometimes there are up to four of the same name,
(and code), under each other.
Is there a way to get rid up the duplicates and make a usable list please? I
can do it manually of course, but ..
Data>Filter>Advanced Filter. "unique records only" and "copy to another
For more on this visit Debra Dalgl...CRM Mobile 3.0 #2
Does anyone know if the mobile client for CRM 3.0 will work with CRM 4.0?
in theory, it should work as it uses the web service to run but not
sure, keep me updated if you get any news as i need to know that myself.
MBSS, MCNPS, MCTS
David Hodgson wrote:
> Does anyone know if the mobile client for CRM 3.0 will work with CRM 4.0?
no its not compatible.
"David Hodgson" <email@example.com> wrote in message
> Do...WLMD Cannot Be Set As Default Email Application
I runs on Windows 7 Ultimate, and I already set Windows Live Mail Desktop as
my default email application of my OS, but there often a message box appears
and tells me my OS has no default email client application, why? How can I
solve this problem? Thanks!
Are you in IE trying to use the Send Page / Send Link feature when you get
"Michael Cheng" <Michael Cheng@discussions.microsoft.com> wrote in message
> I runs on Windows 7 Ultimate, and I already set Windows Live Mail Desktop
> ...Not all emails going out??
For the last week or so, send few, my emails have not been going out, or not
going out to all parties I access from my address book. Just tested by
sending one to myself...went fine. Sent second to a single party and cc
myself. Did not receive my cc in outlook, but it did show up in my iphone.
Tried a third to a group of people...through a single address book contact,
and nothing happened. I am strictkly novice, but have not had this problem
before. Any ideas???
Wilson Kobel;110315 Wrote:
> For the last week or so, send few, my emails have not been going...Outlook links #2
Every time I click on a link enbedded in an e-mail it
starts up the TurboTax instalation program. I deleated
all the TurboTax programs but it still does it. I called
TurboTax and they told me to reinstall TurboTax and then
uninatall it. I tried that to no avail.
Can any one help?
...Email signature keeps disappearing
I have a user who says that "now and again" his email signature disappears
and he has to re-add this. He has a roaming profile but no other settings
are affected/lost and no error messages are displayed either to this effect.
Can someone help?
What version of Outlook are you using?
Ben M. Schorr, MVP
Roland Schorr & Tower
"Scott Ashton" <firstname.lastname@example.org> wrote in message
...Adding email signatures to email generated from form
I have the email addresses on my form set up to open a new email to that
person when clicked upon. What it doesn't do is import the email signature
from outlook. Is there any way I can do this?
Any help gratefullly received.
You can do that with this free utilities.
Javier Valverde S.
> I have the email addresses on my form set up to open a new email to that
> person when clicked upon. What it doesn't do is import the email signature
> from outloo...Copy ranges into email
How do i add more than one item to the body of a outlook mail using vba.
I am using named range to select the items.
i want to add Text, the leave two lines HTMLBody then leave two lines and
add another HTMLBody and leace two lines and add Text
I have a function that does the RangetoHTML after passing myRange to it.
I am getting confused here.
.To = s
.CC = "SH-DI-List"
.BCC = ""
.Subject = n & " - Trades in Pending Queue in SW " & Format(Now,
"dd-Mmm-yyyy") & _
"...Emails not showing up in Outlook but can be seen on Webmail
I've got several clients saying that in Outlook 2003 and Express its
saying they have new email but none of these new emails are in their
inboxes. so i told them to log into webmail, and they can see the
emails there... all of these clients are using IMAP and could have very
what could be the problem here? why isnt outlook downloading the emails
Do they have LAN or WAN access?
No Warrenties Implied, Did you do a FULL backup today??????
> I've got several clients saying that in Outlook 2003 and E...