U
UXO
Hi
Our business sells items via mail order. We collect a customers address via
our website or eBay and paste it into a Word template that I've set up. The
template is split into 8 table cells. I've created a macro button which
allows us to paste the address text from our site unformatted.
We use a laser printer and have A4 sheets of 8 sticky labels. What we
usually do is print off as many addresses as possible in one print. However
sometimes we do not have 8 addresses to send to in that one print. What we'd
like to do is insert our address at the bottom of the label, the senders
address, just in case the parcel ever needs to come back to us. I considered
placing the address text already in the cells but if we don't use all 8
labels in one print it will print the sender address anyway, which isn't what
I want.
Is there anyway of inserting a predefined text (in this case the sender
address) upon the customers address being pasted into a cell using the
button, therefore it would only be printed when there is a customers address
present? Would I have to add extra macro script on to what I have made
already? If so, would it be possible to tell me what script to use?
I'd be very grateful of any help offered,
Regards
Ritch.
Our business sells items via mail order. We collect a customers address via
our website or eBay and paste it into a Word template that I've set up. The
template is split into 8 table cells. I've created a macro button which
allows us to paste the address text from our site unformatted.
We use a laser printer and have A4 sheets of 8 sticky labels. What we
usually do is print off as many addresses as possible in one print. However
sometimes we do not have 8 addresses to send to in that one print. What we'd
like to do is insert our address at the bottom of the label, the senders
address, just in case the parcel ever needs to come back to us. I considered
placing the address text already in the cells but if we don't use all 8
labels in one print it will print the sender address anyway, which isn't what
I want.
Is there anyway of inserting a predefined text (in this case the sender
address) upon the customers address being pasted into a cell using the
button, therefore it would only be printed when there is a customers address
present? Would I have to add extra macro script on to what I have made
already? If so, would it be possible to tell me what script to use?
I'd be very grateful of any help offered,
Regards
Ritch.