Help in finding good help from mailmerge like here for excel

tia1971

New Member
Joined
Jul 18, 2007
Messages
7
I have an issue mail merging with an excel file and I also find great help here but didn't know if anyone could help with the mail merge part from word using and exel file I have. I can't find a website as good as this one so I will try here for help on a site and my issue hoping I will not get in trouble but I didn't know where else to go.
I have a excel sheet with Names and column of different types of flowers sold and the Amount that is owed and a sold by column. I need help merging the files to a label to print. Here is what I need help in
I want the Name Printed on the 1st line no problem there for me
On the second line I need it to Say them name of the flower which is listed on the column heading and then amount of flowers they bought, but if there is nothing there then I need it to go to the next column that has data and record it.
Then the 3rd Line would equal the amount owed only on 1 one of the items not all items need and amount
Then the last row to have Sold By
Example:
1st Label
Tammy Windham
10 Red Flash

2nd Label
Tammy Windham
5 Candidum

3rd Label
Tammy Windham
5 Carolyn Whartom
Amount:$17.00
Sold by Kathy Raley

So on to the next record only printing what was bought and the amount only showing on 1 of the labels under that persons name

I have the excel and word file to show
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Forum statistics

Threads
1,223,888
Messages
6,175,219
Members
452,619
Latest member
Shiv1198

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top