Bin and sort a large list of data
I have a large list of data that i need to go through for my job. what i
want to do is organize the numbers into bins, then elimintate any numbers
that are identical. does anyone have any ideas?
Sort the data into the number order. Let's say that is in column A. Then
in the first free column, make the first cell 0, and then do in row 2
This will then equal zero on the first line of a new number.
Then Copy, Paste Special, Values on this column of ones and zeros, and then
sort on it. The data at the top will be a unique list of numbers. You can
just the...No message in outbox
I tried to send a message with 1Mb attachment to 40 recipients in the bcc
field. It gave me an error message from the isp's server, the message was
NOT sent (I've checked), it did NOT arrive in Sent Items, but neither is it
in the Outbox any more. I can send and receive email successfully.
Problem is, every few minutes Outlook tells me it's sending message 1 of 1,
it fails and gives me the same error message. Yet there is no message in
the Outbox. But what happened to the original message when it first failed
to send? I guess it's 'stuck' somewhere but I can...Sending mail from selected email address
As I have 4 email accounts set up in Outlook, I understand that I can send
mail from each or any account.
The accounts are listed under tools / Send and Receive / then each of the
How can I choose which account to send from so that the recipient see's who
I want it to be from??
Hope that explains it.
On Sat, 16 Apr 2005 21:10:48 -1000, The Fatman <email@example.com>
> Hi All,
> As I have 4 email accounts set up in Outlook, I understand that I can
> mail from each or any account.
> The acco...Global distribution List Not Appearing in Outlook Global Selections list
I have created a global list in AD in Server 2003 ( using Exchange 2003) and
assigned my users. For some reason the list is not showing in the Outlook
client global address list. I have compared this list to others i have
created in the past and cannot spot any differences. What am I missing?
1. Have you got it hidden from the GAL?
2. Using cached Exchange mode? Therefore requiring a rebuild of the OAB to
On Fri, 16 Feb 2007 13:24:05 -0500, "rlm" <firstname.lastname@example.org> wrote:
>I have created a global list in AD in Server 2003 ( using Exchange 2003...How do I send copies emails without sending attachments?
I send emails with attachments to our bank. My boss wants a copy of the
email but not a copy of the attachment. How do I do that?
Steve Bramblett wrote:
> I send emails with attachments to our bank. My boss wants a copy of the
> email but not a copy of the attachment. How do I do that?
Each recipient gets the SAME copy of the e-mail. If you want different
recipients to get different versions of your e-mail, you have to send
...Sending a macro to another PC-how?
How do you send a macro you've written to another PC so
that they can save it in their Personal.xls file (at
Program Files\Microsoft Office\Office\XLStart)?
You can export a macro and save it, to do this from your workbook,
right-click the workbook's icon and pick View Code. This icon is to the left
of the "File" menu this will open the VBA editor, click on the module you
want to save and go to file and export file, then save it to a floppy or
what ever you backup to, then import it to the new workbook.
Always backup your data before trying something new
Using ...Master Category List keeps reverting to default list
I have had the Master Category List revert to the default list several times
now. This has happend at least 6 times since I upgraded to Office 2003 a year
ago. This is annoying, as I have my own, different, list of categories that I
use. I have used the good info that Sue Mosher provides at:
to make a backup of my catagories.
Using the registry restore routine certainly makes the fix a bit easier than
retyping all of the categories.
Still, having to dink with the registry to keep outlook from destrying my
data is more than a bit unnerving.
Does...Sending mail from remote location
my mail works great while at home. when I go on the road I can receive
ail but not send. I get the following error message:
Subject 'SKIDOO MACH Z 800LT (long track / long tunnel) (Jackson)',
Account: 'Jeff', Server: 'smtp.charter.net', Protocol: SMTP, Server Response:
'571 imp11 smtp.charter.net OTcuMTQ3LjE2LjIzMA== You must connect from
Charter IP space. E1110', Port: 25, Secure(SSL): No, Server Error: 571,
Error Number: 0x800CCC61
It worked on my last laptop and I have not been able to figure it out on
this one. I can't remember what I...Send and Recieve Fix
For a long time I had a problem with my Send/Recieve function in Outlook.
This happended in both Outlook 2000 and my current version - 2007.
I found I had to re-boot my computer to perform a Send/Recieve in Outlook.
Otherwise the sequence would start then stop and say it could not perform
due to an error.
After extensive Internet and News Group research I decided it was time to
run a check on disk errors.
This Windows XP facility seemed to have fixed my Outlook problem.
I did this about a few months ago now and I have since had no problems with
my send and recieve.
Unfortunately I do have ...Unable to send?
I've got MOOL, and i"m usign ti with outlook. The emails that I'm
sending are just "stuck" in the outbox? Can anyone give me an idea of
what's going on?
Did it ever work? Are you able to receive?
Ben M. Schorr, OneNote-MVP
Roland Schorr & Tower
Microsoft OneNote FAQ: http://www.factplace.com/onenotefaq.htm
**I apologize but I am unable to respond to direct requests for assistance.
Please post questions and replies here in the newsgroup. Mahalo!
"Rekks" <email@example.com> wrote ...Sending messages in Outlook
We have a user that everytime that she sends an email she
will get booted out of Outlook. The email does go
through, but she will have to get out of Outlook. When
she goes back into Outlook, everything is fine until she
sends another message. Any help would be appreciated.
...No Permission to Send/Receive Email???
I just replaced our server hardware, upgraded to WS 2k3
Enterprise and created a new domain. I transferred the
client files and desktop on our desk/laptop computers
over to the new domain. We do NOT have Exchange
installed yet, but use Outlook 2002 with the email etc.
saved on the client.
One one client machine (mine), the email, calendar, etc
are there, but when I hit the Send/Receive button, I get
a message saying that I don't have permission to perform
this operation. Also when I try and change the automatic
check for email option it tells me I don't have
permission. ...Send Do Not Send
When I attempt to email via a print server - OutLook
Express displays the message "A program is attempting to
email on your behalf" Send or Do Not Send - How do you
prevent this from happening? And just automatically send?
...Ques regarding "Junk Sender List"
When adding to "Junk Sender List" in Outlook, specifically OL 2K2-SP3,
is the real e-mail address recorded (johnQpublic@domain) or the alias (John
Similarily, can entire domains be flagged as Junk Mail senders?
Thanks in advance.
It's the real email address that's recorded. I don't
believe you flag an entire domain (though that would be
very nice) because I don't think you can use any wildcards
for the username (IE) *@blah.com with the * being a
wildcard. Like I said though, it would sure be helpful
because we all know the minute you bloc...Sending on behalf... Exchange 2003
Is there a better way to give a few users the ability to send mails also
from the firstname.lastname@example.org mailbox without having them logout and login to a
different Outlook 2003 profile... Or without the text sending on behalf
of... So my question is, Is there an easy way that a user can select another
e-mail address and send mails out...?
Thanks a lot in advance!!
On Thu, 05 Oct 2006 12:57:12 GMT, "BY" <email@example.com> wrote:
>Is there a better way to give a few users the ability to send mails also
>from the info@dom...What was Outlook sending?
I downloaded my messages using the option "send and receive all".
However, the "Show Progress" box indicates that I was also 'sending something'.
But I had nothing to send!
I look in the "Sent items' folder and nothing was sent at this time.
What was Outlook 2003 doing?
The usual response here is, "You have a virus". It could
be that a virus program is using your Outlook to send spam
and/or a copy of itself to people in your address book.
I hope this is not the case, but please have the foresight
(aftersight?) to look into ...Outlook Can't Send Messages
This morning I fired up Outlook 2007 (running under Windows 7). It retrieved all
I then tried to post a new email, (not a reply). However, the nano-second that I
clicked on "Send" I received a reply from "System Administrator".
It said this:
Your message did not reach some or all of the intended recipients.
Subject: The Train Meltdown
Sent: 27-Jul-10 1:18 PM
The following recipient(s) cannot be reached:
firstname.lastname@example.org on 27-Jul-10 1:18 PM
None of your e-mail accounts could send to this recipient.
I have 3 active email ac...'SEND' just sends it to the OUTBOX
Outlook 2007 on WinXP Home SP3. When I click 'SEND' when replying to an
email it does not SEND but puts it in the OUTBOX. I have to click
SEND/RECEIVE from the main page to actually SEND the email. Is there a
setting I am missing? Thank you.
"Peter" <email@example.com> wrote in message
> Outlook 2007 on WinXP Home SP3. When I click 'SEND' when replying to an
> email it does not SEND but puts it in the OUTBOX. I have to click
> SEND/RECEIVE from the main page to actually SEND the emai...Rules Wizard and Send/Receive error
A couple of days ago, I received an alert from Norton
Antivirus software that the file "belt.cab" was corrupted
but could not be deleted. Fearing the worst, I manually
deleted the file.
Since then, Outlook appears to be completely disabled,
with the symptoms being that several commands have
disappeared from the Tools menu including Send/Receive
(both), Rules Wizard, Out of Office Assistant. I can
compose an email, but it will not send.
I have checked my email accounts and all appears to be in
order. Even after a complete reinstall, I cannot
The on...sending Access files
Is there a quick and easy way to send access files
without Outlook blocking them. I exchange files with a
limited selection of people so am happy that what I am
sending and receiving is OK.
I know that I can use WizZip but the knowledge database
also suggests changing the .mdb extension. I don't know
how to do this. Do I just right click over the file and
choose open with Word? Or maybe there is a simpler way.
When you send a file type that on Microsoft's potentially dangerous list,
you get a message informing you that the recipient may not be able to access
the file on...Trying to send emails from an external program
I am trying to send email from my accpac software and it makes me allow the
email everytime. Is there a way I make my Outlook 2007 accept Accpac as a
reliable source for sending emails??
> I am trying to send email from my accpac software and it makes me allow the
> email everytime. Is there a way I make my Outlook 2007 accept Accpac as a
> reliable source for sending emails??
MapiLab's security add-on (free)
...Multiple Send to
In any Document Library you have a Send To drop down option. This can only
be configured once that is only one entry. I have to have 7 Custom Send To
options. Does anyone know how to create more than 1 Sent To?
Girish J Bhatia
MOSS Certified, SharePoint Certified, MCSE2003, MCDBA, CCNA, CCNP, CCSA
...Automatically sending with outlook 2002
I am running Outlook 2002. When I click send, to send an
email, it goes into Outbox. I then need to click
send/receive from Inbox. Is there anyway the email can
just send automatically from the outbox to avoid having to
click send in 2 steps?
Check Tools | Options | Mail Setup
Is the option to send messages immediately selected? Also, check the
Send/Receive Settings | Define Send/Receive Groups.
PATRICK REED [Outlook - MVP]~~~~~~
-Microsoft Certified Professional (MCP)
-Have you checked http://www.slipstick.com?
-Please post your Outlook version!
"Ronk"...still problems with Exchange 2010 and sending to certain domains
We have done the following:
made sure the PTR records matches the IP address of the send connector
created an SPF record
we are still having issues sending to certain domains and we are at a loss.
I've done plenty of 2007 systems and never had this issue. What are we
It simply doesn't make sense.
Do you get an error message back from the receiving server?
On 1/26/2010 10:14 AM, Gene Whitley wrote:
> We have done the following:
> made sure the PTR records matches the IP address of the send connector
> created an...Not In List
I have 4 comboboxes that are each filtered from the previous (Lets say they
are comboboxes A thru D). They are functioning properly. When I enter a
record that is not in the list for Combobox A, it says not in list would you
like to add it?. Answer yes and record is added. Now to combobox B, same
thing happens. However, They should be related. What code do I need to add
to have the record added to combobox B to be related to Combobox A?
Here is the code for the NotInList:
' If Entered Product is not in List allow add.
Private Sub cboProduct_NotInList(NewData As String, Re...