#1
|
|||
|
|||
Word type document auto fill in
Hi Guys,
This is what i want to do, I want to create a standardized letter with merged/auto filled in sections such as Employee id number and name. I would like to create an excel workbook with the data need to fill in the form and the actual form to which, once filled in, i can print from on letter head. Is this possible? Please advise. Regards, |
#2
|
||||
|
||||
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Team,
Please find attached. I would like to do all the editing in a file like this and be able to have all the fields edited/updated once the employee number (EMPLID#) is found. I know i currently have it set up as a mail merge, but that is not a function in excel. I would only like to use this one file while updating the master sheet periodically. Please advise, and do not be afraid to be innovative with me in getting this done. |
#4
|
||||
|
||||
You seem to want to create a lot of work for something that can be handled with no code via a very ordinary mailmerge using Word.
What you're asking for would require a fairly complex macro, to automate and populate an embedded Word document (so it's not using just 'a function in excel', anyway), for little practical benefit.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#5
|
|||
|
|||
You know what....you may be right...I just wanted to be a little more innovative with what was currently being done at work.....
Are there any other applications that can do this? |
#6
|
||||
|
||||
Well, if you kept all your data in Access, you might be able to get what you want via Access Reports, but that depends on how rich you want your formatting to be...
See: https://support.office.com/en-us/art...5-7158DCD3681C
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
PowerPoint wan to type chinese word auto come out pinyin | JasonLing92 | PowerPoint | 0 | 07-07-2015 08:12 PM |
Auto Fill-in, Editable Word Templates? | creb1099 | Word VBA | 2 | 10-18-2013 10:19 AM |
Auto Fill Multiple Word documents | thebeekeepingbiker | Word | 3 | 07-08-2013 07:23 PM |
auto fill a word doc from another program | hcubed | Office | 0 | 06-19-2013 09:42 PM |
Can Word auto type text for me? | paddyirishman05 | Word | 1 | 08-28-2011 01:30 AM |