A program is trying to automatically send e-mail on your behalf.
I tried posting this in microsoft.public.outlook.general, but no
Does anybody know how to turn the "A program is trying to
automatically send e-mail on your behalf." prompte off?
It pops when one of my MS Access apps is emailing one of it's reports
It happens on the Citrix server that one of my MS Apps is running on,
but it does not happen when the app is running on my own PC.
Consequently I'm hoping for some user-configurable setting that
Is there any way to create a template where a contact is
automatically CC in the email. So I dont forget to cc them
every time I send an email.
...Money 2006 constantly faults with automatic updates
Whenever I use the Internet automatic updates, money faults out and wants to
send a report to Microsoft. Also my account list shows most accounts with a
status of 'Update In Progress'
I've done a complete reinstall after removing it and power cycling my
machine. I thought it may have been something with removing 2004 and
installing 2006, but got same problem
Has anyone else been having this problem? I really just want to go back to
What's the error message?
Glyn Simpson, Microsoft MVP - Money
Check http://money.mvps.org/faq f...Vary Colors in the Same Data Series
What do I need to do so to enable the box to click to Vary Colors by Point?
Currently this option and the one above it (Series Lines) are "greyed out"
for my chart.
What type of chart. What version of XL? How many data point in a series?
Bernard V Liengme
Microsoft Excel MVP
remove caps from email
"Joseph Reilly" <JosephReilly@discussions.microsoft.com> wrote in message
> What do I need to do so to enable the box to click to Vary Colors by
> ...Save static data from web query
I have a worksheet with a web query. The sheet is accessed over the internet
and the web query loads it with data. Is there a way for the user to save
the worksheet together with the data rather than save it with the query
Once the sheet is loaded with data I want to save it containing static data
and no web query...
...Automatic axis format
I'm need to make a automatic axis format within excel.
The number of rows is depending of a imported file.
No problem to get the max. number of rows.
But to put this number into the chart ( category axis) is more problematic.
I try VB but my knowledge is at dummy level !
Waiting for your reply.............
Have a look at Jon's examples of dynamic charts.
> I'm need to make a automatic axis format within excel.
> The number of rows is depending of a imported file.
> No problem to g...combining data from 2 sheets
I have data in 2 sheets which i want it to be displayed in the third sheet.
Please suggest me how to proceed with this...
Sheet 1: Sheet 2 :
No Name1 No Name2
1 abc 1 efg
2 eds 2 xyz
4 def 3 aaa
5 dss 6 ddd
The Result should be :
Sheet 3 :
No Name1 Name2
1 abc efg
2 eds xyz
4 def ...I open the MDB, the form runs automatically
I have an MDB file with 20 files and 7 forms in it.
When I open it up, the form runs immediately an access goes into some
sort of protected mode. I can't view the tables, queries etc. I can
see the code by pressing Alt F11 but not the data.
I created a blank db and imported the mdb so I could see the tables.
But how do I open the original without it running the code?
When I look at the code. I don't see anything that sets properties or
invokes the code automatically.
There are no macros in this, just the forms and associated code with
I'm trying to create POs using GP (version 8.00g34) on our GP server,
however going Transactions -> Purchasing -> Purchase Order Entry generates a
"Cannot access this form because the dictionary containing it is not loaded."
error. The other areas of GP (which I have access to) look OK.
Could there be something wrong with my Dynamics.set file? We have
workstations that use GP and the .set file looks the same.
Any advice would be greatly appreciated.
Thanks in advance,
Check to make sure there security is not looking for an alternate Great
Plains windo...Automatic updates, automatically disabling itself
Automatic updates, automatically disabling itself.
2nd day now onecare popped up to tell me the updates turned themselves =
I'm thinking what malware would want to turn the updates off ?
Any idea what's going on here ? Did I AUTOMATICALLY install an update =
caused this ?
<firstname.lastname@example.org> wrote in message
> Automatic updates, automatically disabling itself.
> 2nd day now onecare popped up to tell me the updates turned themselves
Drop OneCare and install Microsoft Sec...How do I get an automatic equal sign to begin the formula bar?
How do I get an automatic equal sign to appear in the formula bar in Excel
for Microsoft 2003? This happened for me in the 2000 version and I could
just click on it with my mouse pointer, but now all that appears is the
function sign with no equal sign after it. It makes my job a lot more time
consuming to have to type in the equal sign while building formulas. Please
The = icon disappeared in newer versions of excel (xl2002???).
You can add an = icon
Tools|customize|commands tab|Insert category
(Scroll down the list until you find the = icon)
And drag it to your fav...My worksheet automatically adds a fill color when I enter text.
When I type text in a blank cell, the cell automatically is highlightes with
the bright yellow fill. There is no conditional formatting on this workbook.
Check your VBA editor.
You might have an Event Macro which does what, usually, a CF does.
Try to Increase the Macro Security to its maximum level in order to
eliminate the Event Macro from running...
You may, also consider to "rem" all the Macro commands by adding a Preceding
apostrophe to each command.
> When I type text in a blank cell, the cell automatically is highlightes with
> the bright yello...Having numbers automatically appear bold
Had such great advise last time, thought I'd try again.
I have a large range of cells where I will be inputing sales figures i
the form of currency revenue. The range is about G-I and 1-400. Th
sales data will be a comparisson of YTD 2001 - 2004 revenue results.
What I hope to do is have any figure that is above $30,000 appea
automatically in bold so as to stand out as a good client. I gues
there is something in the IF function to do this but I'm stumped.
Thanks again in advance.
Message posted from http://www.ExcelForum.com
select the range you wa...CRM 4.0
How does one configure a WF Local Service / Data Exchange Service in
CRM 4.0? In a custom WF host I can accomplish this by specifying the
service in the host application's configuration file. Is this
approach possible with CRM 4.0?
I understand that the workflow runtime is hosted by the CRM
Asynchronous Service, and I have been able to register custom WF
Activity as detailed in the CRM SDK documentation. However I can find
no references to registering / configuring a local service.
Any help much appreciated!
On Oct 23, 1:38=A0pm, rgdav...@gmail.com wrote:
> H...Import external data into Excel 2007 so I can subtotal it
I would like to be able to use Microsoft Query to import data from a SQL
database into a sheet in Excel 2007 in a raw format, not a table, so I can
subtotal it. I was able to do it once but not since. Everytime I try now it
come in as a table and then the subtotal button is greyed out. Any help in
in answering this mystery is GREATLY appreciated!
You mean Table as in Data>Insert Table?
If a single column Table you can filter and subtotal within the Table
...............or get rid of it.
Right-click anywhere in the Table and Table>Convert to Range
Gord Dibben M...Is it possible to automatically move data entered in columns into rows?
Is it possible to automatically move data entered in columns into rows?
It seems like a simple thing to do but I can't find a function anywhere.
If you enter something in ONE cell it is automatically in a row and a
column. So, perhaps a bit more explanation is in order.
"Richard Thorneycroft" <email@example.com> wrote in message
> Is it possible to automatically move data entered in columns into rows?
>...CE6: How to Disable SIP popup automatically
I know SIP popup can be disabled by the following registry setting in CE5:
But It doesn't work in CE6.
How to disable SIP auto-Popup in CE6?
The SIP Auto Deploy in CE is due to Windows Controls invoke SHSipPreference
(exported by AYGSHELL.DLL).
So the easiest way is to avoid including AGYSHELL (SYSGEN_AYGSHELL)
But if excluding AYGSHELL is not an option, you may need to modify the
SHSipPreference (PRIVATE\SHELL\SHELLPSL\HAVEAYGSHELL\shellpsl.cpp) to supress
SIP s...Determine if a linked cell contains data
Using vba I'd like to change the formatting/colours on a particular cell
if the cell contains text.
So for example:
If Application.WorksheetFunction.IsText(Cells(i, ColNum)) Then
Cells(i, ColNum).Font.Bold = True
Cells(i, ColNum).Interior.ColorIndex = 40
This works fine for cells which do contain text but not for cells which
contain 'linked text'. I have some cells which are linked from a 2nd
sheet and in the 2nd sheet they contain text.
The code above does not work because there the cell contains ='Sheet2'!B93
How can I get ...Automatic Forward
How can I automatically forward messages received from a
specific sender to another's e-mail person?
...Automatic Database Backup
Is it possible to right code to automatically backup a database? And if so
how, or where, can I get information on this?
There are a few way to do this. I have windows scheuler doing this on all
my databases (at 1 min past midnight each day). Open Scheduled Tasks (it's
in the control panel). It's very simple and not likely to go wrong
> Is it possible to right code to automatically backup a database? And if so
> how, or where, can I get information on this?
So I take it that, there is no way t...Automatically format charts with range of dates
What I am trying to do is I have 4 charts that are linked with data from
another spreadsheet. They are basically week totals for my business and make
a chart compared to say last year.
What I want to do though is have an option on my report that I can enter in
a specific date or a range of dates and have the charts automatically filter
the new data in and change. Instead of having to go into the chart data and
changing what series of data I want to have a chart for I want to be able to
just enter eg. "April 12-April 18" and have the charts bring up that data to
reflect the ...External Hard drive 11-29-09
I am looking for a 1 to 1.5TB external hard drive to backup my system
on. I do not want it to run backups automatically. What is a good one?
This one looks good - good price too:
PS: use free Macrium ( http://www.macrium.com/reflectfree.asp ) for
imaging. It is easy to use, fast and works really well.
For 1-2TB drives check:
...Insert date automatically
I have a column with values such as:
And wish to automatically add todays date if the value of the cell is blank
in the mm/dd format. I have used an =If(Column:Column="",TODAY()) in a
column next to it and formatted it in mm/dd to get the desired result. But
how can I take this value (todays date) and insert it back into the original
column automatically and without changing the other valuse?
As always thank you!
Hi, Rick: Here's one way.
Step 1 is to make a backup of your original file so you have a fallback
in case something goes ...Exoported data to Excel
When I export data to Excel and it contains $ values, Excel converts the data
"Number stored as text". To perform any math computations,
we need to select the option "Convert to number".
Is there a way to have CRM export data without converting
these numbers to text?"
use float instead of money
> When I export data to Excel and it contains $ values, Excel converts the data
> "Number stored as text". To perform any math computations,
> we need to select the option "Convert to number".
...refreshing pivot table reports
How do I update a pivot table report, the datasheet gets
updated monthly with new information in nearly 300+ new
rows, but when I refresh pivot tables it does not include
this new information.
Any suggestions will be appreciated.
You could use a dynamic range as the source -- there are instructions here:
> How do I update a pivot table report, the datasheet gets
> updated monthly with new information in nearly 300+ new
> rows, but when I refresh pivot tables it does not include
> this new information.