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. 
0
8/27/2006 9:58:01 PM
publisher 21446 articles. 6 followers. Follow

3 Replies
516 Views

Similar Articles

[PageSpeed] 38

What version Publisher?
If you have 2003 use the catalog merge for your directory.
http://office.microsoft.com/en-us/assistance/CH010504381033.aspx

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 below).

-- 
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com
http://officebeta.iponet.net/en-us/publisher/FX100649111033.aspx

"vazastokes" <vazastokes@discussions.microsoft.com> wrote in message 
news:08412967-DE4E-4B6B-9861-276EDFB04887@microsoft.com...
>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. 


0
mary-sauer (6480)
8/28/2006 7:58:23 AM
Thanks so much for replying. This is my first time with a project like this 
in publisher. I am using 2003 version and have been able to set it up using 
the catalog merge and it works except for the printing. I made a template 
with "Name, address, phone, childrens names" and copied it down the page and 
on a second column and down. Then I merged the Excel document with it. It 
looks like only one page. I can't scroll to see another page or see another 
page in print preview but when I print it wants to print 18 pages. 
I noticed in the corner if I hold the cursor, it says "Catalog merge area, 
this area will repeat 1 down x 1 across. I'm sure this has something to do 
with it, but it doesn't make any sense why I don't see the multiple pages.
Any suggestions? Thanks!

"Mary Sauer" wrote:

> What version Publisher?
> If you have 2003 use the catalog merge for your directory.
> http://office.microsoft.com/en-us/assistance/CH010504381033.aspx
> 
> 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 below).
> 
> -- 
> Mary Sauer MSFT MVP
> http://office.microsoft.com/
> http://msauer.mvps.org/
> news://msnews.microsoft.com
> http://officebeta.iponet.net/en-us/publisher/FX100649111033.aspx
> 
> "vazastokes" <vazastokes@discussions.microsoft.com> wrote in message 
> news:08412967-DE4E-4B6B-9861-276EDFB04887@microsoft.com...
> >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. 
> 
> 
> 
0
8/28/2006 12:23:02 PM
When you do any kind of merge you can only have one entry on your screen.

The catalog merge will default to a certain size, when you resize this area the 
dialogue will say how many across and how many down. If you want your directory 
in alphabetical order then you need to keep to one across. Publisher merges 
names across rather than up and down.

The article reference in the previous post can help, there is a training video 
here
http://office.microsoft.com/training/training.aspx?AssetID=RC010779101033

-- 
Mary Sauer MSFT MVP
http://office.microsoft.com/
http://msauer.mvps.org/
news://msnews.microsoft.com
http://officebeta.iponet.net/en-us/publisher/FX100649111033.aspx

"vazastokes" <vazastokes@discussions.microsoft.com> wrote in message 
news:1C40F388-E132-4274-987F-EA1935F05633@microsoft.com...
> Thanks so much for replying. This is my first time with a project like this
> in publisher. I am using 2003 version and have been able to set it up using
> the catalog merge and it works except for the printing. I made a template
> with "Name, address, phone, childrens names" and copied it down the page and
> on a second column and down. Then I merged the Excel document with it. It
> looks like only one page. I can't scroll to see another page or see another
> page in print preview but when I print it wants to print 18 pages.
> I noticed in the corner if I hold the cursor, it says "Catalog merge area,
> this area will repeat 1 down x 1 across. I'm sure this has something to do
> with it, but it doesn't make any sense why I don't see the multiple pages.
> Any suggestions? Thanks!
>
> "Mary Sauer" wrote:
>
>> What version Publisher?
>> If you have 2003 use the catalog merge for your directory.
>> http://office.microsoft.com/en-us/assistance/CH010504381033.aspx
>>
>> 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 below).
>>
>> -- 
>> Mary Sauer MSFT MVP
>> http://office.microsoft.com/
>> http://msauer.mvps.org/
>> news://msnews.microsoft.com
>> http://officebeta.iponet.net/en-us/publisher/FX100649111033.aspx
>>
>> "vazastokes" <vazastokes@discussions.microsoft.com> wrote in message
>> news:08412967-DE4E-4B6B-9861-276EDFB04887@microsoft.com...
>> >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.
>>
>>
>> 


