Operating System: Mac OS X 10.5 (Leopard)
Is it possible to validate a cell to have the correct formatting for an email using a regular expression? <br><br>eg <br>
The only thing you can do is verify the presence of the "@" sign.
An email can contain almost any other sequence of characters in up to four
subdomains and still be valid.
For example: John.McGhie@McGhie-Information.com.au is perfectly valid: I
know, because it is mine :-)
So is john@m...Dragging messages to folders
I have been using outlook for a month, and now I have Outlook 2000 Premium, and I am unable to drag and drop messages without a pop up box (journal entry) showing up everytime. My computer is slow as it is, so I would like to get rid of this pop up box on every message I have. Can anyone help? Thanks.
...email button not working
In a custom entity there is a button on the top to send an email. The email
form is filled in and it is send, but the destination does not receive
anything. Not an error, nothing on the queue. Nada.
Any troubleshooting articles that you guys might suggest?
Yes I too would like to know why you can't send email to custom entities.
"Jorge Varas" wrote:
> Hi All,
> In a custom entity there is a button on the top to send an email. The email
> form is filled in and it is send, but the destination does not receive
> anything. N...Drop down List problems
I created a drop down list using the data validation tool. When I view my
list, the little scroll bar on the list starts about 3/4 of the way down the
list instead of starting at the top of the list. (If this is a poor
description of the problem, I am very sorry!) How do I get the little scroll
bar to start at the top? The list is sorted alphabetically and it is a pain
to start in the "T"s instead of the "A"s.
Any help is much appreciated...I have exhausted all my excel knowledge
You have likely selected blank cells as part of your validation range. If
you ...End-User who "recieved" an email from themselves
I have a user who "recieved" an email from themselves- which was really
a spam message. The exchange tracking log states the the suspect email sender
as our user with the firstname.lastname@example.org address.
If I select properties of that sender in tracking, the message ID is
Our real user is listed as just their username in message tracking, and the
message ID properties are:
The Spam filter states the email originated from outside our network. My
questio...drag value not format
Sheet has complicated formating with lines and fills. Need to lokc formating
but be able to drag cell values without the formating smearing over.
Can't figure it out by myself :-(
copy the source cell and paste it with 'Edit - Paste Special - Values'
> Sheet has complicated formating with lines and fills. Need to lokc
> formating but be able to drag cell values without the formating
> smearing over.
> Can't figure it out by myself :-(
Not really what I need. I want to find out how to be able to drag...Sending data via email
Each of my sales people will have a database on their laptops. The database
will run via runtime. I want to be able to email them a text file of data
that I'd like them to be able to upload into the database on their laptops.
Can I do this? How would I write the VBA Code? The text file would be a
fixed width text file. I'd appreciate any help you might be willing to give
You can link the text file and use it as a table in your database. If
the text file never changes name, the file can be overwritten and the
link will still work provided the ...What's causing drop-down box in Firefox to appear taller?
In Firefox the height of the Group Language drop-down box appears taller
than the Category drop-down. This doesn't occur in IE. Anyone know why?
On Feb 9, 9:21=C2=A0am, "Mark B" <none...@none.com> wrote:
> In Firefox the height of the Group Language drop-down box appears taller
> than the Category drop-down. This doesn't occur in IE. Anyone know why?
Hm, it looks really as a bug in Firefox. While difference is just 1px
to me, it really shows it higher
.......Copying emails to another email address
What steps do you have to take to get a copy
of all your emails automatically sent to another
email address? I work both out of my home and an
office and when emails are sent to my email \
address, I would like one to go to my home email
with a copy still in my work email address.
Janie <email@example.com> typed:
> What steps do you have to take to get a copy
> of all your emails automatically sent to another
> email address? I work both out of my home and an
> office and when emails are sent to my email \
> address, I wo...email gets sent but stays in the outbox
When I send email in the stays in the outbox, even though
it was correctly sent, I am running Outloo 2000, with
Found your post because I was experiencing the same
problem. The Virus thing got me thinking and I found the
following on the McAfee Site. Seems to have fixed the
My email client times out and I am having difficulty
McAfee VirusScan version 8
Affected Operating Systems:
VirusScan has the ability to scan outgoing mail for worm-
like behavior. This additional he...XY Scatter Chart
In Excel 2003, I was able to drag individual xy scatter point data to a new
position on the actual graph. This was a great feature when one wanted to
data to get them to coalesce with a scanned curve that had been included in
the graph background. I am not able to do this in Excel 2007. Does anybody
know if this feature is available in Excel 2007?
No. It isn't.
"Darril" <Darril@discussions.microsoft.com> wrote in message
> In Excel 2003, I was able to drag individual xy scatter...Drop Down lists #8
I have a drop down list that has source values taken from F1:F50, as
new values are repeatedly added I would like the source to refer to
the whole F column (ie - =$F:$F), but my drop down list now shows
many blank spaces. How can I make the drop down list ignore the blank
Try creating a dynamic range for your list. Debra Dalgleish has some
excellent instruction on her site at
"cribology - ExcelForums.com"
<Delroy.Kerr@ind.homeoffice.gsi.gov-dot-uk.no-spam.invalid> wrote in message
I should know this but my minds frozen.
In Excel2000, my spreadsheet has many cells with email addresses, many
without. When I click on a cell, OE6 starts without my prompting. I dont
want, nor did I specify that that should happen. Also, the email addresses
(when hovering) are not the same as those showing in the cell, but are
several cells away. When I right click the cell with that address, I can
remove the hyperlink OK, but when I select a range of cells to remove all
those hyperlinks (some cells without hyperlinks), the resulting window asks
me to Insert Hyperlink. Removing each cells li...Drag and drop
I have an application that requires that file names be less that 90
characters long. I can't seem to make my users do this when they save .msg
files themselves. So we have one macro in Outlook that will format the file
name corretly for them. A couple of users get around this by dragging and
dropping their messages to the file system. I would like a macro that gets
fired when a drag and drop is done and tests the file name for formatting.
How do I get a macro to run when they initiate a drag and drop and how do I
access the filename of the messages they dragged?
...Drop Down plus any entry
User wants a drop-down list for common entries but also the ability to enter
anything into a cell. I thought Data Validation would do the trick, but I
don't see how to get the common entries to drop down AS WELL AS the ability
to enter by hand. Can someone point me in the right direction please?
Select your cell.
Click on Data - Validation
In the "Allow:" box, select "List"
In the "Source" box, type in your common values, such as
Common1,Common2,Common3. Don't put a space between them.
Select the Error Alert tab
Uncheck the "Show error a...Send Email Bug in Publisher 2003?
I believe my client has found a bug in Publisher 2003. I've been able to
reproduce it on several PC's so far with Windows XP Pro and Office
Professional 2003 with all updates from office.microsoft.com applied.
Please see below and recommend.
Here's how to reproduce:
1- Create a document with MS Publisher 2003
2- Save the document and close Publisher
3- Re-open the document
4- Select File | Save As, and provide a new name for the document
5- Modify the document
6- Select File | Send Email | Send Publication as Attachement
7- Open the attachment in the resulting new Outlook mess...receving the email i send
I use my hotmail account in outlook 07 (not live mail. my old hotmail
account still works in outlook)
when I send a message from my hotmail account, I receive the same message to
my own adress.
How can and why that happens?
...Money 2004 dragging
Could anyone suggest why 2004 on my XP Home (SP1) might be dragging so
slowly even though I have archived the first 6 months of my money file?
She starts up great, but I get the rolling hourglass on many of the pages.
I back up the file every day to floppy and so far everything seems stable
except the way it acts.
Thanks for the help.
"Smitty" <Smitty@fuhgettaboutit.com> wrote in message
> Could anyone suggest why 2004 on my XP Home (SP1) might be dragging so
> slowly even thou...Excel 2000
*First off:* I have created a spreadsheet that has a dynamic range an
*Next:* i know i can add options to the 'dynamic range' and my dro
down menu will add the option to its list.
*Problem:* How can I make it so the user can add data into th
validated data list/drop down menu rather than having the user addin
it into the dynamic range?
*Example:*this drop down menu indicates how often a system is updated
weekly, monthly, etc. etc... i don't want to restrict it, so i want t
make it so they can indicate their own time on how often those update
-...Export/Import Exchange email records
Please let me know if this can be done:
1. I have two Exchange servers running in different domains A and B
2. Server A has 10 users and have email and AD entries for these users
3. Server A is a new box and only has AD entries and no email in email
Is there a way to export the mail messages, and other records from the
old Exchange mail boxes of the server A and then import it into the
corresponding mailboxes of a new Server B?
"ibsys" <firstname.lastname@example.org> wrote in message
news:1161913259.400787.215710...Excel crashes dragging a chart
I have a problem that I can reproduce on Excel 2000 and Excel 2003 (but not
in Excel 2007). Excel crashes when I try to re-position a chart in a
worksheet with (at least) a cell using data validation.
If I select a cell with Data->Validation a little triangle appears close to
the cell to indicate it has a pull-down menu associated. If a chart is
present on the spreadsheet and I click on it the "little triangle" disappears
as soon as focus is taken by the chart.
In some of my spreadsheet there is a delay before the triangle disappears
and if a chart is dragged at t...Outlook keeps sending out emails that have attachments...
This has happened several times.
If I send out an email, seems to be if the attach is over 1 meg, it will
"get stuck" in the outbox. It will then continue to send out the email
multiple times. today, it sent out over 100 times to several people.
What causes this? How can I resolve this?
We're investigating this problem. What version of Outlook do you have?
What sort (and how many) accounts?
This posting is provided "AS IS" with no warranties, and confers no rights
"Phillips" <Phillips*NOSPAM*@Re...Cannot remove email from user
Exchange 2003 on Windows server 2000, selecting an SMTP email for a
user and selecting to remove it. Once removed it comes back within a
few hours - arhhhhhh!!!! It's driving me crazy because it makes itself
the primary address aswell.
Any help would be greatly appriciated.
you mean an smtp address? is "Automatically update e-mail addresses based
on recipient policy." selected? is it an address your recipient policy
Susan Conkey [MVP]
<email@example.com> wrote in message
> Exchange 2003 ...drop down lists #4
i am trying to make an invoice list. i would like it when i type in a product
or get it from a drop down list for the price of that particular item to show
in the collumn next to it.
thanks so much
You can use the VLookup function to return the price. There are
instructions in Excel's Help, and here:
> i am trying to make an invoice list. i would like it when i type in a product
> or get it from a drop down list for the price of that particular item to show
> in the collumn next to it.
Debra Dalgleish...duplicating / Missing Emails
I am the owner od several GRP Mailboxes. I reacehed the 50 Meg Limit and
moved some mail out to a empty PST File to receive more mail in. Cleaned out
the mail and when I went to put back the mail that I moved it grew in size to
2100 unread from 1800 unread. Any Suggestions on how 300 items were
duplicated and also do you know of an easy way to find them - instead of
going one by one -- Thanks in Advance