Home |
Search |
Today's Posts |
#1
|
|||
|
|||
can you mail merge in Excel
I have created an enrollment form in Excel (master file) and would like to
merge it with data from a different worksheet and then print all of the merged files simultaneously, just like you would in Word. I did not create in Word because some fields require complex calculations. I am not up on macros, so if there is a way to do this w/o macros, even better. |
#2
|
|||
|
|||
Excel doesn't have a merge feature. Perhaps you could do the merge in
Word, using the calculations from Excel. Otherwise, you would need programming, to loop through the records you want to print. Ft. Worth user wrote: I have created an enrollment form in Excel (master file) and would like to merge it with data from a different worksheet and then print all of the merged files simultaneously, just like you would in Word. I did not create in Word because some fields require complex calculations. I am not up on macros, so if there is a way to do this w/o macros, even better. -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
#3
|
|||
|
|||
Hi Ft.,
You might take a look at Mail Merge, Printing Labels using Mail Merge with data from Excel http://www.mvps.org/dmcritchie/excel/mailmerg.htm If not for labels you might want to also look at some of the references. --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm "Debra Dalgleish" wrote ... Excel doesn't have a merge feature. Perhaps you could do the merge in Word, using the calculations from Excel. Ft. Worth user wrote: I have created an enrollment form in Excel (master file) and would like to merge it with data from a different worksheet and then print all of the merged files simultaneously, just like you would in Word. complex formulas blah blah blah.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Different graphic for each record in mail merge document | Charts and Charting in Excel | |||
Merge mail excel to word | Excel Discussion (Misc queries) | |||
MAIL MERGE PROBLEMS | Excel Discussion (Misc queries) | |||
Merge from Excel to Excel | Excel Discussion (Misc queries) | |||
Mail merge to a chart | Charts and Charting in Excel |