Word / Excel Macro Mail Merge thing for agihcam
This project was awarded to agihcam for $120 NZD.Get free quotes for a project like this
Project Budget$30 - $250 NZD
The object of this is to create some price labels in a word document from data in an excel sheet
See attached Price label template – there needs to be 40 of these per page 10 rows of 4
They need to take the following
1) Description from Order Sheet (column B) - max 3 rows on price label with each row no more than 14 characters with each row centred. If description is longer than 42 characters trim at that.
2) Price – Retail price needs to be added in to the “Order Sheet” from the Master Spreadsheet Column M, as a new column in between column C/D
3) SKU – taken from column A of Order Sheet
Font styles and sizes need to be as per the template
This needs to be reusable e.g. we will have a new order sheet and need to generate new price labels each month
Most orders will be around 400 lines e.g. 10 pages of labels
See attached docs - the label template shows 4 of the same label - we only need one of each individual label so 40 lines of stock = 40 different prices labels on one sheet
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online