[mso] Re: Is there a Mail Merge facility in Excel?

Hello Roger,
AFAIK Excel doesn't have a built-in merge routine, you will have to 
program it yourself, using macros written in VBA. Basically the macro 
will have to look into the sheet which has the data, one record at a 
time, move the data to the correct fields in "Sheet 1", print it, 
then look in the other sheet for the next record, and so on. It's not 
difficult, but you do have to know how macros work in Excel.
Wilson

At 23:09 28/6/2005,Roger wrote:
>  Hello everyone, I am wanting to link 2 Excel worksheets and use 
> them in much the same way as Mail Merge works in Word. 'Sheet 1' 
> has a number of cells containing data such as Company Name, 
> Address, Contact, Phone #, etc and has to be printed numerous times 
> over with different data in these cells.   I have done a similar 
> sheet in Word and managed to fill the fields with data taken from 
> an Excel sheet.  Now I would like to use the same Excel database to 
> fill the cells in the new 'Sheet 1' but it does not seem to be as 
> easy as I thought it would be!  I have looked through Import Data 
> in the Help files but it does not seem to be what I want. Can 
> someone please point me in the right general direction and I will 
> see what I can learn for myself or alternatively tell me if tere is 
> no way to do this.  I doubt that is the case though, and I am far 
> more ready to believe that I am just looking in the wrong 
> place!  (btw, I am using Word 2003 and Excel 2003). Thanks as always,  Best
>wishes,  Roger


*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, send an email to 
mso-request@xxxxxxxxxxxxx with the word "unsubscribe" (without the quotes) in 
the subject line.

Or, visit the group's homepage and use the dropdown menu.  This will also allow 
you to change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to use the files section for sharing files with the group, send a 
request to mso-moderators@xxxxxxxxxxxxx and you will be sent an invitation with 
instructions.  Once you are a member of the files group, you can go here to 
upload/download files:
http://www.smartgroups.com/vault/msofiles
*************************************************************

Other related posts: