I'm currently looking at creating an automated field entry for reports at my company, extracting the data from an excel file. What I want, is to enter a job number, and it to automatically fill in the title field, author field, and client field from the job number. Essentially it's a lookup from word to excel.



I know that mail merge is a way of linking excel data through to word, but I haven't been able to find a way to have a specific entry to go through as opposed to the entire data field.


If anybody can give me any help on this it would be fantastic.

hi hustafus,

With the mailmerge, you can use record filtering to output only the records you select.

Alternatively, you could combine a SKIPIF filed with a FILLIN field, along the lines of:
{SKIPIF {MERGEREC} <> {FILLIN "Record # to merge" \o}}
or
{SKIPIF{=({MERGEREC}< {FILLIN "First Record #" \d 1 \o})+({MERGEREC}> {FILLIN "Last Record #" \d 999 \o})}= 1}

Note: The field braces (ie '{}') are created via Ctrl-F9 - you can type them or copy them from this post.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]