Excel Mail Merge (Excel 2000)

Topic

New Reply

Greetings:
Trying to use excel to do a complex mail merge into a word document. The address block is filled in when a cell in worksheet 1has a positive number. That number’s information is contained in worksheet 2. Each number is unique to contact information which is located in worksheet 2.
If the number in the cell is negative, it then references another cell in Worksheet 1 and goes to worksheet 3 to merge that information into the address block.
Can’t seem to get a formula (or something else) to do this? Any ideas???!!!!

Reply | Quote

Replies

I am not sure I follow what you want the formula to do. Could you be a little specific?

Steve

Reply | Quote

I want the formula to make choices based on the information in a cell (positive vs negative number) and merge information from the choice. For example, when doing the mail merge, can a formula be created to look at a cell and if the number is “86” it goes to another worksheet and gets address information to merge into the address block. If the number in the cell is negative, it goes to another cell to look at a number which references information in a third worksheet. The information referenced in the third worksheet is then merged into the address block in the Word document.
Have I confused you yet? Don’t mean to do that—just a problem posed to me by staff member.

Reply | Quote

Something like the hypothetical

=IF(source>0,VLOOKUP(source,addresslist,offset,FALSE),VLOOKUP(source2,addresslist,offset,FALSE))

(this formulas does the second lookup operation if the source<=0, rather than only if source<0)

Reply | Quote

Something like the hypothetical

=IF(source>0,VLOOKUP(source,addresslist,offset,FALSE),VLOOKUP(source2,addresslist,offset,FALSE))

(this formulas does the second lookup operation if the source<=0, rather than only if source<0)

Reply | Quote

I want the formula to make choices based on the information in a cell (positive vs negative number) and merge information from the choice. For example, when doing the mail merge, can a formula be created to look at a cell and if the number is “86” it goes to another worksheet and gets address information to merge into the address block. If the number in the cell is negative, it goes to another cell to look at a number which references information in a third worksheet. The information referenced in the third worksheet is then merged into the address block in the Word document.
Have I confused you yet? Don’t mean to do that—just a problem posed to me by staff member.

Reply | Quote

I am not sure I follow what you want the formula to do. Could you be a little specific?

Steve

Reply | Quote