Guide to distribute T2200S by manually adding macro.
For those of you who prefer not to use macro enabled workbook. Here is a guide how you can download the template and manually add the scripts to distribute T2200S forms.
Instructions
Download the template excel file T2200S Template.
Open it and add signature as described in this post steps 2 &3
Open visual basic editor by pressing Alt-F11
Add the module and insert the Source Code into the module.
The module contains three macros. You will now need to assign them to buttons on “Data” tab. For orange button use T2200StoPDFTest for green button use T2200StoPDFandSend for yellow button use T2200StoPDFOnly
Before you run any macro, please save and close all other open workbooks and emails. Make sure Outlook is running.
Run a test, on “Data” tab click on orange button “Preview for first 3 entries without sending”. This will create three emails and open them in outlook for you to preview without sending.
Run the macro you need to send or produce PDFs files. The bottom left corner of your excel window will show you the progress.