PRINTING Disclosure Envelopes
The following takes you through the process, setp by step, of creating disclosure envelopes using the printer named IMPACT. Although all the directions are printed here the correct formatting of the Word document cannot be displayed here in HTML. I suggest you open the Word version of the instructions here to obtain the correct positioning of the text...
Save id, site
and treatment(text) in SAS saveset.
Convert SAS
saveset to Excel using SAS export wizard or DBMS copy.
Start Microsoft
Word.
Tools > Mail Merge
Create > Mailing Labels > Active
Window
Get Data > Open Data Source
Type=Excel
Select Excel File (From above.)
Entire Spreadsheet? Yes.
Setup main document (Set up format/size
of envelope/paper.)
Select DisclosureEnvelopes OR
Select Sticker 3114 > Details
Height=5.5
V-pitch=5.5
Number Down=2
Name Form: DisclosureEnvelopes (Once
saved, it will be available next time.)
Insert Variables (id, site, treatment.)
Edit > Mailing Label (Set font, height
margins…)
Select all
Font=New Times Roman
Height=14 (point size)
Set tab at 4.5 inches.
Page Setup
Header=0
Footer=0
P 2 per sheet
OK > Ignore error.
View > Print layout (To see vertical ruler.)
Now for the hard part. Enter and edit the text around the fields so
that it will line up with the envelope.
(See example below.) With
a point size of 14, you may have 2 header lines, 11 body lines and 3 footer
lines, skipping one line between each section.
FYI: The left top box is centered at 2¼ inches. The right top box is centered at 6¼ inches.
The top box is 1/3 inch to 1 ¼ inches down the side.
The footer box is 3.9 to 4.9 inches down the side and begins at
4 ½ inches from the left margin. Use
your rulers! They are very helpful.
Save this format!!
Tools > Mail Merge
Merge > Merge
(Check it out. If positioned properly, you should have all your disclosure envelopes
formated one on a page. You may
use this format again with any subset of data.)
File > Print
Select printer > Impact > OK.
DONE!
STUDY MEDICATION DISCLOSURE Site:
DO NOT OPEN, EXCEPT IN EMERGENCY <<SITE>>
The treatment assignmet for Study Subject <<CID>> is <<TREATMENT>>.
Please notify the Coordination and Data Center immediately at (716)275-7311 that study medication has been disclosed. Do NOT disclose the treatment assignment to the coordination center staff.
Disclosed By: ________________________
Date & Time: __ __/___ __/___ __ __ __:__ __
month day year (24hr clock)
Please return this form to:
Study Programmer
Department of Biostatistics, Box 630 Subject #: <<CID>>
University of Rochester Site #: <<SITE>>
Rochester, NY 14642
