Concatenating more than 30 items
Does anyone know how to get around the 30 item limit using the Concatenate
Function. I know that you can get around the 7 level IF Function by
referring to another cell in the last False argument, but don't know how to
concatenate 2 cells using this Concatenate function.
You can use the concatenate operator.
=A1 & A2 & A3 & A4
or, perhaps more efficiently (I haven't ever checked):
=CONCATENATE(A1, A2,...,A30) & CONCATENATE(A31, A32,...,A60)
In article <email@example.com...e-mail messages, from outlook, to cd, how to
i have a few thousant e-mail messages in outlook maps.
i want to save them, i would like to burn them on a cd.
i would like to move them just by one klik of my mouse
i can rename them one by one, and then put them in a new
map on C disk, an than burn them on a cd, but i want to do
them all by just one mouse klick.
please can you help me.
What are Outlook Maps??
All of your mail is contained in a file with a .pst extension. You can
export your folders that you want saved to a .pst file and then burn that to
CD (you will need to copy it back to your hard drive and remove the
r...How do you make Inbox messages stay bold until opened?
While in the Inbox, new messages are bold. Just by "passing" by them, the
bolding is removed and it appears the messages have been read. How do you
make the message remain bold until the message is actually opened?
Tools, options, other, Reading pane button - uncheck Mark as read when
Diane Poremsky [MVP - Outlook]
Outlook Tips: http://www.outlook-tips.net/
Outlook & Exchange Solutions Center: http://www.slipstick.com/
Outlook Tips by email:
EMO - a weekly newsletter about Outlo...No message rules?
I just switched from Outlook express (which I really like) to Windows live
mail. It did a very good job of finding my old contacts and messages, but I
don't see my rules.
I used to route incoming messages to specific folders based on sender or
message title. I can't find the corresponding feature in Windows live mail.
Am I just not looking in the right places or does Live mail just not offer
the equivalent feature??
On the Menu Bar: Tools | Message Rules. Don't see the Menu Bar?
The Alt button will temporally enable the Menu Bar, or click on the Menus
...Reject messages with custom message?
A policy has dictated an account of a former employee respond to all
incoming email messages with a custom note and not allow the messages to
accumulate in the mailbox. In fact, for admin purposes it would be great if
there was no longer a AD account and mailbox.
I suggest that you request a few thousand dollars to hire a programmer to
write you a custom event sink so that you can comply with the policy.
MVP - Exchange
"Protecting the world from PSTs and brick backups!"
"just bob" <firstname.lastname@example.org> wrote in message
news:%23...Combo Box Adding Button to edit list items
I have a form which is designed to enter information about jobs we have
completed. It has 3 combo boxes for different types of contacts that are
pulled from different tables. I want the user to be able to select from the
list or add a new contact. I know they can right click on the drop down
arrow for the combo box and select "Edit List Items" but I really would like
to add a button next to each combo box that gives them that option. I have
tried creating a button next to it that opens up the form for the contact and
then a button on that newly opened form to save and clos...block messages
can I block on Exch5.5 some inbound messages coming through X400 Connector.
I have created Contact with internet email address (non AD user)
I have tried Delivery restriction Tab to reject messages from specific
mailbox (that Contact) in the internet, but it doesn't work.
Is any solution, how to filter email@example.com on exch5.5 sp3
On Wed, 22 Mar 2006 11:34:08 +0100, "Marek" <firstname.lastname@example.org>
>can I block on Exch5.5 some inbound messages coming through X400 Connector.
>I have created Contact with internet email addr...Outlook message rules for sent message from me.
There has always been a message rule I wanted, and never asked about. So
now I will.
I default a copy of all my send messages to the sent folder. They are
marked at read... which is good, because if I send the message, I obviously
read it. <grin>
At times, I wish I could send the message to other folders. Example. I
have a folder called "family". If I send a message to "family", I'd like to
be able to put a copy in the "family" folder. I know you could do this, but
the message is not marked as read. Thus, the folder is bolded/...Exchange 2003, lost messages and tracking
AD 2000 domain, single forest, single domain, single exchange site
Windows 2003 Ent
I have a strange problem going on here. I’ve been receiving complaints
periodically about users not receiving message with xls attachments. I sent
the user and myself 3 messages from a test yahoo account with sequential
subjects (1,2,3…) and a .xls attachment. I received all 3 messages and
attachments to my account. The user in question only received the 2nd and
3rd message with attachments.
The message tracking center shows all 3 messages being delivered with the
final entry being “S...Outlook 2003 Error Message #8
When sending messages to my internal MS Exchange
recipients I get this error message.
"You do not have permission to send to this recipient."
Any help or work around for this. I searched the MS
Knowledge Base and could get this exact error to come up.
I'm attempting to remove 3 messages that keep appearing in my Sync Issues /
Server Failures folder. I delete them, and the next day they are back
I've tried extracting them with the ExMerge utility, run in Archive mode to
delete them from the store. It fails, and in the ExMerge.log file it says:
[11:54:12] Error copying messages from folder '\Sync Issues\Server Failures'
Any ideas how I can extract these messages?
I would try disabling any AV on the machine you are running Exmerge on
and see if that works.
On Mon, 21 Feb 2005 09:42:...cannot open deleted items file
Help please.......error message reads:
Folder could not be displayed
Outlook Express could not open this folder.
Possible causes are:
Low disk space.
Is there any way to access this file without having to delete the entire
file? I have messages in it that I don't want to lose. I can't open it,
move it or copy it anywhere! I am running Outlook Express 6.0. Thanks!!!
E&J"S MOM" <E&J <E&J"S MOM@discussions.microsoft.com> wrote:
> Help please.......error message reads:
> Folder could not be displayed
> Outlook Expre...number of messages in inbox
how to find the number of messages currently in my inbox?
If you have the status bar enabled from the View menu and then highlight the
folder the number of items is displayed in the status bar
<email@example.com> wrote in message
> how to find the number of messages currently in my inbox?
...OLE Server Error Message
Access 2002. I am running a database compiled with Access
2003 on a system that is using Access XP (2002). When I
exit the database I get an "information" dialog that says:
A problem occurred while Microsoft Access was
communicating with the OLE server.
Try one or more of the following:
*Make sure you're connected to the network server where
the OLE server application is located.
*Close the OLE server and restart it outside of Microsoft
Access. Then try the original operation again from within
*Reinstall the OLE server to ensure that it's register...NDR Message 5.7.1
I have a problem with message beging recieved through our exchange server.
This recently started. One of our other admins did some tweaking before he
went out of town and we are having a hard time finding out what was done and
yes we have tried to contact him.
Mail sent from exchange users come in fine but when sent from external
addresses (the ones we have tested) do not come in and get a ndr message. I
don't know how long this has been happening exactly but it has been a week
since the other admin left.
Used both DNSreports / DNSstuff and oddly both have the MX and DNS
succes...Allow automatic forward
We do not allow the automatic forwarding.
Now I have two VIPs who want to be able to use the client based automated
forwarding. The problem is, that we don't want to allow this to everyone. Is
there a possibility to do that?
Thanks and regards
On a per user basis - no. It's an all or nothing deal.
You could enable it for particular recipient domains (that the vips want to
forward to) by creating separate settings for those domains. This will,
however, allow others to auto-forward to those domains as well.
blog: www.suneja.com...Taxable versus Non-taxable items
We understand the basics of when sales taxes are computed. For example, an
Inventory Item may be marked as Taxable, Non-Taxable, or Based on Customer.
If we choose Based on Customer, then it uses the tax schedule defined for
the Ship-To address of that customer.
Here's the problem:
Item A IS TAXABLE for customer 1 in Colorado, but Item A IS NOT TAXABLE for
Customer 2 in Georgia.
BUT: Customer 2 is not necessarily a non-taxable customer. That is, SOME
items ARE taxable for Customer 2.
SIMILARLY: Customer 1 is not necessarily a taxable customer. that is, SOME
items are NOT taxable ...Message Tracking with Message ID
I work on the Defense Message System. We get error
reports for messages with a message ID on them. The
problem is how does one find the message that goes with
the ID in a "FIND" of the Sent Items on the senders
computer? I have not found a way that is user friendly to
do this search on the users computer.
ET3 Hettinger USN
...Not-Selling Item Report
Is there a not-selling item report available? I would like to know which of
my items have not sold in a certain period.
There is a Last Sold column available on the Item reports. You could filter
the report by this column.
Advanced Computer Systems
Thanks for your help. This is exactly what I was looking for. (Should have
found that myself).
"Jason Hunt" <firstname.lastname@example.org> wrote in message
> There is a Last Sold column available on the Item reports. You could
> filter the report by this co...Error message Importing INV File
I am using Money 2005 Samll Business and when I try to import a custom
invoice I receive the following error message.
Money cannot import an INV file that was created before July, 2002. Please
try importing a more recent version of the file.
I just created my file tonight and the properties say it was created
11/19/04 so there should be no problem with the date. I am set up for US
Has anyone ran into this and figured a way around it?
...Copy Local Message Rule
I've created a complicated message rule for filtering that I would like to
put on other client machines. Can I copy it?
Is this possible?
WIn2k server/ Exchange 2k w/all current SPs.
...Suddenly no pictures in HTML messages
Running XP pro SP3, Outlook 2002. About Wed. or Thurs, any html messages
received do not include pictures. Did Microsoft send out an update that
might have interfered? Or did I do something I'm not aware of?
Thank you, Roberta
Roberta, you wrote on Sat, 4 Apr 2009 06:52:06 -0700:
> About Wed. or Thurs, any html messages received do not include
> pictures. Did Microsoft send out an update that might have
> interfered? Or did I do something I'm not aware of?
There is no such an update. Verify if the Internet Explorer is in
offline mode (go to the file menu in IE)...cannot move messages
Sometimes when I attempt to move a message from the inbox to a storage folder
I receive the following error message - "An unknown error has occured. The
selected message(s) could not be moved." Why am I receiving this message and
how can this problem be corrected? Any suggestions would be appreciated.
What kind of mail account is it? POP3, IMAP or HTTP?
Both IMAP and HTTP accounts synchronize with the mail server, so moving
a message from the mail account to the storage folder requires that WLM
tell the mail server to delete the message from the server ma...Forwarding email to Blackberry to a remote server
I have Blackberry with an email address on a server in NYC that runs BES 4
and exchange 2000. And I want to have people email to an address on an
exchange 2000 server in Albany, NY and have exchange forward the emails to
the person's mailbox and to the Blackberry in NYC. I have setup the
forwarding system as prescribed by MS, but when people on the NYC domain
email the Albany address they get this error message:
From: System Administrator
Sent: Friday, February 11, 2005 1:57 PM
Subject: Undeliverable:RE: Delivery Status Notification (Failure)
Your message ...emailing as message
Using Publisher 2003. Whenever I send a newsletter as m essage., The document
comes out a little smaller to the person that is ecieving the message.
However, whenever i save the document as aa jpeg file and hen send is a
opicture it comes the exact size which is 8.5 * 11. What can I do to make it
not whrink i want to send as a message and not as a JPEG
If the recipient doesn't have Publisher, then you could try sending it as a
MVP Microsoft [Publisher]
How to ask a question
"Carl Thame" &...