#1
|
|||
|
|||
Merge fields from Excel into word document
Good afternoon
I am a financial adviser and in the course of my business I draw financial information from clients in excel spreadsheet. I also have a templated 'statement of advice'. I am seeking to automate the transfer of the excel fields into the word document and hope someone can point me to the function I need to learn or get trained up on. as an example, a client might say that when if they die they want $500k to clear the mortgage, $20k for final expenses, $600k for an income subsidy for remaining partner. Each of those amount will be input into the spreadsheet along with other details such as income, tax rate and a number of other fields. When I automate it across I want the document to look for the inputted data and drag it into the document. "You told me that in the event of your premature death would required (from excel) to clear the outstanding mortgage, (from excel) for funeral and final costs.......... I have checked the help files and mail merge seems to be something like what I am seeking but i am not convinced. If anyone can point me towards what I need to scrub up on I would be very appreciative cheers tony |
#2
|
|||
|
|||
|
#3
|
|||
|
|||
Thank you for this. The other function I am seeking is one I used some years ago in Word but can't remember what function it was. In essence you got a series of dialogue boxes into which you freeflowed your text as it worked through the templated document (in my case statement of advice). First box might be "current situation" so you input the text into the dialogue box and then moved onto the second one "current insurance cover in place" and so on. At the end the freeflow text was in the appropriate position within the templated document.
cheers |
#4
|
|||
|
|||
You may be talking about a protected form using legacy form fields, or you might be talking about a custom dialog box (UserForm).
Making Forms with Microsoft Word Create a Simple Userform With Word 2013, you could be using Content Controls and editing restrictions instead of legacy formfields. |
#5
|
||||
|
||||
Please fix the grammar in the sentence ""You told me that in the event of your premature death would required (from excel) to clear the outstanding mortgage, (from excel) for funeral and final costs.........." before sending the document to your clients, if you want to be taken seriously.
__________________
Graham Mayor - MS MVP (Word) (2002-2019) Visit my web site for more programming tips and ready made processes www.gmayor.com |
#6
|
|||
|
|||
Quote:
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Using 3 different fields, several times in same document but not en mass - should I use mail merge? | shoughton | Mail Merge | 1 | 06-24-2015 02:46 PM |
Creating a table in one document of WORD from EXCEL with Mail Merge | Joseph.Comerford@bentley. | Mail Merge | 1 | 04-18-2015 01:19 AM |
trouble setting excel to import correctly into mail merge. Not using typical address fields | ragoo | Mail Merge | 1 | 10-28-2014 03:42 PM |
Merge fields in Word and source data from Excel | SteveVai | Mail Merge | 3 | 03-13-2014 05:25 AM |
merge fields at bottom of document causing two pages | fredsin | Mail Merge | 3 | 03-15-2012 02:21 PM |