Tables...

robertreagan · Apr 16th, 2002, 04:22 PM

I am on the stewardship committee at my church. I want to create a table containing 3 columns. The first one would contain a parish member's current offering. The second would contain a suggested increase and the third would contain a slightly higher suggested increase. Then I could key the current offering into the spreadsheet, it would get matched to the first column of the table and I could plug in the proper amounts into the spreadsheet based on the table entries.
The ultimate goal then is that I can generate MailMerge letters!!!!
Is this possible????
Thank you

Jack in the UK · Apr 16th, 2002, 05:22 PM

Hi --

If you can handle the data input and formula to carry over the data to B and C with % increase or however you will work this out i would say yes..

trick wil lbe to use word and get word to data sorce the table xls sheet.

trick will be to name the columns as in give heading as you have discribed, now set template in word and filed out as needed the bits to merge.. sounds ok to me..

only select the cloumn you requre to merge not all the SpreadSheet.. try it...

Apr 16th, 2002, 05:22 PM	#2
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Hi -- If you can handle the data input and formula to carry over the data to B and C with % increase or however you will work this out i would say yes.. trick wil lbe to use word and get word to data sorce the table xls sheet. trick will be to name the columns as in give heading as you have discribed, now set template in word and filed out as needed the bits to merge.. sounds ok to me.. only select the cloumn you requre to merge not all the SpreadSheet.. try it... __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 16th, 2002, 04:22 PM	#1
robertreagan New Member Join Date: Apr 2002 Posts: 2	I am on the stewardship committee at my church. I want to create a table containing 3 columns. The first one would contain a parish member's current offering. The second would contain a suggested increase and the third would contain a slightly higher suggested increase. Then I could key the current offering into the spreadsheet, it would get matched to the first column of the table and I could plug in the proper amounts into the spreadsheet based on the table entries. The ultimate goal then is that I can generate MailMerge letters!!!! Is this possible???? Thank you