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,

Hi
use Word's mail merge. Lots of info out there

Also check this forum out

__________________
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

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.

Attached Files

Sample Union Information.xlsx (25.1 KB, 12 views)

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]

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?

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]