Control Group Question

  • Thread starter Thread starter KarenMike
  • Start date Start date
K

KarenMike

I have a table that contains member address and I have a table using
recipient addess. These tables are linked via member number. I currently have
the database linked to a mail merge in word. I have set up an option button
in my form and asks which address I want my letter to be sent. Would I then
set up a query to link to my mail merge and if 1 use member information and
if 2 use recipient information? I am a novice when it comes to writing code,
so any help on the code or any better option would be of great help
 
Im not experienced at mail merges, but it seems like you are. The only thing
I can think is to create a text box, you can even turn off it's visibility...
but use that text box with an IIF statement as it's control source... i.e.
IIF(optiongroup=1,textbox1,textbox2)

Then just link the mail merge to that dummy text box.
 
Back
Top