0
mary-sauer (6480)
8/28/2006 1:01:09 PM
Reply:

Similar Artilces:

Create a new folderand name it the previous month
HI All, I would like help with the following: I would like to create a folder with the name of the current month less one. Next, I would like to Save As the active file I’m working on with the name Audit Report for current month less one. I would like to save this audit report in the folder I just created above. The code I’m trying to use is below. I think my problems are with the items in blue MkDir "\\NS-WARQVFS01\Audit\MonthlyReport\" & Format(((Now) - 1), "mmm_yy") ActiveWorkbook.SaveCopyAs Filename:="\\NS-WARQVFS01\Audit\MonthlyReport\F...

P2P using vc++
Hi. I want to create a p2p software for file sharing(upload and download) in vc++ 2005. Anyone having any idea as to where to start or if there are libraries/APIs/SDKs available for it. I would really appreciate any help and/or pointers. Rahul ...

cannot use reading pane !!!
In Outlook 2003, I cannot use the Reading pane. The reading pane option is grayed out. I tried to rename the views.dat but still it did not help. Please help !!! Answered in the outlook.general newsgroup. Do NOT multipost! -- Roady [MVP] www.howto-outlook.com Tips of the month: -Creating Signatures -Create an Office XP CD slipstreamed with Service Pack 3 ----- "A" <meetsudhar@hotmail.com> wrote in message news:%23PrNZDPREHA.1644@TK2MSFTNGP09.phx.gbl... > In Outlook 2003, I cannot use the Reading pane. > > The reading pane option is grayed out. I tried to rena...

Subjects, examples of real-world use.
I was wondering if anybody would like to share how they are using Subjects in CRM. I am trying to decide if you are better with a flat list of basic subjects or a nested list of highly granular subjects. Interested in what others are doing, what has worked, what has not. Thanks in advance, Mike There is no right way or wrong way however I would not usually use a one level subject list. Might help if you could describe your particular scenario ======================= John O'Donnell Microsoft CRM MVP http://codegallery.gotdotnet.com/crm "Mike Morisoli" <mi...

creating hierarchy charts
Is there a way to create a hierarchy chart in Visio through a pre-defined layout or does it have to be done manually by using the drawing tool to create the connection lines and using the process shape from the basic flowchart template? I think you have to do it manually, but there is one shortcut that might help. Activate the Connector Tool and then drag out the shapes from the template. A connector is automatically added. Visio connects the new shape to the shape currently selected in the drawing, so be sure to select the correct shape before dragging out a new one. For an even bet...

Calculating time using minutes.
I have created an invoice to record the minutes I work on a job but can not figure out how to sum the total time I want the minutes in the format hours and half hours, ie 1.5 hours. Can some one tell me how to do this. Thank you. How are the times being entered into the invoice? In what format? As ordinary text? Into FormFields? -- Hope this helps. Please reply to the newsgroup unless you wish to avail yourself of my services on a paid consulting basis. Doug Robbins - Word MVP, originally posted via msnews.microsoft.com "computerkiller" <computerkiller@di...

What do you use or recommend to backup databases such as in RMS?
I'm looking for recommendations on a good backup system. Thanks! We backup to a flash drive that can be taken home. We used to backup to CD. you really dont need a huge backup system for a single store. ============== "Mary" <Mary@discussions.microsoft.com> wrote in message news:11348AC4-5C80-4D3D-B46B-4594950066FD@microsoft.com... > I'm looking for recommendations on a good backup system. Thanks! I'm not that computer literate. How many gigs do you think I'll need? "Maurice @ ARS" wrote: > We backup to a flash drive that can be t...

Solution to "You might not have permission to use this network resource" on xp
After a lot of attempts I finally found a solution that worked for me to solve this error message that appears when you try to access another pc or laptop on your mixed xp home / xp pro home network. There were a lot of solutions on all kinds of sites including this one, but none of them worked for me except the steps below. Hope this helps someone out! 1) Open Network Connections 2) Right click the wired or wireless connection you use to access the internet (for example, I use "Wireless Network Connection") 3) Select "Properties" 4) ...

