how can i Automatically create filename from several fields in word

A

apples

i have an access db which is linked via mailmerge into a word form.

what i would like to do if possible is automatically save the file in a
set location with a name dependant on several fields/bookmarks within
the form. i would also like to change the format to RTF.

the file name is made up like

(csr ref) 000000, (Site name) lane ends, (drawing type) construction,
(dwg status) approved

012345 lane ends construction approved

the dwg status will need to come from an IF stament as two fileds need
to be shown as approved... ie

approver 1 status App
approver 2 status Rejected

the drawing status will be rejected

i also need help with the IF statement..

Thanks in advanced
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1
can i automatically create new contact from specifc incoming mail 2
How do I automatically fill in one field based on another? 1
Database fields that are dependant 1
how do I create fields in word 2007 to automatic update in excel? 1
how can I convert data with fields in rows to fields as columns 3
How to create a template in word step by step 1
Lookup fields - Yes or No? 12

Top