double clicking and draging a column in a chart to chg data
in Excel 2003, double clicking on a column in a chart and then dragging the
column up or down would change the data in a table upon which the chart
How does one do this in excel 2007?
That feature has been removed in 2007, there is no way to do it.
If this helps, click the Yes button.
"Tom of inns" wrote:
> in Excel 2003, double clicking on a column in a chart and then dragging the
> column up or down would change the data in a table upon which the chart
> How does one do this in excel 2007?
&g...Problems with creating a newsletter
I chose the form "Newsletter - email".
I have created a 3 page newsletter. Now, I have NO IDEA how to send it out
as an email. I do not want to send it as an attachment. I cannot figure out
which "save as" format or what I need to do so that i can email this
newsletter. Is there a website that goes through how to do this?
Am I correct when I say that it has to be html in order for me to send it as
email? That is not one of the options.
Any help you give me would be greatly appreciated.
...transfer data from multiple columns to singlr column
I have data in form a d g
b e h
c f i (but larger scale)
and I need it in a single column going a to z.
highlight you data, copy, go to the column where you want to see the data,
paste special, transpose
> I have data in form a d g
> b e h
> c f i (but larger scale)
> and I need it in a single column going a to z.
You up for using a macro?
'dantuck Mar 7, 2007
How would I update a column with numeric values so that there are 3 leading
zeros for each row?
it is not possible to add leading zeros to a numeric value. Mathematically,
this is redundent and unnecessary.
> How would I update a column with numeric values so that there are 3 leading
> zeros for each row?
hit the post button too quick.
option 1. custom format
if your numeric value is 12345 then see the custom format to 00000000.
note. format do not change data - it just changes the way it looks in the
option2. format to text
then use the c...Merging Duplicate Contacts
Is there an option in V3.0 to merge selected accounts/contacts/leads that
have been selected as duplicates?
yes, from the Contact List or from an Advanced Find for contacts, you can
select multiple contacts and click the Merge icon at the top of the list
(the merge icon looks like two small pieces of paper becoming one larger
piece of paper). When you click it, a merge dialog will appear and help you
with the process.
Sorry for the weak description of the icon by the way :)
"Mandy" <Mandy@discussions.microsoft.com> wrote in message
news:32468F52-66E7-4738-9148-5...Resolving Email Address to existing contact problem
Has anyone else come across this issue in MSCRM3.0? - when you attempt to
resolve an email address to an existing contact in CRM (that does not
currently have an email address stored in their details) the contact resolves
OK but does not update the email address in the contacts details.
Is this by design, or have I found a bug?
...Word2007. Checkbox. No Form
We have a document (not a form) that we would like to use checkboxes in.
This document has a couple of sections where it would be useful if the user
could check if something is applicable. We can't protect the whole document.
Thank you for your help!
I actually used this feature in a form this morning. Although you don't say
what version of Word you are using, you can access the Control Toolbox
toolbar in Word 2003, or in Word 2007, it is on Developer tab.
To show the developer tab, click the Microsoft Office Button and then click
Word Options. S...Global Column Row Preview Font Size
I know I can change the column, row and preview font size for the current
email folder's view, but how do I do it for all of the email folders? I have
loads of email addresses each with lots of folders. I don't want to have to
do each one at a time. Surely there must be a default font setting (even if
it's only in the registry)?
Thanks in advance,
I too would love an answer to this.
"Timie Milie" <firstname.lastname@example.org> wrote in message
>I know I can change the column, row and preview font ...VBA to creating autotext entries or quickparts in different catego
I have a VBA application that basically allows people to easily create
autotext entiries, move them between machines and use them making comments on
assignments. Currently it operates in EXACTLY the same way in Word 2003 and
2007 (using userforms) and I want to keep that as long as possible. You can
see the application at
http://emarking-assistant.baker-evans.com and either the screen image or
the video demos will give you an idea of what I am doing
Currently I store all the comments in a long list of autotext entries that
is displayed in a field with the value of the entr...Multiple copies of email in "Forward to"contact
I am running Exchnage 2003. My CEO has a conatct in our organisation that
refer to his blackberry contact. I have set the forwarding to also keep a
copy in his mailbox.
What happens is that three copies of his forwarded email hit his blackberry
account! Only one hits his internal mailbox.
What I ahve determined is that the front end Exchange server seems to be
creating the additional copies. Is this how its meant to be (don think so cos
its such a nuisance and my CEO keeps complaining about it).
How do I tell the front end server that this guy's mail server is the one
that...Opening pub files created with older Publisher versions #2
I have just upgraded to Publisher 2003 from 2000 and am having trouble with pub files sent to me for our chuch newsletter
which is using Publisher 97
The text is not wrapping around graphics boxes. Can I fix this? I really don't want to go back to Pub 200
Richard this is caused by Publisher 97 not been printer independent.
Even if you went back to Publisher 2000, unless you have the identical font
versions and printer driver you would have issues with formatting.
It sounds like the person sending you the file has a garbage HP inkjet
printer. Get them to install the HP5P laser p...I would like to know how to set up a 'fill in the blanks' form?
I would like to set up a templet of sorts to fill in the blanks for
...Associating Multiple Existing Contacts to an Account, Until CRM 2.x
I have racked my pea-sized brain for endless days for a way to associate
multiple existing contacts (or accounts) to an account.
My client has accounts that have many contacts (or accounts) involved at
different stages of acquiring a new account.
The logical method would be to add a custom attribute with lookup
functionality into the existing CRM contact or account objects but this is
not possible with CRM 1.x.
The resulting UI would allow an end user to associate different contacts (or
accounts) to an account. Example:
- AccountPhysician: (existing account or con...Contacts Search
Operating System: Mac OS X 10.5 (Leopard)
Email Client: pop
I recently deleted some vital Microsoft files, I reinstalled the package and my backup emails, contacts etc, the only problem is that if I do a quick search in contacts it brings up totally unrelated contact and not the contact I was originally looking for ??
On 1/31/10 4:01 AM, in article 59bb1f13.-1@webcrossing.JaKIaxP2ac0,
"David_Marriott@officeformac.com" <David_Marriott@officeformac.com> wrote:
> I recently deleted some vital Microsoft files, I reinstalled the package and
> my backu...How do I insert space between 2 consecutive columns of an XL Shee.
I want to have space between two consecutive columns of a worksheet (of
course, without having inserted another column between the two) in order to
have separated the Border Lines of the adjacent cells/columns. Please guide
me if it can be done in XL.
Can you achieve the effect that you're looking for by using a double
vertical border down the right side of the left column and having no
border down the left side of the right column?
"Shamshad Butt" <Shamshad Butt@discussions.microsoft.com> wrote in
message news:1222EE13-11A9-4354-9F12-D1F1155D3902@microsof...Creating a Macro to Delete Commas #2
I have an excel file that the size will varry. I need a macro that will
check all the fields for a comma. If there is one I would like to get
rid of it. Does anyone have any idea how to do this? I have no idea and
I have been assigned this task.
Message posted from http://www.ExcelForum.com/
No macro required.
ctrl-H for find/replace. find , replace nothing (leave the
replace field blank). You can of course record that within
a macro if you wish.
>I have an excel file that the size will varry. I need a
macro that will
>check ...how do I import my contacts from IncrediMail 2.0 to MOutlook2007
I am new to using microsoft outlook 2007 and am searching for a way to upload
my contact list, from Incredimail 2.0 to Outlook 2007. Any help would be
definitely appreciated, thanks!
How do I save my IncrediMail Address Book and move it to a different
In Outlook - File --> Import and Export ... import the CSV file created via
process noted above
Karl Timmermans - The Claxton Group
Co...Create Exchange mailbox from command line
I'm writing a script using dsadd and I was wondering if it's possible to
create an exchange mailbox from the command line.
Maybe not exactly what you want but it may help:
For Exchange news, links, and tips, check:
"Donovan Linton" <DonovanLinton@discussions.microsoft.com> wrote in message
> I'm writing a script using dsadd and I was wondering if it's possible to
> create an ...creating a backup on 2002 for Money 98
I am helping a friend who has 98. I need to make a
backup of info on my 2002 for him to use on 98. Any
suggestions as to how to do this?
M98 can't read any file written by M02 besides .QIF import. M02 can't write
any file readable by M98 except for .QIF export.
Sounds like QIF export/import is your only choice. I suspect you will find
this doesn't do what you want.
"Carlotte" <Carlotta41@discussions.microsoft.com> wrote in message
> I am helping a friend who has 98. I need to make a
> backup of info on...Creating Text Box in Publisher 2007 Crashes the Application
Hello, we have a clean install of Publisher 2007 under Windows XP SP2, and
when we try to create a text box in a document, (both an existing document
and a blank document), publisher crashes. Office is fully patched.
I ran Office Diagnostics from the help menu and no problems were found and
the issue persists. Any thoughts on how to resolve the issue?
See if selecting a different printer as default helps.
How to view error signatures if an Office program experiences a serious error
Mary Sauer MSFT MVP
http://of...Picture control on a form
What is the best way to fill a form with a picture control so that when the
client window is resized the picture control will fill the form?
Take a look at this and see if this is what you want:
"Al" <Al@discussions.microsoft.com> wrote in message
> What is the best way to fill a form with a picture control so that when
> client window is resized the picture control will fill the form?
> Just Al
&...Null value in form not trapped by beforeupdate event
I have a form in Access 2003 linked to a SQL Server 2005 table. When
I clear the value in a textbox (bound field is varchar and is
required), I want the before update event to run to tell the user the
value cannot be null.
When I press the tab button to move to the next field after clearing
the texbox, the before update event is not triggering and instead I'm
getting the following error:
You tried to assign the Null value to a variable that is not a Variant
data type. (Error 3162)
How can I prevent nulls before and this error from triggering?
...Determine a result of one column based on conditions in two column
Col A Col B Count the number of a's in Col B only when an x is in
x a Result should be 2
z p I can't figure it out
x m Thanks
Hope this help
Please click the Yes button below if this post have helped answer your needs
> Col A Col B Count the number of a...Start macro creating a mail with contact data and autotext
I am working with an user form.
The developing of that form started with Outlook XP with a lot of code
inside for different buttons.
I changed to Outlook 2007 and unfortunately the code of the form was not
What I learned about this is that MS does not support to much code in the
form (or maybe a bug).
They also do not support any longer.
I was sending this form to MS support but they told it is do much code
inside and they do not know, why the code is not displayed.
In Outlook 2003 the code is displayed as in Outlook XP.
Because I do not know real...Printing contacts finally partially repaired
Two printing problems with Outlook 2007, the first solved, the second still
So, finally, I don't know when, Outlook was repaired such that one could
print out individual contacts as detailed address cards. This was broken for
quite some time.
Anyway, now those of us who choose to print out copies of address books are
once again rewarded with this possibility.
BUT..there is always a but, Outlook does not yet completely properly format
the printing for all of the book and booklet possibilities which the software
presents, especially for doing double...