Word / Excel Macro Mail Merge thing for agihcam

  • Status Closed
  • 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

Get free quotes for a project like this
Awarded to:
Skills Required

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