How do I install Publisher from an office XP pack? or is it part of Word?
I have a laptop installed with office XP, I want to use Publisher which i can't find on my laptop, I tried to install it from my CD but didn't manage. Is Publisher part of word, so i can use it from word? Or Do i access Publisher like a seprate software? How can i install it from my Office XP CD pack? Publisher is not part of Office XP generally. If you have the Small Business then it is on disk 2, otherwise you will have to purchase it separately. -- Mary Sauer MS MVP http://office.microsoft.com/clipart/ http://www.mvps.org/msauer/getting_started.htm For better access to Microsoft...

How do I design a label template?
I need to design a template in Publisher for round labels. I have downloaded the template from a web site in Word, but would like to use it in Publisher. What size? The setup for 2.5 labels are Side margin .25, top margin .5, Horizontal gap .25, vertical gap zero This will result in 3 columns and 4 rows Avery 5294 -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "PegGall" <PegGall@discussions.microsoft.com> wrote in message news:D68BDD7B-CD5E-4E7A-BDD5-EB2498CB4B5A@microsoft.com... >I need to design a template in P...

How to create SQL Connection to other database from call out ?
Hi I am trying to update another legacy MS SQL database after user insert new record in MS CRM system. The way i did is at call out postcreate , i code by VS 2003. The coding is starting from setting a connectionsstring to connect another database which it is in same server as MS CRM Server, but different database name and insert SQL command. The result is, my call out can't open database connection at all. I tested that inserting new record in my local machine with testing web form application, it is correct sql command and can connect to that datbase and insert new reccord. Fro...

Publisher 2003 Picture Frame Displays Dashed border & Center X
About 2 weeks ago I found none of my Publisher documents would display the photos or graphics. All the Picture Frames display dashed borders and big dashed "x's" in the block. I've tried everything and upgraded to Publisher 2003 today. Still displaying same thing. What's set differently that none of my documents will display pictures? - Realtor in Need!!!!! Hi F.E.Baumbach (fran40@earthlink.net), in the Microsoft� newsgroups you posted: || About 2 weeks ago I found none of my Publisher documents || would display the photos or graphics. All the Picture || Frames ...

Inserting picture from file in Publisher 2000
I installed a trial Pub 2007 and when it ran its course I uninstalled it and reinstalled Publisher 2000. Since doing this I cannot insert a picture other than clipart, ie. I can't insert a picture from my files or internet. I get a message saying Pub doesn't recognise the format or there was an error loading a graphic converter. Some of the graphics converters may be missing. Run setup again. Well I've tried the 'repair' from setup again but still no joy. Can anybody help? I'm not too good with these problems so can you keep it simple for me? -- Ruth The graph...

Launch Email Template
Hi All, I have an equipment reservation database. We are required to send an email confirmation when we make a reservation. Right now, I have an email template that is launched when the user clicks on a custom button in Outlook. It works. What I would like to do is have the email automatically generated with the fields (user name - lookup in global address list, checkout date and expected return date) completed in the email. Is there a way to utilize the already created template in Outlook and pass the fields to the template? Would it be better to recreate the email in th...

Using html newsletter
Hi.. Do somebody know if there is a guide how to use publisher as a html newsletter creator?.. ...

How do I create a formula that displays the tab name in Excel?
See Bob's site http://www.xldynamic.com/source/xld.xlFAQ0002.html -- Regards Ron de Bruin http://www.rondebruin.nl "fazeez01" <fazeez01@discussions.microsoft.com> wrote in message news:2A4DF27F-2BDE-4DE9-8B34-55CA583D36B3@microsoft.com... > You'll need this Excel add-in: http://xcell05.free.fr/downloads/Morefunc.zip After you install it, just use the SHEETNAME() function. Example: =SHEETNAME(1) would call the first tab in your workbook. Hope this helps. -- AlexJ ------------------------------------------------------------------------ AlexJ's Pro...

