troubleshooting Question

Mail Merge

Avatar of Nur Md. Iqbal
Nur Md. IqbalFlag for Bangladesh asked on
Microsoft OfficeMicrosoft ExcelMicrosoft Word
13 Comments1 Solution90 ViewsLast Modified:
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»
ASKER CERTIFIED SOLUTION
Roy Cox
Group Finance Manager

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 13 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 13 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros