Combining two publications
I have two publications.
I would like to selct and copy several pages (a section) from publication #1
and insert them in the middle of the second publication. The pages in
question do not have bojects linked to others outside of that section. The
two pages in the second publication, between which I want to insert these
pages are not linked.
Would *love* if I can do this.
Here is how I would do it using Publisher 2000.
Start Publisher, open file 1.
Start Publisher a second time and open file 2.
Insert pages where wanted in file to be the final.
Copy page/s from other file to t...Editing external data via ODBC
I'm in the process of transitioning an excel/access (2003) based
solution to a web-based one. Right now, we have a dozen or so separate
spreadsheets and a couple of access databases that get updated several
times a day. I've managed to import most of the data into a mysql db
which I've tried to normalize as much as possible. This will be the
backend db for the webapp.
I've set up an ODBC connection from excel to the db and it works like a
charm; a few query tweaks and I can reproduce the data from all the
separate spreadsheets. But now, how about going the other way? ...What is the cell data reference for 5th row and 7th column called
Can someone help me with this question? I need to get the answer for my
homework. Thanks for your help.
I'm guessing, but might it be G5?
Please keep all correspondence within the NewsGroup, so all may benefit !
"Shyemail@example.com" <Shyfirstname.lastname@example.org@discussions.microsoft.com> wrote in
> Can someone help me with this question? I nee...Location of Tasks public folder
We use a public folder to manage tasks on a network running Win2000.
Does anyone know the actual location of this folder, ie; where does
Outlook normally store these folders ? The reason I need to know is
that I am using a program called Mighty Sync which has the ability to
synchronise any file or folder with my PDA. I have admin rights.
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
All public folders are stored on the Exchange server in a publics
folders mail store....Cell Contains Data.
How can I tell a cell that IF a cell contains data (numbers, text, whatever)
do x or y. How can I identify data?? I don't want to tell the function to
look for a specific number or text, just data, just something in the cell...
"GEM" <GEM@discussions.microsoft.com> wrote in message
> How can I tell a cell that IF a cell contains data (numbers, text,
> do x or y. How can I identify data?? I don't want to tell the function ...Data Validation
I have noticed the "Ignore blank" check box in my Data Validation
window (XL2003), but i cannot figure out what it does. Nor can i find
an answer in the Help files. Just what does this option do?
Ignore Blank: If checked, blank entries are allowed.
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
> I have noticed the "Ignore blank" check box in my Data Validation
> window (XL2003), but i cannot figure out what it does. Nor can i find
> an...Exchange 2003 Enterprise / Public Folder Store
I have the following configuration:
- Windows 2003 SP1 with Exchange 2003 Enterprise SP2
- 2 OU with users
- each OU has it's own GAL, AL and OAB
I created two public folder stores for each OU and to give each OU access to
a public folder store. But I even can't my additional Public Folder Store in
Outlook. Additionaly I try to replicate one OAB to the additional Public
Thanks in advance.
"But I even can't my additional Public Folder Store in Outlook. "
You want to clarify that?
"Fabian K�lling" <FabianKlling@dis...Publishing web site using ProntPage 2003
I noticed that when I publish web site to the server after I made changes,
some of the files in the server are not changed. But some of them do get
changed. The unchanged files are not used in the web but still stay in the
server. I have no control of this. Can I force the server to match exactly
the web in my PC when I publish (delete all the extra files)? Thanks.
You probably got the wrong newsgroup, this is excel
> I noticed that when I publish web site to the server after I made changes,
> some of the files in the server ar...Import of Data into RMS 2.0?
We will be converting to RMS soon. Is there anyway we can import our old
sales history(Monthly) into RMS 2.0?
I am not aware of a free utility that will import all data, including sales
transaction history to your RMS system. Retail Realm has an Import Tool that
will do this if your current system is Microsoft Point of Sale, possibly POS
2009, but it is licensed (meaning you need to pay for it).
Otherwise, I believe you are limited to importing items, customers,
suppliers, and UPCs as Aliases, no history.
"newbierms user" wrote:
>...How do you import a pdf file into Microsoft publisher 2003
I'm doing my kid's school directory. I have ads thathave been submitted as
pdf files. How do I place those files on my pages. Microsoft doesn't give me
the answer; neither does adobe.
A small child turns to Ed, and exclaims: "Look! Look! A post from
> I'm doing my kid's school directory. I have ads thathave been
> submitted as pdf files. How do I place those files on my pages.
> Microsoft doesn't give me the answer; neither does adobe.
You need to convert the PDF files to graphics suc...Adding data from multiple cell and linking to a new worksheet
I have data in a sheet with names and amounts due. Like
There is a second sheet named summary. I want the totals of each person to
appear in the summary sheet. These should be linked cells and any change in
data in sheet 1 should be updtaed automatically
Create a PivotTable
"Rashmi" <Rashmi@discussions.microsoft.com> wrote in message
>I have data in a sheet wi...cannot see inserted pictures in publisher 2003
cannot see pictures in 2003, although frame adjusting dots appear. I open new
page, select insert picture (doesn't matter where from, still no different).
Help please. Program worked on original pc which originally had an earlier
version of publisher installed. The program is not an update, but full
PC P4 running XP home and office XP
View, pictures, detailed display..
If this is not the solution, you may need an upgraded video driver.
Slide the acceleration down on your adapter, control panel, display folder, settings
tab, advanced button, troubleshoot tab.
If thi...using data from another cell
I would like to type a name in one cell(1) then check in list (different
column) if the same name is there, and if it is there get a value of another
cell locate in the same row where. Can some one help me?
Create your second list and use VLOOKUP as follows:
Name is typed in: A1
List of names and values in: C1:D10
"leo" <email@example.com> wrote in message
> I would like to type a name in one cell(1) then check in list (different
> column) if the same name is there, and if it is t...data available to MS Access
I'm not able to see the multiple entries of a sharepoint item with a
mulit-line text column --I can only access the text of the last entry. With
other multi-value columns (attachments, single-line text, numbers, etc), I
don't have a problem getting the multiple entries.
...Data not valid error message
Have a Report which appears fine. But when you go from DesignView to
ReportView it throws error:
~.."the data you entered for this field is not valid"...
it doesn't say which field.....I can click thru the message and it reprompts
this a few times (probably once per instance of invalid) and then opens fine.
it does not do this when the Report opens ; only changing from design view...
but it does do it if it is multipage and you need to go to the next
page....so needs to be fixed...
there's alot of fields and so am wondering how to troubleshoot....hunch is
t...Publisher collate HP
I've got 2 HP printers and Pub will not print and collate
to them using the HP driver. If I use a generic or
windoze driver it will. HP says it's a Publisher issue.
It prints fine in Pagemaker so HP is right. MS has
addressed this issue but wil not solve it. What can I do
tot use features of the printer lost in the generic
If you buy garbage lemon HP printers, then you have to put up with the drama
of no updated drivers, product does not work as described and zero support
from the lemon company HP.
There are *NO* known printing issues with any version of Publisher, only...How do I preset data to auto copy to a certain page
I have a Macro that hides and copies visible cells to worksheet 3, but, I
have a certain row that needs to wait till the next page break befor copying
so that I don't have to manually adjust them. Moving them manually takes 25
minutes 2-3 times a day, if there is a way it would really save me.
...Disable Activate Product
I need to be able to disable the Activate Product option on the Help menu.
I have been able to do it with all of other office 2003 apps. I have tried
TCID1 = 5933 but it just won't work.
...Virtual Pages in Publisher
In Publisher 2003, how can I create virtual pages that when printed to
A4 printer will print four of these virtual pages to a sheet of A4?
...Finding unique items in data field for pivot tables
I have a huge pivot table I'm trying to create and for a critical item
I select I get the following message:
A field in your data source has more unique items that can be used in a
PivotTable. Microsoft Excel may not be able to create a PivotTable or
may create the PivotTable without the data from this field.
Any ideas how I can find the duplicates and create the PivotTable with
Based on the message, 'duplicates' is not your problem, *Unique* items is.
Pivot tables are limited to 32,500 unique items per field. So if you're
analyzing product sales, for...Excel data completely disappeared
Please can someone help me with a problem I am having.
I created a spreadsheet with Excel and included a 'comments' column
designed to appear with a mouseover.
I saved the spreadsheet and tested it out, everything ok ... until I
went to view it the next day and every single comment has disappeared
Even the red triangles have completely disappeared ... this is really
Can anyone throw any light on this ?
cool4cats's Profile: http://www.excelforum.com/member.php?actio...Second Public Folder store
I'd like to create a second public folder store on my Exch 2003 server. I am
running the Standard version, on Windows 2003 Standard server. I understand
that I cannot create a second Mailbox store. I tried successfully to create
the second Public store, but I don't know how to access it (either by
Outlook or Web Outlook). Can this be done?
Thank you for posting here!
In fact, an Exchange Standard server can only have one public folder store.
An Exchange Enterprise server can have up to 19 public folder stores. This
includes up to 4 mailbox stores and 1 public folder stor...Chart changing based on change in data source (number of rows/colu
As I see, the data range for charting is normally fixed. I have to produce
chart based on chaning rows and/or columns in data source table. Has anybody
got some suggestion for me?
Bal Ram Bhui -
For Excel charts in general, I suggest Jon Peltier's web site:
For dynamic charts, I suggest:
- Mike Middleton
Decision Analysis Add-ins for Excel
"Bal Ram Bhui, Jakarta" <Bal Ram Bhui, Jakarta@discussions.microsoft.com>
wrote in message news:DD0B5564-26B0-4...Business Cards VIEW SETTING- Mail Merge
I would like to print this view onto a lable paper for mailing. Ideas?
1. I have the company logos attached as pictures to the outlook card.
2. I want to print th pictures along with the addresses in a mail merge.
hope somebody has a suggestion.
...Public Folders #63
When I try to access public folders in the system manager in exchange 2003
w/sp2 installed it just hangs and never displays the folders. I have never
had this problem before at any of my other clients and was wondering if this
points to some deep rooted problem or is there just some minor fix I do to