Disable macros in template d/l from MS?
We use a Sales Order template d/led from MS many years ago. I now need to use the same template, but without the macros. Unfortuantely, when I try to remove the macros from a copy of this template, I find they are password protected. Does anyone know how to get rid of them? Thanks Ferret Try "chzdood"(no quotes) Gord On Tue, 8 Feb 2005 10:29:08 -0800, Ferret Daddy <Ferret Daddy@discussions.microsoft.com> wrote: >We use a Sales Order template d/led from MS many years ago. I now need to >use the same template, but without the macros. Unfortuantely, when I tr...

choosing which address to reply from using Rules Wizard
How do I choose which email address / account Rules Wizard uses to send a reply or forward from? Rules will automatically use the default account. It is not configurable for sending from different accounts. (Note - in the future, please post your version of Outlook). --� Milly Staples [MVP - Outlook] Post all replies to the group to keep the discussion intact. Due to the (insert latest virus name here) virus, all mail sent to my personal account will be deleted without reading. After searching google.groups.com and finding no answer, Howard asked: | How do I choose which email addres...

Door hanger template
Does anyone have a template for a door hanger? Some here http://www.microsoft.com/canada/home/templategallery/default.asp I have a PDF on my web page. http://msauer.mvps.org/graphics.htm -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "jsjacobson1" <jsjacobson1@discussions.microsoft.com> wrote in message news:0B9CC1B0-753F-4665-A352-04468660A7E3@microsoft.com... > Does anyone have a template for a door hanger? ...

Where do I ask questions about using Microsoft Visual C++ 2005 Express Edition?
What newsgroup or forum can I post questions about using Microsoft Visual C++ 2005 Express Edition, which I'm new to? I want to ask how can I get it to use the char versions of functions, like CreateFileA instead of CreateFileW, which it is currently using by default and complaining about because I'm not passing it a wide char string for the filename. Or, how do I convert an ASCII string passed to me to a wide character string to pass to CreateFileW? And how can I get it to give me a compile listing that shows if it ultimately used the ...W or the ...A version of a function? (And an...

Using Powerpoint 97 and 2003
At present I use PowerPoint 2003 but this means that some cannot open the presentation, converting to 97-later & 95 creats very large files, can I have both 97 & 2003 on my PC? People with 97 should be able to open 2003 files (though some animations will not work as expected) Unless you know people with 95 you should never have to save in the 97-2003, 95 format -- john ATSIGN PPTAlchemy.co.uk Free PPT Hints, Tips and Tutorials http://www.pptalchemy.co.uk/powerpoint_hints_and_tips_tutorials.html "albyefield" wrote: > At present I use PowerPo...

how to create modaless dialog box.
Hi guys, can you please tell me how we can create modaless dialog box so that we can perform task on both the dialog box parent as well as child. raghunandan_1081@yahoo.com wrote: > Hi guys, can you please tell me how we can create modaless dialog box > so that we can perform task on both the dialog box parent as well as > child. > Create the dialog template, Create a CDialog-derived class for it, then call the Create member function of the dialog. Look up CDialog in the help - it has instructions. -- Scott McPhillips [VC++ MVP] This is from an older version of Visual St...

Can I use drop down boxes in pocket excel?
I was thinking about getting a pocket PC that would help me with a project. Using drop down boxes on my desk top PC works great, so I was wondering if the pocket version was capable of doing the same thing. ...

How do I set up a custom template to print on 11X17 paper
I cant seem to find a way to make my own tri folding invitations. Finished product needs to be printed on 11X17 paper. Any one I seem to try ends up printing on 4 seperate sheets of paper. Setup your printer for 11x17, landscape, you have to do this first. In page setup, click custom. The built in templates for Publisher will not default to this size, you will manually have to adjust the content if you use a template. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com http://officebeta.iponet.net/en-us/publisher/FX100649111033.aspx...

How do you open a template at startup?
I have been asked if you can start up a template on automatically opening the Excel program when someone starts the computer. I can get Excel to open but I can not get the template to open automatically. How can I do this? I have tried to put the template in the XLStart folder under the program file\office on the local drive and even in the startup folder. Neither worked and one opened then closed Excel. One more thing worth mentioning. This template is on a network drive. I tried placing the template file on the local and network drive but neither opened it when put into the sta...