View Single Post
  #2   Report Post  
Posted to microsoft.public.word.docmanagement
Robert M. Franz (RMF) Robert M. Franz (RMF) is offline
external usenet poster
 
Posts: 1,741
Default Merge from GoldMine into changing letter

Hello Bev

Bev wrote:
I am pulling an Excel file of names and addresses off of GoldMine. But when
merging into a letter the letter has to change according to Sales Rep. Can
Word change the part of the letter that would be the Signature, Sales Reps
name and contact info in addition to the customer name and address input?


how is Word/Excel supposed to know which Sales Rep belongs to each
customer? You either need to incorporate this information into Excel (or
preferably into GoldMine itself), or, say, each Sales Rep has open the
MailMerge template itself (then you can take this info from the User Name).

HTH
Robert
--
/"\ ASCII Ribbon Campaign | MSFT |
\ / | MVP | Scientific Reports
X Against HTML | for | with Word?
/ \ in e-mail & news | Word | http://www.masteringword.eu/