Creating a group of cells. Need Help Please.
Havn't used excel in a while and I need to create a group of cell
corresponding to an input of a min and a max.
Here are the details. On one sheet I have a box where you enter th
min and a box where you enter the max. In another sheet I want
column starting at A2 to output (MIN,A2+1000,A3+1000,....MAX) ho
would I do this
Thundersixx's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3055
View this thread: http://www.excelforum.com/showthread.php?threadid=50207
Name the...How do I send a welcome message to a new created mailbox automatically?
My exchnage send a message automatically but I need to change the message
where do I change it?
On Tue, 21 Jun 2005 16:35:53 -0700, "Ron" <firstname.lastname@example.org> wrote:
>My exchnage send a message automatically but I need to change the message
>where do I change it?
Exchange doesnt do that unless you have something scripted.
If you are referring to the welcome message in Outlook, its called
welcome.msg , but I dont think its been used since Outlook 2002.
So where would I plug in the script? Also I searched for welcome.ms...Creating a template using Publisher
I need help creating a neighborhood directory template using Publisher and
merging an Excel spreadsheet into it. It keeps printing multiple pages of the
first page after I merge.
What version Publisher?
If you have 2003 use the catalog merge for your directory.
Otherwise you need to setup your page as though it is labels. Determine the size
of the area you need for each entry, select labels in page setup, type the size
you determined in the page setup. Adjust the gaps and margins when you are ready
to print (2000 and bel...Embedding worksheet into Word
Has anyone had the experience where when they embed a worksheet into
Microsoft Word, a portion of the worksheet gets cut off?
Is there an easy fix to this?
...Fewer normal template problems with Word 2000 or 2002?
I have enjoyed some things about Word 2007, but I keep having problems
with macros and templates. I am wondering if (a) macros increase the
likelihood of corrupting the normal template in 2007, or (b) if the
older versions of Word had as many template problems. I have used Word
in 2000, with Office 2003, and now with Office 2007 and I don't ever
recall having as many problems as I've had with 2007.
What I'm thinking is that if it is simply a macro problem causing
corruption, I would simply use 2007 without the macros (they're nice
but I can live without them). On the...Send from Word
When I hit the send button in Word or Excell I get a pop
up that say choose profile with Outlook in the drop down.
That is the only name in the drop down. If I hit OK I get
the following Message.
The MAPI Spooler could not be started. Close and then
restartall mail-enabled applications.MAPI 103 (0000004C7)
If I choose to set up a new profile I get a Microsoft
Exchange Setup Wizard. As I try to setup a new profile I
come to the following,
The following unrecoverable error has occured:
The .DLL file for this service is either damaged or could
not be found.
What versi...Unable to repy using word editor
When repyling to an e-mail I receive the following
message, "This form requires Word as your e-mail editor,
but Word is either busy, or cannot be found. The form
will be opened in the Outlook editor instead". I found
article 284900, that states you may get this message when
you have office 2000 and office xp installed on the same
computer. This is not the case on my computer, Office
2000 does not exist, only office xp.
Can anyone help me?
There appear to be a whole host of causes for this error message. Most have
no solution. Here are a few that do:
http://support.microsoft...Error saving a Shared Workbook
I have a user using a shared workbook and gets an error
everytime she does this ONE specific change. She deletes
a line and then saves and gets a message that
says, "EXCEL.exe has generated errors and will be shutdown
by Windows... blah blah blah". If she makes anyother
type of changes it saves just fine. I also had another
user do the SAME change and that person also got that
error message. When the file is changed to "Not Shared"
then the line is deleted it saves fine also. The problem
is obviously with the file itself and that is shared out.
can anybody ...Contact looses Post Office Box field when synchronized to Outlook
When I sync contacts from CRM 4.0 to Outlook, the Post Office Box field from
the contact gets empty.
Anyone has the same issue?
...New Named Range Created Each Time Data Imported into Excel via Macro
I have noticed that each time I import data into an Excel spreadsheet
via a macro, a new named range (for the same range) is created. This
does not pose a problem, but after a while, I'll have a huge number of
named ranges that will never be used. Why does Excel name the range
and how can I stop this? I noticed in the recorded macro, there was a
line .Name = "drd_5". I commented this out to see what would happen,
but it just renamed the range "ExternalData_5". The next one was
You could refresh with differen...Unicode "private use" glyphs in Powerpoint and Word 2008 #2
Office 22.214.171.124 on Leopard 10.5.2, all updates applied to both.
A friend is migrating from Windows to Mac, and has come across
something that we're trying to work around.
He has some .ppt files with font glyphs in from a Unicode .ttf font (a
specific purpose font for showing the LCD display characters on a
piece of monitoring equipment). When we bring the font and .ppt over
to the Mac, the glyphs from the normal ASCII range come over into
Powerpoint 2008 fine, but the glyphs from the "private use" range from
F000 upwards a way don't transfer. In Powerpoint they show as spac...Creating a worksheet in Spanish
Is there a way to create a worksheet on MS XP Pro running
Office 2003 Pro all in Spanish?
All valid formulas -except the ones from the Analysis Toolpack- will
automatically translate to the language of the Excel it's opened in. So any
spanish speaking Excel will translate formulas to spanish, no matter which
version it was written in.
The rest, text constants and such, has to be typed or pasted. Excel will not
translate this herself.
HTH. Best wishes Harald
"Kent" <Kent@discussions.microsoft.com> skrev i melding
news:ACCCBA3A-53B4...Restrict dialog resizing
My dialog is resizable, how can I restrict the resizing to some
minimum limit. Means you can't make it small in width and height
beyond a certain limit. Should I need to override WM_SIZE.
Thanks in advance.
"Roland" <email@example.com> wrote in message
> Hello There
> My dialog is resizable, how can I restrict the resizing to some
> minimum limit. Means you can't make it small in width and height
> beyond a certain limit. Should I need to override WM_SIZE.
> Thanks in advance.
WM_...MFC DLL Dialog Box
I am trying to link a MFC DLL to a MFC executable. The MFC DLL has a
dialog template in it and has one entry point function in it. Dialog
box template has the corresponding class as CLoadDlg.
>From the executable I call the entry point function. Everything is
working fine till this point. Now in entry point function I am creating
a dialog box object and trying to display the dialog box (by calling
DoModal). But this is not working and I see an assertion failure.
Can someone give me some hints on how to get this dialog box up from
extern "C" ...User accout shows new email
On start up a message shows in my user account that I have new email messages
but am using Outlook 2003 and all incoming emails have been deleted. How do I
clear the message
...Events template not saving entries
I am attempting to build an events database using the Events template in
Access 2007. I have made no modifications to the template. It is not saving
the information I add into the Event List table. I first tried entering
information directly into the table. Then I tried entering information using
the New Event in the Link bar. I can find no way to get the entries to save.
Has anyone else had this problem? Is there a fix somewhere? Does anyone have
anything to suggest? Thanks.
On Sun, 7 Mar 2010 05:05:01 -0800, M''Lou Wilson
<MLouWilson@discussions....Word doc format
I tried to email a word attachment written on office for mac 2008 home version, but the recipient couldn't open the doc. recipient using windows xp.
firstname.lastname@example.org <email@example.com> wrote:
> I tried to email a word attachment written on office for mac 2008 home
> version, but the recipient couldn't open the doc. recipient using windows
If they don't have a recent version of Windows Office, they may not be able
to open a .docx file. Choose File > Save As and save as a .doc file.
Adam Bailey | Chicago, Illinois
firstname.lastname@example.org | Finge...Services Invoices Get "DROP SHIP" box checked Automatically
This is a multi-part message in MIME format.
Hello Everybody, Here is another story.
we are GP 10 SP3 and we also a Field Service (Depot Module) installed =
for which we use an Invoice ( SVC000000) and our type is Service type =
At the time of posting the Service Charges being generated by the Depot =
Module, the Drop ship box gets checked automatically for which we can't =
charge the customer for shipping charges.
Basically we eve...save string as unicode
This problem is solving itself piece by piece. I have a legacy VC 6 application and have to fix it to produce a unicode file.
By turning on 'see display unicode string option on under tools/options/debug' I now know that the string I have actually does have the unciode entity. But the routine used bty the application to save any strings is not working correctly - it saves the unicode as ?.
Can anyone show me a very simple code snippet to do this ! I know there is information about settiings...I need to be able check this large application for the settings, ( help please ), drop in t...revision lines on Word
Operating System: Mac OS X 10.6 (Snow Leopard)
I need to show when text is revised by inserting a line in the left margin. This works ok on text, and has worked with tables and ToC in past versions (2004 for Mac). Now in the new version it causes formatting chaos. <br>
I draw a line in the left margin of a page with a table and when the mouse is released the line a) disappears, or b) jumps up to the previous page, or c) jumps over into the table and displaces the contents downward off the page. <br>
I am not using the Track Changes feature. &l...Printing Pictures in word 2007
Hi, I have a problem printing a picture in Word 2007. I know its not my
printer, it has something to do with picture effects - soft edges - 50%.
When I insert the picture, and add the effect, it shows up on my screen, it
also shows up on the print preview screen, but when I print it only the text
I have the picture behind text, but I don't think that this is the problem,
I think it has to do with the settings on the soft edges and 50%.
Can anyone help?
If you can see the pictures in Print Preview (not Print Layout view) and
they don't print, then this...importing excel into word
I have a problem when importing a spreadsheet into word using 2004mac. I =
usually view the word doc in "normal" but when I import excel as an =
using paste special, the view reverts to "print layout" which I do not =
then when I change back to view normal, the sreadsheet is not visible =
than a small black dot on the left hand side of the document. Is there =
way I can import excel into word uisng view normal and still see the=20
spreadsheet?, any comments would be appreciated,
There may be other ways to accomplish th...How can I delete a line created with Shift+underscore?
I can no longer select this line, so how can I delete it. When I search help
for how to delete a "rule," it brings up everything BUT what I'm talking
I'm using Office 2007, and ever since it was installed, I can't find
anything and stuff happens that makes NO sense at all. How and why did that
simple underline become some permanent fixture in teh email I'de REALLY LIKE
TO SEND, NOW.
Please help! Outlook Help is Useless! WCW
That line is actually a "Border Line". Try the following:
- Select eveything above and below the line
- Select the FOR...In excel, how do i create a box on a form for a customer to click #2
how do I create a box on a email excel form for a customer to click on to
acknowledge they agree with the terms and it automatically put a check mark
in the box.
...alignment within text boxes
within a text box, how do I keep the text lines in the heading flush left and
make the body justified? I make the heading flush left, then highlight body
and justuify it-- but when I do-- the heading becomes justified.
Select the heading (high-light) click left justify.
"rebecca1227" <email@example.com> wrote in message
> within a text box, how do I keep the text lines in the heading flush left and
> make the body justified? I make the heading flus...