Avatar of Nur Md. Iqbal
Nur Md. Iqbal
Flag for Bangladesh asked on

Mail Merge

Hello,

How can I use Mail Merge to make a Work order using mail merge which should be Sorted by WO.
The format of WO is as below.... I am trying but not working....

Work Order No.      :      SNCL/ MTCE/001                                                             Date of ISSUE      :      «DoI»


Vendor                             :      «Vendor_Name»
Contact                              :      Mr/s. «Contact_Person»
Address                       :      «Address»
Phone No                      :      «Phone_Number»            

W/O Started in               :      «Started»
W/O Completed in       :      «Finish»

//Item Description Table
------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SL#       |    DESCRIPTION OF ITEMS   |QTY           |UOM        |UNIT PRICE        |TAX                      |Total AMOUNT
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------
«Sr» |   «Items»                                 | «Qty»   |«UoM»     |«Unit_Price»    |«TAX»                | «Total_Price»«Next Record»
 (1)     |   «Description»                      |               |                 |                           |                          |
«Sr» |   «Items»                                 | «Qty»   |«UoM»     |«Unit_Price»    |«TAX»                | «Total_Price»«Next Record»
 (2)  |   «Description»                      |               |                 |                           |                          |
«Sr» |   «Items»                                 | «Qty»   |«UoM»     |«Unit_Price»    |«TAX»                | «Total_Price»
 (3)   |   «Description»                      |               |                 |                           |                          |
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Grand Total:      «Grand_Total»

In words:«In_words»
Microsoft OfficeMicrosoft ExcelMicrosoft Word

Avatar of undefined
Last Comment
Roy Cox

8/22/2022 - Mon
Roy Cox

Are you using Excel or Word?

Attach an example of what you want.
Nur Md. Iqbal

ASKER
Here is the attached file.
WORK_ORDER.xlsm
Work-Order-No.docx
Roy Cox

I would simply create it all within Excel. Then the Work order can be populated by formulas
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
Nur Md. Iqbal

ASKER
help me to do so.
Nur Md. Iqbal

ASKER
I think it is possible to separate the information as Main Tab, Items_Info Tab and Vendor_Info Tab in Excel.  Then It will looks better and will work as DATABASE.
Roy Cox

You are right. You need a a database for Vendor Details, Products and Work Order details. That would be 3 databases i.e. 3 tables on 3 sheets.

I'll have a look through my previous work and find something to adapt for you.  It will tak a while so be patient.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER CERTIFIED SOLUTION
Roy Cox

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Nur Md. Iqbal

ASKER
#Mr. Roy_Cox, In your solution there is some extra row Printed which was not assign to be there. Check the Word file... I need exactly same format.
Roy Cox

It's an example. Edit the form to match your word doc. If you need help amending the formulas then let me know
Roy Cox

I'm still waiting for any response. I cannot proceed any further than my last example which demonstartes how to do this usuing only Excel
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Nur Md. Iqbal

ASKER
@Roy: As my requirements was to generate a Word file having all information by calling an unique key "Work Order No.", it should process a single page containing all information related to these key.
Roy Cox

Provide examples of what you need changing in the example
Roy Cox

Only solution offered, just needs tweaking for author's use
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.