Quote:
Originally Posted by macropod
In the Mailmerge Tips and Tricks 'Sticky' thread at the top of this forum ( https://www.msofficeforums.com/mail-...ps-tricks.html) you'll find a macro under the heading Convert Text Representations of Fields to Working Fields that will convert either of the above into a working field code. |
I understand everything in your post until the macro... how do I insert the macro into the excel spreadsheet to change the coding of DISEASE and LABTEST1 from character to numeric 0,1 coding using the macro? Do I need to edit your macro to specify to convert only these variables? I am not understanding how to connect the excel spreadsheet to the macro & how to direct it to those specific variables. I am not familiar with macros at all so any further explanation/tips would be helpful.
Thank you!