Home |
Search |
Today's Posts |
|
#1
|
|||
|
|||
Mail Merge using an Excel spreadsheet as a data source
Several of us use Excel as the data source, but when we connect to the
spreadsheet, in the Mail Merge recipients box Word displays the columns in the wrong order. For example: Spreadsheet column order is: Last Name, First Name, Address1, Address2,City, State, Zip WORD displays this as: Address2,City, State,Zip, Last Name, First Name, Address1 All the data is displayed, but if you want to select only certain people on the spreadsheet you have to scroll over on each record to find the right name and select it. Word will still place the data in the correct field, the problem only seems to exist in the Mail Merge Recipients box. HELP |
#2
|
|||
|
|||
Hi ?B?U2hhcnJvblR1Y2tlcg==?=,
Several of us use Excel as the data source, but when we connect to the spreadsheet, in the Mail Merge recipients box Word displays the columns in the wrong order. For example: Spreadsheet column order is: Last Name, First Name, Address1, Address2,City, State, Zip WORD displays this as: Address2,City, State,Zip, Last Name, First Name, Address1 There is simply no way to control in which order Word decides to display the columns in a data source. I am surprised it does it in the order you describe, however, as usually it insists on putting the Name information first. If you change Address2 in Excel to StreetAddress do you get a different order? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
#3
|
|||
|
|||
Oddly, I've never seen my columns listed in any order other than the one in
which they appear in the spreadsheet. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA Word MVP FAQ site: http://word.mvps.org Email cannot be acknowledged; please post all follow-ups to the newsgroup so all may benefit. "Cindy M -WordMVP-" wrote in message news:VA.0000b0a1.003bf9b2@speedy... Hi ?B?U2hhcnJvblR1Y2tlcg==?=, Several of us use Excel as the data source, but when we connect to the spreadsheet, in the Mail Merge recipients box Word displays the columns in the wrong order. For example: Spreadsheet column order is: Last Name, First Name, Address1, Address2,City, State, Zip WORD displays this as: Address2,City, State,Zip, Last Name, First Name, Address1 There is simply no way to control in which order Word decides to display the columns in a data source. I am surprised it does it in the order you describe, however, as usually it insists on putting the Name information first. If you change Address2 in Excel to StreetAddress do you get a different order? Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail Merge w/ Excel Data | Microsoft Word Help | |||
Specific Email Merge w/ Specific Attachements | Mailmerge | |||
Mail Merge Issue With Office 97 - Excel Data Source | Mailmerge | |||
Mail merge error occurs when filtering Excel data source | Mailmerge | |||
how do i create a mail merge for email using excel as a data sourc | Mailmerge |