If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Address block
I have all my data for mail merges in Excel. I do
frequent mail merges and I am now frustrated because I cannot customize the "address block". since I work for a religious organization, I need the title after the name. If I go into "more", I can insert the name, but if I use the space bar, I don't get a space but it inserts the same name agains. In order to get the address as I need it, I have to close the box, make my space then open the box again for the next line, etc. until I have all the merge fields in. Can anyone help me with this problem? Thanks. |
#2
|
|||
|
|||
Address block
I have all my data for mail merges in Excel. I do
frequent mail merges and I am now frustrated because I cannot customize the "address block". Actually, you're question belongs in the Word forum. Excel has no mail merge facility. -- Mark Henri Excel Support Technician www.canhelpyou.com ---------------------------------------------------------------------- Every member of the CanHelpYou team holds at least a Microsoft Level 1 Excel certification. In addition, we have experts in PowerPoint, Word and other products such as IIS, SQL Server 2000, network connectivity. We're here to help whenever you need us. |
#3
|
|||
|
|||
Address block
Hi Renate,
Is your data in the form of a spreadsheet with *labels* across the top. Those labels in row 1 might look something like Phone | First name | lastname | address line ! City | ST | zipcode| datejoined If your data is in columns but you do not have labels you will have a dickens of time trying to figure things out. Instructions to create address labels with Mail Merge (part of MS Word) can be found in http://www.mvps.org/dmcritchie/excel/mailmerg.htm While true that Mail Merge is MS Word, there are enough Word people in the Excel groups that as long as you are using Excel for you input you should be fine posting here. I think you are missing the labels at the top of your columns, perhaps even missing the columns. Most Excel users have more than one worksheet in use in a workbook, and the fact that Mail Merge (MS Word) will use the *first* worksheet tab is a lot more likely to be encountered as a problem by someone more oriented to Excel than to Word. http://www.mvps.org/dmcritchie/excel/mailmerg.htm HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "Renate" wrote in message ... I have all my data for mail merges in Excel. I do frequent mail merges and I am now frustrated because I cannot customize the "address block". since I work for a religious organization, I need the title after the name. If I go into "more", I can insert the name, but if I use the space bar, I don't get a space but it inserts the same name agains. In order to get the address as I need it, I have to close the box, make my space then open the box again for the next line, etc. until I have all the merge fields in. Can anyone help me with this problem? Thanks. |
Thread Tools | |
Display Modes | |
|
|