Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
inserting an Excel spreadsheet into Word - how to remove gridl | Tables | |||
Difficulty pasting Excel data into Word table only in XP versions | Tables | |||
Mail Merge Issue With Office 97 - Excel Data Source | Mailmerge | |||
Excel worksheet in Word linked text boxes | Page Layout | |||
Word Field Codes in Excel data file | Mailmerge |