Create a macro in Word to format address label for printer
£20-250 GBP
Em Andamento
Publicado há quase 12 anos
£20-250 GBP
Pago na entrega
Requires a macro function, probably running in Microsoft Word, to process an email containing address details into an address label read to be printed on a label printer
The address labels arrive in our email inbox in the particular format (see attached document for detail)
This will be pasted into Word manually. The fields should be identified and should be formatted into an address format i.e.
Name
Address Line 1
Address Line 2
Town / City
County
Postcode
The following checks/adjustments should be made to the format;
* The postcode field should be adjusted to be capital letters
* The name and address fields should be adjusted so that the first letter of each word is made a capital letter. i.e. bank moore house would become Bank Moore House
* If any of the lines are blank, they should be removed from the label i.e. “Address Line 2” is often blank, so in this instance this field would be removed
* Font should be changed to “Calibri”
* Page size / layout should be amended to be label size of the printer (details to follow)
* Font size should be 15 point
* Font colour is black
This should be a fairly simple project to format an email address notification into a address label ready to be print. If this is created successful there are other larger projects in the pipeline.
Any questions please ask.