Results 1 to 2 of 2

Mail Merge Issue with Tables, Variable Rows, and number formatting

Threaded View

  1. #1
    Registered User
    Join Date
    03-09-2015
    Location
    florida
    MS-Off Ver
    MS office professional plus 2010 v14
    Posts
    1

    Exclamation Mail Merge Issue with Tables, Variable Rows, and number formatting

    My I have a data base (sample file attached) that I need to convert highlighted data into mail merge quickly, with out reformatting the excel file. My mail merge needs to contain name, selling price, 2% discount, and then a table of account name, description, and selling price. (The last part is difficult for me because some records are variable in the number of rows they contain. I also am having issues getting the pricing data to format like $1.99.

    Thank you so much for your help!

    test mail merge letter.xlsx


    Name GBO Loc Code Account Name Description Status Status Date Selling Price 2% Payout
    Jon Miller Test GBO 123 Test Bldg 1 add traveller for Life Safety speakers Booked 10/3/2014 $26,229.00 $500.00
    Jon Miller Test GBO 123 Test Bldg 2 Obsolete governor replacement Booked 10/30/2014 $25,569.20 $500.00
    Jon Miller Test GBO 123 Test Bldg 3 Obsolescence - Drives Booked 12/12/2014 $19,595.00 $391.90
    Jon Miller Test GBO 123 $71,393.20 $1,391.90
    Frank Smith Test GBO 123 Test A run new wires Booked 10/16/2014 $39,893.84 $500.00
    Frank Smith Test GBO 123 Test B T&M hoistway access Booked 10/21/2014 $158.10 $3.16
    Frank Smith Test GBO 123 Test C Opti Guard Booked 10/23/2014 $3,685.69 $73.71
    Frank Smith Test GBO 123 Test D Single Bottom Cylinder Booked 12/4/2014 $82,720.00 $500.00
    Frank Smith Test GBO 123 $126,457.63 $1,076.88
    Joe Test Test GBO 123 Test I Install handrail with vulcanizing Booked 10/13/2014 $5,437.27 $108.75
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Mail merge DDE issue
    By Zealotwraith in forum Word Formatting & General
    Replies: 2
    Last Post: 01-18-2014, 03:21 AM
  2. Mail Merge issue
    By jchris in forum Excel General
    Replies: 0
    Last Post: 11-30-2010, 11:04 AM
  3. Formatting issue - Inserting variable rows
    By BaronDJB in forum Excel General
    Replies: 0
    Last Post: 08-25-2010, 06:26 AM
  4. Retain cell number formatting in Word Mail Merge
    By chriskxp2123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-16-2005, 03:39 PM
  5. Mail Merge-Tables
    By MHoffmeier in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-12-2005, 06:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1