Re: Mailmerging to trim a table
- From: "Doug Robbins - Word MVP" <dkr@xxxxxxxxxxxxxxxxxx>
- Date: Tue, 15 Jul 2008 09:30:43 +1000
Mail merge is probably not the best tool to use for this purpose. Just what
do you have in the Excel file?
--
Hope this helps.
Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.
Doug Robbins - Word MVP
"Walter Briscoe" <wbriscoe@xxxxxxxxxxxxxxxxxx> wrote in message
news:+2ACIwliw3eIFwee@xxxxxxxxxxxxxxxxxxxx
I have a questionnaire in a .doc which consists of a table:
A typical sequence of table rows is:
4.1 Were there toilets? Yes No goto 5.1
4.2 Were the toilets open? Yes No
4.3 Were the toilets clean? Yes No
5.1 Were there street lights? Yes No
I have a .xls data file which for our purposes can be considered to be
toilets
Yes
or
toilets
No
So, I start knowing the answer to 4.1.
If the answer is Yes, I want to highlight that answer in some fashion.
(With pen and paper, I would use a pen to circle the answer, bold would
satisfy my need when using printer and paper.)
If the answer is No, I want to highlight No and delete rows 4.2 and 4.3.
I could easily, if tediously, use if to empty those rows.
I want to make them vanish. So I would end up:
4.1 Were there toilets? No goto 5.1
5.1 Were there street lights? Yes No
Any suggestions as to how I might do this?
--
Walter Briscoe
.
- References:
- Mailmerging to trim a table
- From: Walter Briscoe
- Mailmerging to trim a table
- Prev by Date: Re: Word 2007 data base
- Next by Date: Re: Mailmerging to trim a table
- Previous by thread: Re: Mailmerging to trim a table
- Next by thread: Re: Mailmerging to trim a table
- Index(es):
Relevant Pages
|
