We help IT Professionals succeed at work.

Mail Merge

86 Views
Last Modified: 2018-02-15
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»
Comment
Watch Question

Roy CoxGroup Finance Manager
CERTIFIED EXPERT

Commented:
Are you using Excel or Word?

Attach an example of what you want.
Nur Md. IqbalExecutive, TSD

Author

Commented:
Here is the attached file.
WORK_ORDER.xlsm
Work-Order-No.docx
Roy CoxGroup Finance Manager
CERTIFIED EXPERT

Commented:
I would simply create it all within Excel. Then the Work order can be populated by formulas
Nur Md. IqbalExecutive, TSD

Author

Commented:
help me to do so.
Nur Md. IqbalExecutive, TSD

Author

Commented:
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 CoxGroup Finance Manager
CERTIFIED EXPERT

Commented:
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.
Group Finance Manager
CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Nur Md. IqbalExecutive, TSD

Author

Commented:
#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 CoxGroup Finance Manager
CERTIFIED EXPERT

Commented:
It's an example. Edit the form to match your word doc. If you need help amending the formulas then let me know
Roy CoxGroup Finance Manager
CERTIFIED EXPERT

Commented:
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
Nur Md. IqbalExecutive, TSD

Author

Commented:
@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 CoxGroup Finance Manager
CERTIFIED EXPERT

Commented:
Provide examples of what you need changing in the example
Roy CoxGroup Finance Manager
CERTIFIED EXPERT

Commented:
Only solution offered, just needs tweaking for author's use

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions