Automatic updates of a Publisher file

Is there a way to automatically populate data in a Publisher file?

My company has a catalog/price list that is based in Publisher. We issue 
this catalog to 3 different regions that all have different pricing. If there 
is a change to a description, a price, etc., I must manually update all three 
versions of the file. Is there a way that I can create a single Excel file 
with three different prices, that would automatically feed into Publisher? 
That way, I would only have to make the change in one place, but the changes 
would be seen in the Publisher document.

Thanks.

Mike
0
Utf
3/25/2010 7:14:01 PM
publisher 21446 articles. 3 followers. Follow

3 Replies
617 Views

Similar Articles

[PageSpeed] 15

If you edit the Excel data the Publisher file will change automatically as long 
the two are linked  together. When you open the Publisher file, the changes 
should be there.

-- 
Mary Sauer MVP
http://msauer.mvps.org/

"Mike F" <MikeF@discussions.microsoft.com> wrote in message 
news:1F1061F4-2008-4358-8677-02390261823D@microsoft.com...
> Is there a way to automatically populate data in a Publisher file?
>
> My company has a catalog/price list that is based in Publisher. We issue
> this catalog to 3 different regions that all have different pricing. If there
> is a change to a description, a price, etc., I must manually update all three
> versions of the file. Is there a way that I can create a single Excel file
> with three different prices, that would automatically feed into Publisher?
> That way, I would only have to make the change in one place, but the changes
> would be seen in the Publisher document.
>
> Thanks.
>
> Mike 


0
Mary
3/25/2010 10:28:58 PM
Thanks for the quick response. I don't think I was clear with what I am 
trying to do. I have a catalog now, that was made in Publisher. We want to 
distribute this catalog to the US, Canada, and some corporate accounts. 
However, each of these accounts gets different pricing. Is there a way for me 
to tell Publisher to use a specific price list to reflect the account that it 
was being distributed to?

Thanks for your help!
Mike



"Mary Sauer" wrote:

> If you edit the Excel data the Publisher file will change automatically as long 
> the two are linked  together. When you open the Publisher file, the changes 
> should be there.
> 
> -- 
> Mary Sauer MVP
> http://msauer.mvps.org/
> 
> "Mike F" <MikeF@discussions.microsoft.com> wrote in message 
> news:1F1061F4-2008-4358-8677-02390261823D@microsoft.com...
> > Is there a way to automatically populate data in a Publisher file?
> >
> > My company has a catalog/price list that is based in Publisher. We issue
> > this catalog to 3 different regions that all have different pricing. If there
> > is a change to a description, a price, etc., I must manually update all three
> > versions of the file. Is there a way that I can create a single Excel file
> > with three different prices, that would automatically feed into Publisher?
> > That way, I would only have to make the change in one place, but the changes
> > would be seen in the Publisher document.
> >
> > Thanks.
> >
> > Mike 
> 
> 
> .
> 
0
Utf
3/26/2010 2:43:02 PM
No easy way...   Can you not input the prices in three fields and only merge the 
relevant price in each catalog.

-- 
Mary Sauer MVP
http://msauer.mvps.org/

"Mike F" <MikeF@discussions.microsoft.com> wrote in message 
news:497D7439-7F32-4FBE-9F72-D4B9AC0C6DD3@microsoft.com...
> Thanks for the quick response. I don't think I was clear with what I am
> trying to do. I have a catalog now, that was made in Publisher. We want to
> distribute this catalog to the US, Canada, and some corporate accounts.
> However, each of these accounts gets different pricing. Is there a way for me
> to tell Publisher to use a specific price list to reflect the account that it
> was being distributed to?
>
> Thanks for your help!
> Mike
>
>
>
> "Mary Sauer" wrote:
>
>> If you edit the Excel data the Publisher file will change automatically as 
>> long
>> the two are linked  together. When you open the Publisher file, the changes
>> should be there.
>>
>> -- 
>> Mary Sauer MVP
>> http://msauer.mvps.org/
>>
>> "Mike F" <MikeF@discussions.microsoft.com> wrote in message
>> news:1F1061F4-2008-4358-8677-02390261823D@microsoft.com...
>> > Is there a way to automatically populate data in a Publisher file?
>> >
>> > My company has a catalog/price list that is based in Publisher. We issue
>> > this catalog to 3 different regions that all have different pricing. If 
>> > there
>> > is a change to a description, a price, etc., I must manually update all 
>> > three
>> > versions of the file. Is there a way that I can create a single Excel file
>> > with three different prices, that would automatically feed into Publisher?
>> > That way, I would only have to make the change in one place, but the 
>> > changes
>> > would be seen in the Publisher document.
>> >
>> > Thanks.
>> >
>> > Mike
>>
>>
>> .
>> 


