hi guys
I am typing code in VBA for printing a list of data from excel on label.
My boss send a template for me in MSWord.
He put the data to the place by using mail merge.
However, he wants me to create a userform to print the data without open MSWord
i dunno the code of printing a label and how to print it as well as the template he gave me.
Here is the template he gave me,there are footer that I cant copy:
CAUTION: Cell UM1
<tbody>
</tbody>
DELIVERY
END
Is there any possible way or example?
I am typing code in VBA for printing a list of data from excel on label.
My boss send a template for me in MSWord.
He put the data to the place by using mail merge.
However, he wants me to create a userform to print the data without open MSWord
i dunno the code of printing a label and how to print it as well as the template he gave me.
Here is the template he gave me,there are footer that I cant copy:
CAUTION: Cell UM1
«Subject_1 _Name_»«subject_1_Quantity» «subject_1_BB»« Subject _2_Plus_Sign» « Subject _2_ Quantity »« Subject _2_ aa »« Subject _2_BB» |
«Suject_1 » |
<tbody>
</tbody>
DELIVERY
END
Is there any possible way or example?