Forum Discussion

AlexP1980

Copper Contributor

Dec 06, 2023

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 complete...

excel

Formulas and Functions

JKPieterse

Silver Contributor

Dec 06, 2023

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-932c49474705

AlexP1980

Copper Contributor

Dec 06, 2023

Thank 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

JKPieterse
Silver Contributor
Dec 08, 2023
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")
peiyezhu
Bronze Contributor
Dec 07, 2023
The issue is I cannot link several cells inside the text box,

one to many structure in Excel sheet?

https://www.bilibili.com/video/BV1Tm4y1K7Ug/?buvid=XX85E838539534AD650323D79CEE8DA100517&from_spmid=default-value&is_story_h5=false&mid=FSMZLyVVbtrPTKay0%2Fc9Fg%3D%3D&p=1&plat_id=116&share_from=ugc&share_medium=android&share_plat=android&share_session_id=4d02aea5-46dc-4a48-af6d-7da449e41e91&share_source=COPY&share_tag=s_i&spmid=main.ugc-video-detail.0.0&timestamp=1701924103&unique_k=eVNSI0p&up_id=634143044

have a Word document

How about Excel.sheet as template rather than Word document?