0
Mary
3/26/2010 6:26:32 PM
Reply:

Similar Artilces:

Exchange 2000 SP3 updates ans security patches
I have Exchange 2000 Version 6.0 (Build 6249.4: Service Pack 3) running on Windows 2000 Server SP4. What is the best way of checking for missing security patches and updates? Would it be enough if I run MBSA 2.0 and rely on it only? MBSA is not showing any patches/updates missing however the above build number seems to me a lillte old comparing to those I saw when researching the web about Exchange 2000. Does the updates not change the build number? Thank you. "mtler" <mtler@discussions.microsoft.com> wrote: >I have Exchange 2000 Version 6.0 (Build 6249.4: Service Pa...

A program is trying to automatically send e-mail on your behalf.
I tried posting this in microsoft.public.outlook.general, but no nibbles. ------------------------------------------------------------------------------------------------------ Does anybody know how to turn the "A program is trying to automatically send e-mail on your behalf." prompte off? It pops when one of my MS Access apps is emailing one of it's reports to somebody. It happens on the Citrix server that one of my MS Apps is running on, but it does not happen when the app is running on my own PC. Consequently I'm hoping for some user-configurable setting that controls...

Latest xp update causing Money to crash????
Ever since I installed the latest XP updates, Money 2005 keeps crashing on me. Anyone else experiencing this problem???? No issue here. Have you tried to restore to a point previous to the update? "JRB" <JRB@discussions.microsoft.com> wrote in message news:219988AA-0980-4055-A772-835E45B9DB3F@microsoft.com... > Ever since I installed the latest XP updates, Money 2005 keeps crashing on > me. Anyone else experiencing this problem???? XP: eXtra Pain arthur == On Wed, 22 Mar 2006 09:40:27 -0800, JRB <JRB@discussions.microsoft.com> wrote: >Ev...

Leopard 10.5.2 combo updater released!
This might help with a lot of the problems Office 2008 users are experiencing. Get this combo updater rather than using Software Updater to download. A combo updater will go back and rewrite files that could be corrupted. Software Updates are incremental updates. Mac OS X 10.5.2 Combo Update: 343 MB <http://www.apple.com/support/downloads/macosx1052comboupdate.html> More on types of update file: <http://www.entourage.mvps.org/troubleshoot/combo.html> -- Diane, Microsoft Mac MVP (MVPs are not Microsoft Employees) Entourage Help Page <http://www.entourage.mvps.org/> Ent...

how to convert .doc file to .jpg file
I want to use COM to convert WORD file (.doc) to a series of graphics files, such as .jpg file. Each page in WORD file should be one graphics file. How can I do it? Thanks! Check this out: http://www.virtualsoftware.com/ProdPage.cfm?ProdID=1272 -- Elias http://lgwm.org/ "fadics" <fadics@sohu.com> wrote in message news:bjm320$2q99$1@mail.cn99.com... > I want to use COM to convert WORD file (.doc) to a series of graphics files, > such as .jpg file. Each page in WORD file should be one graphics file. How > can I do it? > > Thanks! > > Thank you. Perha...

Automatic CC
Hello, Is there any way to create a template where a contact is automatically CC in the email. So I dont forget to cc them every time I send an email. Thanks ...

64 bit language pack and 64 bit cumulative update of december 2009
I want Project Server 2007 64 bits language pack. but i cant find this . In net there is language pack of project server 2007. but there is no define 64 bits. I need 64 bit language pack for 64 bits project server 2007 . and also I need cumulative update (december 2009) of 64 bit project server 2007 and windows sharepoint services 3.0 (64 bit) kindly tell me the correct link from where i will download. ...

Instances doesn't get updated when the master stencil changes
Hi, I am trying to create a stencil master shape in such way that when I change the master, all instances also get updated according to the new master shape. At this point I have a master shape in a stencil and I have hundreds of instances in different visio drawing based on the very same stencil. When I change the master shape, I have to change all instances (several hundreds) and this is such a pain. How can I solve this problem? Any help would be appreciated, Max On Tue, 17 Oct 2006 09:29:15 -0400, "Maxwell2006" <alanalan@newsgroup.nospam> wrote: >Hi, > &...

Money 2006 constantly faults with automatic updates
Whenever I use the Internet automatic updates, money faults out and wants to send a report to Microsoft. Also my account list shows most accounts with a status of 'Update In Progress' I've done a complete reinstall after removing it and power cycling my machine. I thought it may have been something with removing 2004 and installing 2006, but got same problem Has anyone else been having this problem? I really just want to go back to Money 2004. What's the error message? -- Glyn Simpson, Microsoft MVP - Money http://money.mvps.org Check http://money.mvps.org/faq f...

When start Outlook, it doesn't prompt for the password for PST file.
How to get the "Password for Personal Folder Dialog Box" to appear when Outlook starts. ...

Automatic axis format
Hi, I'm need to make a automatic axis format within excel. The number of rows is depending of a imported file. No problem to get the max. number of rows. But to put this number into the chart ( category axis) is more problematic. I try VB but my knowledge is at dummy level ! Waiting for your reply............. Hi, Have a look at Jon's examples of dynamic charts. http://peltiertech.com/Excel/Charts/Dynamics.html Cheers Andy jos wrote: > Hi, > I'm need to make a automatic axis format within excel. > The number of rows is depending of a imported file. > No problem to g...

Publisher Crashes #3
Publisher 2000 crashes when saving changes? -- Ralph Not on my system. More information would be nice.. "Ralph Copclose" <RalphCopclose@discussions.microsoft.com> wrote in message news:0F056906-5EAF-477C-9A11-1EC4D1EE2CC1@microsoft.com... > Publisher 2000 crashes when saving changes? > -- > Ralph Thanks for reply - my system is Vista business. When making more than one change to an existing document and attempting to save - publisher closes and gives me a message 'Publisher 2000 version 6.0 has stopped working' The original document was produced o...

How do I get an automatic equal sign to begin the formula bar?
How do I get an automatic equal sign to appear in the formula bar in Excel for Microsoft 2003? This happened for me in the 2000 version and I could just click on it with my mouse pointer, but now all that appears is the function sign with no equal sign after it. It makes my job a lot more time consuming to have to type in the equal sign while building formulas. Please help, anybody? The = icon disappeared in newer versions of excel (xl2002???). You can add an = icon Tools|customize|commands tab|Insert category (Scroll down the list until you find the = icon) And drag it to your fav...

Windows update problem. Clueless
Here is my windowsupdate.log for today, I cannot connect to windowsupdate website period. Not sure what is going on. Can someone help me decode this nonsense? 2010-05-25 17:20:51:671 1484 b98 AU ############# 2010-05-25 17:20:51:671 1484 b98 AU ## START ## AU: Search for updates 2010-05-25 17:20:51:671 1484 678 DnldMgr *********** DnldMgr: Regulation Refresh [Svc: {9482F4B4-E343-43B6-B170-9A65BC822C77}] *********** 2010-05-25 17:20:51:671 1484 678 DnldMgr Contacting regulation server for 20 updates. 2010-05-25 17:20:51:671 1484 b98 AU ######### 2010-05-25 17:20:51:687 1484 ...

Excel File Opening Via Hyperlink
What do I need to do within an Excel document to have it open in print preview mode when the Intranet link to this file is clicked? Thank you. Put this one line Macro in the ThisWorkbook code area: Private Sub Workbook_Open() ActiveWindow.SelectedSheets.PrintPreview End Sub -- Gary''s Student - gsnu200723 ...

My worksheet automatically adds a fill color when I enter text.
When I type text in a blank cell, the cell automatically is highlightes with the bright yellow fill. There is no conditional formatting on this workbook. Check your VBA editor. You might have an Event Macro which does what, usually, a CF does. Try to Increase the Macro Security to its maximum level in order to eliminate the Event Macro from running... You may, also consider to "rem" all the Macro commands by adding a Preceding apostrophe to each command. Micky > When I type text in a blank cell, the cell automatically is highlightes with > the bright yello...

how do i delete a (read only) file?
i am trying to delete some files that are (READ ONLY) anyone have a clue as to how? i am in microsoft excel. Open windows explorer. go to that folder right click on the file to delete select "delete" answer yes to the "are you sure prompt" (somethings don't need to be done in Excel.) Renee wrote: > > i am trying to delete some files that are (READ ONLY) anyone have a clue as > to how? i am in microsoft excel. -- Dave Peterson ...

Update global address book not working!
Hello, I've noticed that users I've setup over the last two days aren't appearing in the global address book in people's outlook but you can see them in the All Users Address book. Can someone inform me how to update this so the user is visable in the global address book. Thanks If you're running Outlook 2003 cached mode you're working off the offline address book, so start looking there. -- Ed Crowley MVP - Exchange "Protecting the world from PSTs and brick backups!" "John D" <anonymous@discussions.microsoft.com> wrote in message new...

I open the MDB, the form runs automatically
Simple question I have an MDB file with 20 files and 7 forms in it. When I open it up, the form runs immediately an access goes into some sort of protected mode. I can't view the tables, queries etc. I can see the code by pressing Alt F11 but not the data. I created a blank db and imported the mdb so I could see the tables. But how do I open the original without it running the code? When I look at the code. I don't see anything that sets properties or invokes the code automatically. There are no macros in this, just the forms and associated code with them. Any ideas Thanks Colm ...

Automatic updates, automatically disabling itself
Automatic updates, automatically disabling itself. 2nd day now onecare popped up to tell me the updates turned themselves = off. I'm thinking what malware would want to turn the updates off ? Any idea what's going on here ? Did I AUTOMATICALLY install an update = that caused this ? <keepout@yahoo.com.invalid> wrote in message news:8l7mi5tkgp1gd15fkef71ll5mrui9ukmht@4ax.com... > Automatic updates, automatically disabling itself. > > 2nd day now onecare popped up to tell me the updates turned themselves > off. Drop OneCare and install Microsoft Sec...

How to add a 2nd page to an online email newsletter in Publisher?
I have inserted a 2nd page to my online email newsletter in publisher but when I view it by either the preview or sending it to my self I cannot get to the second page!! Can someone tell me what I am doing wrong and how to fix this please. This is for my small business and I am trying to have this ready for a June 1 release. Thank you. I think the only way of getting additional story to your email is make a Publisher page twice as long (22"). Creating a multi-page PDF file may be more appreciated by your readers for it is a nicer file to save, and print out. -- Don Vancouver, ...

Having numbers automatically appear bold
Hi all, Had such great advise last time, thought I'd try again. I have a large range of cells where I will be inputing sales figures i the form of currency revenue. The range is about G-I and 1-400. Th sales data will be a comparisson of YTD 2001 - 2004 revenue results. What I hope to do is have any figure that is above $30,000 appea automatically in bold so as to stand out as a good client. I gues there is something in the IF function to do this but I'm stumped. Any ideas? Thanks again in advance. Saxte -- Message posted from http://www.ExcelForum.com select the range you wa...

Converting .123 file to Excel
Hi there, Please help. How to convert a .123 file to Excel 2000? Thank you. Cheers, Ming Hi Ming! If they are .123 files you need to use Lotus to open them and then save them as .wk4 files which can then be opened by Excel 2000 -- Regards Norman Harker MVP (Excel) Sydney, Australia njharker@optusnet.com.au Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. "Ming" <mewong2000@yahoo.com> wrote in message news:08ab01c3c575$ff5d5ca0$a101280a@phx.gbl... > Hi there, > > Please help. How to convert a .123 file to Excel...

Local Software Update service for Office 2004?
Is it possible to run a local software update server for Microsoft Office on my LAN? With my Xserves, I am using Software Update Service for Apple updates, but can't figure out if there is a way to run a local software update service without using my Internet connection. I can get it from the central servers fine, but was wondering if I could run a local server to manage the Office Updates and monitor the update levels per station. Phillip Remaker wrote: > Is it possible to run a local software update server for Microsoft > Office on my LAN? > > With my Xserves, I am using...

Is it possible to automatically move data entered in columns into rows?
Is it possible to automatically move data entered in columns into rows? It seems like a simple thing to do but I can't find a function anywhere. Cheers, Richard Thorneycroft Husky Products If you enter something in ONE cell it is automatically in a row and a column. So, perhaps a bit more explanation is in order. -- Don Guillett SalesAid Software donaldb@281.com "Richard Thorneycroft" <dancecommander81@hotmail.com> wrote in message news:9e2f3f75.0411160750.7003c6ab@posting.google.com... > Is it possible to automatically move data entered in columns into rows? >...