Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Phillip Vong Phillip Vong is offline
external usenet poster
 
Posts: 3
Default Mail Merge not in same order as in XLS

Using Office 2003.

A simple mail merge to creat lables. I have an excel sheet with Columns
(FirstName, LastName, Address). When I do a Mail Merge, the selection has
Address first and I want the merge selection to show in the exact same order
as I have it in Excel.

Thanks in advance.

Phil


  #2   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Doug Robbins - Word MVP Doug Robbins - Word MVP is offline
external usenet poster
 
Posts: 8,832
Default Mail Merge not in same order as in XLS

I assume that you are using the AddressBlock and the fields are not mapped
correctly. Instead of doing that, just insert the individual merge fields
into the main document in the order that you want them.

--
Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

"Phillip Vong" phillip_vong*at*yahoo*dot*com wrote in message
...
Using Office 2003.

A simple mail merge to creat lables. I have an excel sheet with Columns
(FirstName, LastName, Address). When I do a Mail Merge, the selection has
Address first and I want the merge selection to show in the exact same
order as I have it in Excel.

Thanks in advance.

Phil



Reply
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Can't get Word 2003 to keep data file with mail merge main documen Yourcareercoach Mailmerge 9 August 10th 06 12:19 PM
mail merge with word 2003 ken sunshine New Users 5 March 23rd 06 05:01 PM
Adding a field to an Off 97 mail merge using Office Pro 2003 TomC Mailmerge 1 January 5th 06 08:00 AM
Mail Merge Issue With Office 97 - Excel Data Source Matt Thorley Mailmerge 1 February 15th 05 11:38 PM
Word-Excel 2003 - Mail Merge Recipients problem AYager Mailmerge 2 January 11th 05 04:11 AM


All times are GMT +1. The time now is 12:35 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"