Hi Doug,
I apologise if i am not making myself clear. I have attempted to explain my
source file, target output. I am not very good with Macros and not good at VB
too. If you could point me in the right direction it would be great. I find
this forum very helpful in solving my issues.
Answer to your questions:
Question 3
Is that above starting data produced from some other source that might
possible be a better source of data for producing the labels? It seems to
me like it is probably a report formatted by some other system and you could
be better off starting with the raw data.
Ans: The data source is a word document.
Question 1 & 2
I will explain with an apt example and define what the out put label tag
should read.
PLATFORM #4 Prepared by: Date: Proj. #: Accepted
 Accepted as noted
 Rejected
Date:
Initials:
XYZ 2006/5/2 1588
Project Description: Component: MPI #: MPI Rev #:
RETUBE PLATFORM ASSEMBLY BRACE CLEVIS 26C 0
Drawing #: Rev. #: Assembly Drawing #: Rev. #:
21RT-87270-4034-01-DD-D 0 21RT-87270-4033-01-GA-E 0
ItemNo. OperNo. WitnessPoints Instruction StockNo. Dwg.Qty. TotalQty.
complete by date inspect / date
8 005 Release material; CSA G40.21-92 GRADE 44W 3 3
8 A015 Sawcut material as required 4 4
THIS IS THE DOCUMENT I START WITH . AN INSPECTION SHEET WHICH HAS DATA
FILLED WITH PREDEFINED FORMATING CELLS AND MERGED CELLS and table formats.
OUTPUT TO BE GENERATED - PRODUCT WORK ID TAGS
OUTPUT LABEL ID: 01
PROJECT: 1588
COMPONENT: BRACE CLEVIS
DWG. REF: 21RT-87270-4034-01-DD-D
PROJ DESC.: RETUBE PLATFORM ASSEMBLY
DWG. ITEM NO. Release material; CSA G40.21-92 GRADE 44W
OPER #- 005
DWG. QTY: 3
OUTPUT LABEL ID: 02
PROJECT: 1588
COMPONENT: BRACE CLEVIS
DWG. REF: 21RT-87270-4034-01-DD-D
PROJ DESC.: RETUBE PLATFORM ASSEMBLY
DWG. ITEM NO. Sawcut material as required
OPER# : A015
DWG. QTY: 4
PROBLEM: WHEN I RUN A LABEL MERGE SINCE THE FIRST 2 ROWS FIELDS LIKE PROJECT
DESC, COMPONENT NO, MPI, DWG # ARE IN A TABLE FORM I AM ABLE TO GET THAT
INFORMATION BUT THE OTHER ROWS WHICH CONTAIN OPER # , ITEM DESC, ITEM QTY,
DWG QTY WHICH DIFFER FROM ONE ROW TO ANOTHER I AM FINDING IT DIFFICULT TO
CAPTURE.
I HAVE THE OPTION OF REDESIGNING THE FORM TO OPTION THE DESIRED FIELD ORDER
IN THE DATA SOURCE. I HAVE TO CREATE A LABEL MERGE MACRO SUCH THAT ONCE
ANYONE FILLS IN THE DETAILS OF THE REPORT AND ADDS IN OTHER DETAILS ,
SELECTED FIELDS AND ITS VALUE SHOULD BE PRINTED OUT AS SHOWN IN THE LABEL
PRODUCT ID TAG.
Thank you for patiently reading this data. I would appreciate your help as
to how to proceed.