Emailing in excel 2003 02-26-10If i type in the cell A34: neil.Holden@test.com and press a button is it
possible to email to the address of what ever is in A34 is?
The email body should say: this has been submitted for cell B34 and todays
date.
Thanks.
Check out Ron De Bruins "Send-Mail" tips:
http://www.rondebruin.nl/sendmail.htm
Micky
"Neil Holden" wrote:
> If i type in the cell A34: neil.Holden@test.com and press a button is it
> possible to email to the address of what ever is in A34 is?
>
> The email body should say: this has been submitted for cell B34 and...
Opening a new instance of ExcelI am using multiple monitors for work and it is great! Is
there a setting that I can use so that it opens each new
excel file in a new excel window so I can drag different
ones to each monitor? Is there a similar setting for Word?
I am using Excel 2002 and Word 2002.
Thank you.
Hi,
Yes, you can check the Windows in Taskbar checkbox in
Tools; Options. This is on the View tab for both Word
and Excel.
>-----Original Message-----
>I am using multiple monitors for work and it is great!
Is
>there a setting that I can use so that it opens each new
>excel file in a new excel ...
Outlook2k7 over VPN Out of Office Assistant problemUser's computer is not a member of the domain. Mail flows and all
looks good till you start the OOF thing. It will just tell you it
cannot connect to the server because it's currently unavailable. Now
when we add autodiscover.domain.com pointing to the Exchange server to
the host file of that computer it works but why? Without it when you
run a test it will tell you that a Srv Record lookup for domain.com
FAILED (0x8004010F) or Local autodiscover for domain.com FAILED
(0x8004010F)
yaro
Hello yaro,
Thanks for your post.
The error 0x8004010F usually means MAPI_E_NOT_FOU...
Illegal operation error while printing EXCEL or WORD FilesHi,
I am facing an illegal operation error when i try to print any file from
excel (any no. of pages), this happens in stand alone printer as well as a
networked printer.
When we press the print button, it flashes this message, but still prints,
but once the printing is completed, i will have to restart the PC. Due to
this error other applications PRINTING also will NOT HAPPEN and the only way
out is, restart the PC.
This happens not only in EXCEL, it happens in all the MS applications
(outlook, access, front page, powerpoint also).
When I check the print manager (before restart),...
how do I add times in Excel and result in hours & minsI want to insert a time when I start work and a time when I take a break,
then a time when I leave work.
Following that I want to be able to add up the amount of hours that I have
worked.
This will enable me to plan my week ahead and ensure I only allocate a
specific amount of time to a project.
http://www.cpearson.com/excel/datetime.htm#WorkHours
--
Kind Regards,
Niek Otten
Microsoft MVP - Excel
"Rty Shaw" <Rty Shaw@discussions.microsoft.com> wrote in message
news:37D03D72-5525-4D6E-8ED7-2911B16248B0@microsoft.com...
>I want to insert a time when I start work and...
Importing Data into an Excel Pivot Table via AccessI have set up a query in Microsoft Access which is linked to our AS400
server. I have created pararmeters within Access which asks for certain
fields which works. I then go into Excel and create a pivot table with the
external data source that I have created in access. When I go to enter a
pararmeter within Microsof Query I get a reply saying that "Parameters can
not be used with this Query", what I want to do is setup a parameter on the
Excel spreadsheet which then goes and gets the data i require from this
parameter. I would be very grateful if someone could help me with thi...
Frontpage 2003 or Publisher 2003 ?Which one should I use? I am not familiar with Publisher. I am familiar with
FrontPage. What kind of support is needed on the server side for a web ?
cgi? etc. Any info or a link to some info appreciated.
Hi Cracker Jacks (cjacks<nospamz)@verizon.net),
in the newsgroups
you posted:
|| Which one should I use? I am not familiar with Publisher. I am
|| familiar with FrontPage. What kind of support is needed on the
|| server side for a web ? cgi? etc. Any info or a link to some info
|| appreciated.
I recommend FrontPage 2003. FrontPage 2003 doesn't REQUIRE FrontPage Server
extensions,...
VBA from another app: Suppressing Excel confirmation dialog?After creating/formatting several worksheets from MS Access, I'd like to delete
the "Sheetn" worksheets that got put there when I did a .WorkBooks.Add.
I avoided using them because I'm not sure how/why they are created - i.e. maybe
some user's defaults would only create 1 empty sheet or none.
So, form MS Access's VBA I'd like to do:
On Error Resume Next
.Worksheets("Sheet1").Delete
.Worksheets("Sheet2").Delete
.Worksheets("Sheet3").Delete
.Worksheets("Sheet4").Delete
On Erro...
EXCEL TROUBLESHOOTING #2I have an excel file (2000 format), that after I made a
number of changes is causing me problems when I re-open
the file. Windows task manager goes to 100% CPU
activity, and i cant do anything within the excel file.
However, if I set recalculation to manual before I open
the file, all seems fine.
Obvioulsy I have a problem. But how do i find that
problem ?
Thanks in advance.
I have had some experience running large spreadsheets lately. Above a
certain size, the recalculation time seems to climb very fast. While Excel
is recalculating, you can't do anything anyway.
Best in my v...
Office:mac v.X #2Version: v.X
Operating System: Mac OS X 10.5 (Leopard)
Processor: intel
I have subject version of Office. I know that there must be updates to this so I can bring this up to date but I can seem to find the ones I need to start the process. Can someone get me to the beginning? Thanks!!!
You can get the Office X 10.1.9 update here:
http://snipurl.com/22zx4
On 3/30/08 3:09 PM, in article ee96b4c.-1@webcrossing.caR9absDaxw,
"AWOLGolfer@officeformac.com" <AWOLGolfer@officeformac.com> wrote:
> Version: v.X
> Operating System: Mac OS X 10.5 (Leopard)
> Processor: intel
&g...
Excel Edit F2 button changed for Mac???Switched to Microsofts version of Excel for Mac. Can anyone tell me
what keystroke allows me to edit a cell? Before I switched to a Mac
it was the F2 button. Please help. Thank you.
See the answers in the m.p.mac.office.excel newsgroup.
In article <1176582208.958694.269620@q75g2000hsh.googlegroups.com>,
ssears@indy.tds.net wrote:
> Switched to Microsofts version of Excel for Mac. Can anyone tell me
> what keystroke allows me to edit a cell? Before I switched to a Mac
> it was the F2 button. Please help. Thank you.
...
Outlook 2003Hello.
I copied my PST file from my D: drive to my F: drive.
I then went into "Data File Management" to get the new location
recognized and to have all future mail sent to that location.
After doing this, my custom settings, like new folders, date
settings, columns, etc, are all back to their default settings.
Is there any way I can get my custom settings working again on the F:
drive?
Thanks,
Dan
Could you explain yourself a bit more? What custom settings are you refering
to? You mean views? And what new folder settings?
Also post your version of Outlook.
--
Robert Spar...
Does anyone have a dashboard gauge (speedometer style) for Excel?I am trying to create dashboard charts from Excel data and would love other
templates not available in Excel today - speedometer charts, multi-dimension
comparitive charts, charts that build information overlays.
I regularly create these in a manual way for executive and customer
summaries but would appreciate the ability to automatically generate these
types of charts allowing for real time viewing of "what if" scenarios.
Steve, there are tons of these things out there to review, few better than
this collection:
http://www.andypope.info/charts.htm
Andy Pope has put together...
Office XP to Office 2004 QuestionHi,
I am sure this question has been asked many times, but I've never had
occasion to look at Mac NGs before, so please accept my apologies.
I am a Windows XP user who is contemplating the change to a Mac. I have
Office XP Pro installed on my Windows machine, and I accept that I'll
need to get the Mac Office (Office 2004?) when I change over.
I understand that Word, Excel & Powerpoint files should migrate in a
fairly straightforward manner, but I am less sure about Outlook to
Entourage. (I'm assuming here that Entourage is the Mac 'equivalent' of
Outlook?)
I h...
Excel CrashI use Excel and Word 2003 using Windows NT. I've kept some files on a jump
drive so I can work on them at home. I attempted to work on a Word documents
which had an Excel worksheet inserted in it. I tried double clicking on the
worksheet to edit it and Word and Excel shut down. Now when I attempt to
open Excel at home it asks for my Office XP Professional installation cd. (I
have Office XP at home with Windows XP). I'm having a hard time locating my
original discs. Does anyone have any suggestions or experience anything like
this?
...
Installing office 2000 disk 2 with publisher on upgraded windows xI can not get disk 2 to install. It preloads then as files start to copy, it stalls then ends with error message. this is office2000 professional 2 cd set.
everything else works exept publisher and its components.
Please advise
Thanks
What is the error message?
--
JoAnn Paules
MVP Microsoft [Publisher]
"cugolfn" <cugolfn@discussions.microsoft.com> wrote in message
news:F57B8716-65FA-4619-93A4-AA24D44ABC33@microsoft.com...
>I can not get disk 2 to install. It preloads then as files start to copy,
>it stalls then ends with error message. this is office2000 profess...
Excel to check for regular expression?Hi,
How do you use Regular expression in excel? For eg: Check a column of
data to see whether are all of them valid email addresses?
Please advise
THanks
By valid, do you mean that the email is in proper syntax or that it is an
actual email address.
Text formulas can be used for proper syntax. Perhaps a Visual Basic
proceedure.
I doubt you can check that the email address actually exists, as many
companies and ISPs will simply disregard and drop mail to invalid email
addresses to eliminate spam
"user" wrote:
> Hi,
>
> How do you use Regular expression ...
Outlook 2003 Contact dataJust starting using Outlook 2003.
When composing an email, when go to address the note, it appears that there
are 2 Contact files - 1 is "blank" and the other has lots of my contacts.
It is the latter contact file that I enabled to use as my address book.
Initially address book comes up the first one and I get error message. Then
I toggle to the second one and all the names are accessible.
How do I get rid of the one that appears blank, so only one contact file
appears when I go to address an email?
Les <lester123_nospam@comcast.net> wrote:
> When composing an e...
Does anyone know where I can download EXCEL.MSI?I am missing my Excel 2002 CD, and can't install Office Update Service Pack 3
without this file.
...
Excel ignores boot-time regional settings when interpreting a dateI have a third party DDE app that exports dates as strings, correctly
using the short date format in the regional and language settings,
which, in my case is MM/DD/YYYY (reset at every boot).
Unfortunately excel insists in interpreting that date as DD/MM/YYYY
[Application.International(xlDateOrder)=1, it should be 0],
disregarding my regional settings. The result is that all the dates are
wrong or #VALUES!
If this is not wierd enough, listen to this: it only happens after I
reboot (when the date format is reset to MM/DD/YYYY). If subsequently I
change the short date format in the regional se...
outlook 2003 memory leak? /messages display as"none" and eats up memoryHi there;
When a certian user opens outlook, and clicks on sort by
size, half of her e-mails disappear, and "none" is
displayed. She said this happened to her at home, except
she was on her normal view which is sort by date. The
only way that I can recreate the problem is to click on
sort by size.
If you click on one of the "none's" or even hover the
mouse over it, the memory will spike up! I had the
performance tab open while I was doing this, and the
memory being used was read at 1.46 GB! And if I close
outlook the memory drops down to normal. I took ...
connect a form to excel databaseI have a database in excel which lists our stock and prices etc. I would like
to be able to enter a stock number on an invoice that will retrieve the
details and price from my excel database. Can this be done?
Excel has built in option--try data|form.
If that doesn't quite work, but it's close, John Walkenbach has an enhanced
dataform at:
http://j-walk.com/ss/dataform/index.htm
And if you want to design your own, Debra Dalgleish has a get started with
userforms:
http://contextures.com/xlUserForm01.html
Kathy wrote:
>
> I have a database in excel which lists our stock and p...
UrgentHow do I get my X axis and Y axis to auto scale inside my chart when I add
new data in my spreadsheet?
--
Sandi Gardner
"Sandi" <Sandi@discussions.microsoft.com> wrote in message
news:E4D8613F-13C3-4C1B-9576-95E44B0AE156@microsoft.com...
> How do I get my X axis and Y axis to auto scale inside my chart when I add
> new data in my spreadsheet?
The default is to do so.
Check Format Axis/ Scale, and ensure that Auto is ticked for Min & Max.
--
David Biddulph
That works for my Y axis but I also need my X axis to auto scale also.
--
Sandi Gardner
"David B...
Exchange Server 2003 Fails to Start after rebootSince rebooting our Exchange 2003 server running on Windows 2003 server
it fails to start the System Attendant and any further exchange
services. The only way to logon to the server is boot in safe mode with
networking.
The server is a member server and is reporting the following errors
EVENT 2114 MSExchange DS Access
Process INETINFO.EXE (PID=1720). Topology Discovery failed, error
0x80040a02.
EVENT 2102
Process MAD.EXE (PID=2176). All Domain Controller Servers in use are
not responding:
crstgs003.CRSTG.LOCAL
crstgs004.CRSTG.LOCAL
EVENT 2114
Process MAD.EXE (PID=2176). Topology Discovery ...
Excel Cells Contents to HTML Pages
Hi,
I have an excel sheet which has two columns.
Column 1: PageName
Column 2: HTMLCode
PageName has information like: OurServices.htm which is the name of th
HTML page.
HTMLCode clumn has actual HTML Code like:
<html>
<head>
<meta http-equiv="Content-Language" content="en-us">
<meta name="GENERATOR" content="Microsoft FrontPage 5.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<meta http-equiv="Content-Type" content="text/html
charset=windows-1252"> ...