Closed

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
Employer working
Awarded to:
Skills Required
Project Budget
$30 - $250 NZD
Total Bids
31
Project Description

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

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online