A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Powerpoint, Publisher and Visio » Publisher
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Automatic updates of a Publisher file



 
 
Thread Tools Display Modes
  #1  
Old March 25th, 2010, 08:14 PM posted to microsoft.public.publisher
Mike F
external usenet poster
 
Posts: 21
Default 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
  #2  
Old March 25th, 2010, 11:28 PM posted to microsoft.public.publisher
Mary Sauer[_3_]
external usenet poster
 
Posts: 3,082
Default Automatic updates of a Publisher file

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" wrote in message
...
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



  #3  
Old March 26th, 2010, 03:43 PM posted to microsoft.public.publisher
Mike F
external usenet poster
 
Posts: 21
Default Automatic updates of a Publisher file

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" wrote in message
...
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



.

  #4  
Old March 26th, 2010, 07:26 PM posted to microsoft.public.publisher
Mary Sauer[_3_]
external usenet poster
 
Posts: 3,082
Default Automatic updates of a Publisher file

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" wrote in message
...
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" wrote in message
...
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



.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 02:32 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.