viewing page spreads
Creating a newsletter. Currently I can only view pages
in two page spreads. Is there any way to view a full
spread of multiple page newsletters?
After managing to set up OE-QuoteFix on his new PC, Ed reads a message
from Rachel <email@example.com>...
> Creating a newsletter. Currently I can only view pages
> in two page spreads. Is there any way to view a full
> spread of multiple page newsletters?
In Publisher 2002 and 2003 you can use the Print Preview to accompish this.
Ed Bennett - MVP Microsoft Publisher
B...Insert File Properties
Is it possible to insert a file property (e.g. Title,
Subject, Author) into an Excel worksheet cell for display,
similar to inserting a field in Word? Thus the value could
be centrally managed yet appear multiple locations where
inserted throughout the document.
use the following UDF:
Function DocProps(prop As String)
On Error GoTo err_value
DocProps = ActiveWorkbook.BuiltinDocumentProperties _
DocProps = CVErr(xlErrValue)
and enter in a cell
=DOCPROPS("...How do I send a two page Publisher Document in an e-mail?
I have created two pages in Publisher and would like to have them appear in
the body of my message rather than as an attachment. Is this possible and if
so how do I do it?
Aprilffg <Aprilffg@discussions.microsoft.com> was very recently heard
> I have created two pages in Publisher and would like to have them
> appear in the body of my message rather than as an attachment. Is
> this possible and if so how do I do it?
You need to create a longer single-page version.
Copy and paste the contents of page 2 onto page 1, below the contents that
were originally on page...Insert File Default
In Outlook XP, when you click Insert / File Attachment - How can you set a
location to look for the file as your default?
Thanks in advance
See if the information on the following page helps:
MVP - Outlook
*** Replies sent to my e-mail address will probably not be answered --
please reply only to the newsgroup to preserve the message thread. ***
"The Fatman" <firstname.lastname@example.org> wrote in message
> Hi Folks,
> I...number of characters in POP
This client wants to be able to expand the number of characters for the item
description in PO Entry so that more characters will print on the purchase
But, when I go into Modify Current Window, I cannot find the field for the
item's description nor am I able to tell if it is possible to increase the
number of characters for this field.
Does anyone have any ideas on this? Perhaps, it's not possible to simply do
this with Modifier.
It is not possible to modify the length of the description field. However
this is what I suggest.
a. You could...Changing 'volume' and 'issue' numbers in monthly publications
A previous post suggested saving the current newsletter as 'publisher
template' then entering the new information. However, when I do this
Publisher does not update the 'issue' number.
How do I accomplish this without starting from scratch each month and even
then, get the 'volume' and 'issue' numbers to automatically update or change
How would the program know what system you use for the designations? Do it
manually. You only have to change it on the cover.
MVP Microsoft [Publisher]
"Midge" <Mi...Creating a Microsoft Words document from an existing Excel spreads
I need your kind guidance on how to create a new microsoft words document
using an existing excel spreadsheet? At present, I have an excel spreadsheet,
say "data.xls" containing data for example 6 fields such as COMPANY NAME,
DATE, ITEM1, ITEM2, ITEM,3 & QUOTATION TOTAL. Under these 6 fields are some
records of my customers.
COMPANY NM DATE ITEM1 ITEM2 ITEM3 QUOTATION
---------------- ------- -------- ------- --------
ABC Limited 3 Apr xxxxx xxxxx ...Conditional format number
Use mix of xl 2002 and 2003
I would like to format my numbers so if value in colF is blank or
then format my formula result in colK for accounting format, no symbol
2 decimal places.
Otherwise format with date format mm/dd/yyyy
Sample data Cell F5:
10/1/2004 8:35:39 AM
Sample formula Cell K5:
And I currently have custom format on ColK for mm/dd/yyyy
However, soemtimes this leaves me with:
Which I do not wan
goss's Profile: http:...QS2000 Auto-Increment Customer account number problem
I have a customer that is running QS2000, version 3.01N, and has for
years had the option set in the INI file to auto-increment the account
number when adding a new customer. Suddenly, a few weeks ago, the
auto-increment stopped working and all the system will do now is try
to assign the last new number that it assigned (and yes, it is
assigned to a valid customer).
I can't find anywhere in the tables where a "last new number used" is
stored. I would appreciate any ideas on how to fix this so that it
will start assigning the correct numbers again. I have already tried
to repair ...find the printable page height
Does anyone know how to find the above
...1/2 page copy on other half?
I have created a document on 1/2 half of the page and want to duplicate the
document on the other half without having to copy and paste evey
text box or picture and reset it all up. How do I save the completed half
as one file so it no longer changes and then copy it onthe other half. Ir
even copy another half that can be changed???
> I have created a document on 1/2 half of the page and want to
> duplicate the document on the other half without having to copy and
> paste evey
> text box or picture and reset it all up. How do I save the complete...Excel: Convert Number (1) to Text (one)
I am working on a excel document that is linked to a word document. I
need to know if there is a function that will allow me to do the
following for instance:
"1" changes to "one"
"20" changes to "twenty"
"256" changes to "two-hundred and fifty six"
I have been unsuccessful so far and really could use some help.
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
Hi Alex, The following is a nice compre...Printing Row 1 at top of each page
This seems obvious, but I cannot get it to work. I am trying to print out a
doucument that has multiple pages, and I would like to have the header
information that is in Row 1 at the top of each printed page.
I have gone into Page Setup, and the tab called "SHEET", but it will not let
me enter any info in the "Print Titles" section.
Is there something that I need to do first in order to make these changes
"Lance Gray" <Lance Gray@discussions.microsoft.com> wrote in message
news:D1734460-9541-4AA4-A7DB-A52F67C863FC@microsoft.c...don't show the page breaks on the worksheet
After you do a print preview of a worksheet the dotted lines will show your
page breaks on the worksheet. Is there any way to NOT see the dotted lines
after doing a print preview?
You can turn off all page breaks under tools>options>view and uncheck page
breaks or use a macro with this line
ActiveSheet.DisplayPageBreaks = False
so you could make 2 macros, one that turns them off and and one that turns
them on. Don't know if it is worth all that work for being a little annoyed
> After you do a print preview of a worksheet...will Front Page 2003 work with Windows 2007 / MS Office 2007?
I purchased a new computer and software. It came with Windows 2007 and I
purchased MS Office 2007. I have my own business and do my own web page and
was using Front Page 2003 on my old computer. MS Office 2007 Pro does not
have Front Page so now I can not up date my web page. Can I install Front
Page 2003 on my new computer with Operating system 2007 and MS Office 2007?
Hope for some help.
Thank anyone and everyone in advance.
> I purchased a new computer and software. It came with Windows 2007 and I
> purchased MS Office 2007. I have my own ...change info in other cells when i change a number in a drop list?
Im trying to figure out how to change the info in a few other cells when i
change a number in a drop list in Excel.
Try something like this:
Of course, you might not need all parts of it. :)
"macbr549" <email@example.com> wrote in message
> Im trying to figure out how to change the info in a few other cells when i
> change a number in a drop list in Excel.
...Voided Sales Documents
It would be nice if we could look at voided sales documents, maybe in a
special historical view , and have a choice to restore them.
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.
http://www.microsoft.com/Businesssolutions/Community/NewsGro...How can I insert a row and have the existing formulas apply?
I have a table which has a column that uses a formula. When I insert a new
row in the middle of the table, Excel inserts a blank cell into the column
with formulas, rather than keeping the formula that applies to the adjacent
How do I insert a row and keep the column with a formula so it applies to
that new row?
Charity Worker in Africa wrote:
> I have a table which has a column that uses a formula. When I insert a new
> row in the middle of the table, Excel inserts a blank cell into the column
> with formulas, rather than keeping the formula that applies to the adjace...How do I print numbered tickets using a business card format?
Printing tickets using publisher. How do I get the numbers to advance per
card? I need to print 250.
You need to setup a consecutive numbered data base to merge from.
There is an Excel way here, it is about the same in Access
Mary Sauer MSFT MVP
"pattyv" <firstname.lastname@example.org> wrote in message
> Printing tickets using publisher. How do I get the numbers to advance per
> card? I nee...How do I insert Roman Numerals?
New to Word 2007 would someone please explain to me how to insert Roman
Numerlas in my document?
"ckj" <email@example.com> wrote in message
> New to Word 2007 would someone please explain to me how to insert Roman
> Numerlas in my document?
Just type them...
Type a number e.g. 21, select it and run the following macro
Dim oRng As Range
Set oRng = Selection.Range
oRng.Fields.Add oRng, 34, oRng.Text & " \*Roman"...How do I view all data in a cell regardless of number of characte.
Click in the cell.
Look at the Formula Bar!
Please keep all correspondence within the Group, so all may benefit!
"DavidMarquez" <DavidMarquez@discussions.microsoft.com> wrote in message
Also, if you mean how much cell content you can display on the sheet, itself,
however, that's a different story. A cell can display up to 255 characters
wide (column width) by 409 points tall (row height). Font s...Can�t navigate pages
I am running P2002 on XP. I have a number of multi-page documents which
normally have a line of page numbers along the bottom of the screen allowing
me to navigate from one page to another. Sometimes theses numbers will
disappear while I am working. Today I tried opening a set of documents I
have not looked at for some time and the line of page numbers will not
display at all, so I can�t navigate through the document. Does anyone know
what is wrong? (I can work around this by clicking the print preview icon
then clicking through the document to the required page and then hitting
esc, but this ...OUTLOOK caused an invalid page fault in module SHDOCVW.DLL
I receive the following error message when opening HTML
formatted e-mail in Outlook:
OUTLOOK caused an invalid page fault in module SHDOCVW.DLL
I do not seem to get this error whenever I open plain text
e-mails. How do I resolve this issue?
Windows 98 SE
Internet Explorer 6 Service Pack 1
...Insert Comments on a Protected Worksheet
hi - I have a worksheet with areas that are locked, and a range B5:H23 that
is not locked. Protection has been applied to the sheet. The user is
allowed to SELECT unlocked cells.
My problem is that I want to be able to INSERT COMMENTS in the unlocked
range. I can't seem to do this while protection is ON. (Comments can only
be added when Protection is OFF) What am I missing?
thanks in advance
When setting sheet protection allow users to "Edit Objects"........down near
bottom of list.
Then you can Insert Comments in unlocked cells.
Gord ...Default document's path
I recently posted a question regarding default path; I'd like to widen this
Suppose we have MDI application (with two or more document types, if it does
matter). After first call of (wizard generated) menu option "Open" or "Save"
or "Save As" we can see dialog opened at location of current user's My
Documents folder. I would like to change this path for one, default path. It
seems to be extremely easy...
I tried calling CDocument::SetPathName(strMyPath); - with absolutely no
results. What should I change to set new path that will be used ...