View Single Post
  #1   Report Post  
windowed
 
Posts: n/a
Default enter an excel module global variable value in a mailmerge letter

I'm working on a Word 2002 mail merge that's based on an Excel 2002
spreadsheet that's based on an underlying Acess97 DB. This is for a
quarterly billing letter to donors.

When the spreadsheet opens, a dialog box opens requesting information,
including numbers of houses billed this quarter and YTD. These are stored
in global variables in an excell VBA module (e.g., intNumHsBilldYTD).

In the letter, which has a complex if...then...else, I need to insert the
numbers in some but not all of the merged letters, depending on which
"if" condition is met. My question is, how do I reference it in the
mailmerge form to print the values in the letters?