All, using access 2010. I am working with an existing database that have a letter programmed using fields in a query. I have to add to it but having a trouble. Merge in Word was not used. I can't find any examples. Can someone help me out? The letter is designed in a report design. Using the fields from a query and filtered by "IIF Statements". Does anyone have any insight in something like this that can guide me? Thank you
create letter
- Thread starter slimjen1
- Start date
apr pillai
AWF VIP
- Local time
- Today, 23:11
- Joined
- Jan 20, 2005
- Messages
- 737
Last edited:
Thank you for replying. That's just it; it was not done with mail merge. I can change all that but it will take some time. I am reconstructing the database. But for now; I just have to insert a paragraph of code for it to work now. An ex of the code is:
I don't know how to add lines to this already contructed letter. Like where the &""& need to be, etc. Also when I add the "IIF statement" when the lines are need. When I try to add the lines, I get errors like "wrong number of arguments"
Code:
=[line]&””&[Co_Num}&”merged with “&IIF([cust_name]=”Oster”,your company taxes are due”,”the first of the year”)&[line1]&””&Format([capitol],”Percent”)&”,justified”&IIF([taxes]>=0,”n inflate”,”deflate capital”)&IIF([cust_name]=”Oster”,”last year”.”The [monthly”)&[line3]&””&.I don't know how to add lines to this already contructed letter. Like where the &""& need to be, etc. Also when I add the "IIF statement" when the lines are need. When I try to add the lines, I get errors like "wrong number of arguments"
What is sounds like is that you have a database which contains values as to what the contents of the letters will be. [line] [Co_num] etc. are all fields in your db. As you can see, when the customer name is Oster you do some special stuff as to the contents of the letter.
Can you provide list of field?
Can you provide list of field?
