#1
|
|||
|
|||
Mail Merge Auto Fill
I'm trying to find out how to do a mail merge thats a bit more complicated then a normal mail merge and was wondering if someone could point me in the right direction/provide me with the correct search term.
I want to be able to enter in a reference number and have the rest of the information auto fill in my form that pulls from Access. I was thinking that Id just want to do a Mail merge but I dont know if theres a better way. |
#2
|
||||
|
||||
Once you've set up your mailmerge main document with all the merge fields you'll need, insert a SKIPIF field coded along the lines of:
{SKIPIF{MERGEFIELD Reference}<> {FILLIN "What is the reference number to use?" \o}} Note: The field brace pairs (i.e. '{ }') for the above example are all created in the document itself, via Ctrl-F9 (Cmd-F9 on a Mac); you can't simply type them or copy & paste them from this message. Nor is it practicable to add them via any of the standard Word dialogues.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Excel Auto-fill Issues | officeboy09 | Excel | 8 | 01-14-2014 05:52 PM |
Mail Merge to label L7165X, record can't auto page to next 8 records | stevencheng | Mail Merge | 3 | 09-29-2013 07:25 PM |
auto fill a word doc from another program | hcubed | Office | 0 | 06-19-2013 09:42 PM |
Mail Merge Auto Numbering | MaxBuck | Mail Merge | 5 | 02-19-2013 08:13 PM |
Can mail merge be used to auto attach docs to outlook | gm2034500 | Mail Merge | 1 | 12-26-2012 03:44 PM |