View Single Post
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
BlairH BlairH is offline
external usenet poster
 
Posts: 1
Default Mail Merge from Excel with Calculations

I have a mail merge document that was created i Word 97 / Excel 97. The Excel
sheet has calculations to set a field to next Friday's date. The Word
document then prints the mail merge list using this date.

This worked great in Office 97.

Now in Office 2003, the calculation doesn't update when Word merge the Excel
list.

Any ideas how to fix this? Currently I open the Excel sheet first to allow
the fields to update, then the Word mail marge document.

Thanks!