Forum Discussion
Excel help
Hi,
I need some help and understand if it is possible or not what we do want to do.
I have an excel file with several data and I have a Word file template where some fields are to be completed with the data from the excel file.
The user will fill the excel file and the calculations are done accordingly with the input. So the data won't be static.
With the information that we get from the user/excel file we want to complete a word document.
Is it possible for this word file to be completed automatically with the data from the excel file?
This will save us time, because we will not be creating the word file manually.
Thanks
Alex
- Yes you can do that using Words mail merge feature:
https://support.microsoft.com/en-us/office/use-mail-merge-for-bulk-email-letters-labels-and-envelopes-f488ed5b-b849-4c11-9cff-932c49474705Thank you for the quick reply. JKPieterse
I was checking and I don't think that he does exactly what I need. Let me explain better what I need.
The user will have a generic Excel file where they put some details. According to the details the Excel will show some figures.
I would like the user to have the possibility to have a Word document with some of the details they put in the excel file.
I thought opening a second sheet in the excel file and copy the content of the word file to a text box. The issue is I cannot link several cells inside the text box, I only can link one text box to one cell of the excel file. I wanted within the text box link several data from different cells.
I don't know if I made myself clear and I don't know if this is someway possible.
Thanks.
Alex
You could prepare an Excel cell with all the information that you want to get displayed in Word , by using string functions. Like this:
="The value in cell A1, formatted with two decimals is: " & TEXT(A1,"0.00")&CHAR(10)&"And the value of cell A2, formatted as a date is: " & TEXT(A2,"dd/mm/yyyy")
