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

 Hi Linda,   Sorry for not explaining myself very well.  That is what comes of 
trying to be too concise in a post! The 'new' Excel Sheet is to be used by our 
customers, for communications with us, and it is to be issued as a 
'Personalised' form with their own names and contact details already saved and 
protected.  Therefore, I have to issue it many times over with different data 
in the cells showing Customer Name, Contact, Address, Phone, etc. etc. and I 
dont want to have to type all the details for each seperate sheet. I have done 
a similar form in the past as a Word Document with great success.  A variation 
now means we want our customers to submit the form as an Excel sheet so that we 
can extract data, which is why I want to use the Excel sheet and not a Word 
document. I dont know if I have made things any better or if I have confused 
you even more!  Maybe if I cannot merge the details, I should create a macro to 
copy the cells from one sheet to another, then delete the 
row from the source sheet and then rerun the macro?  That should work I think! 
Thanks as always,  Roger  From: "Linda F. Johnson" 
<linda@xxxxxxxxxxxxxxxxxxxxxxxxxxx>Subject: Date: Tue, 28 Jun 2005 
22:36:10 -0400[mso] Re: Is there a Mail Merge facility in Excel?I really don't 
understand what you are trying to do....but, you can do amail merge in Word and 
use your Excel spreadsheet as your data source LindaLinda's Computer 
Stophttp://personal-computer-tutor.comSent: Tuesday, June 28, 2005 10:09 PMTo: 
mso@xxxxxxxxxxxxxxxxxxxx: [mso] Is there a Mail Merge facility in Excel?Hello 
everyone, I am wanting to link 2 Excel worksheets and use them inmuch the same 
way as Mail Merge works in Word. 'Sheet 1' has a number ofcells containing data 
such as Company Name, Address, Contact, Phone #, etcand has to be printed 
numerous times over with different data in thesecells. I have done a similar 
sheet in Word and managed to fill the fieldswith data taken from an Excel 
sheet. Now I would
  
like to use the same Exceldatabase to fill the cells in the new 'Sheet 1' but 
it does not seem to beas easy as I thought it would be! I have looked through 
Import Data in theHelp files but it does not seem to be what I want. Can 
someone please pointme in the right general direction and I will see what I can 
learn for myselfor alternatively tell me if tere is no way to do this. I doubt 
that is thecase though, and I am far more ready to believe that I am just 
looking inthe wrong place! (btw, I am using Word 2003 and Excel 2003). Thanks 
asalways, Best wishes, Roger
_______________________________________________
No banners. No pop-ups. No kidding.
Make My Way  your home on the Web - http://www.myway.com


*************************************************************
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: