Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
When doing a mail merge and I go to Edit Recipient List, the columns that
appear are not in the same order as my Excel worksheet. On my excel worksheet the first column is a date column (00/00/2009) but this appears on the far right column of the recipient list. I can drag the date column to the left but I am curious as to why it appears this way as I need this date column in the first position to select my recipients. Second question on the recipient list is is there a way to select (check) a group of recipients (rows) without having to individually check each box? I tried CTRL Shift at each end but this doesnt work. Finally, why, after I have selected my Address Block and Updated my labels, is the first label on the sheet the last one from my list? I must manually click back to the beginning of my recipient list to the first label I want. I never recall having these issues with earlier versions of Excel. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi,
You might get more useful responses from the Word Newsgroup, they have a group devoted to mail merge. http://www.microsoft.com/communities...&lang=en&cr=US -- If this helps, please click the Yes button. Cheers, Shane Devenshire "pete5440" wrote: When doing a mail merge and I go to Edit Recipient List, the columns that appear are not in the same order as my Excel worksheet. On my excel worksheet the first column is a date column (00/00/2009) but this appears on the far right column of the recipient list. I can drag the date column to the left but I am curious as to why it appears this way as I need this date column in the first position to select my recipients. Second question on the recipient list is is there a way to select (check) a group of recipients (rows) without having to individually check each box? I tried CTRL Shift at each end but this doesnt work. Finally, why, after I have selected my Address Block and Updated my labels, is the first label on the sheet the last one from my list? I must manually click back to the beginning of my recipient list to the first label I want. I never recall having these issues with earlier versions of Excel. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Mail Merge | Excel Discussion (Misc queries) | |||
Code launches Mail Merge but disables the Mail Merge | Excel Discussion (Misc queries) | |||
mail merge | Excel Discussion (Misc queries) | |||
mail merge excludes my headers and critical data in Word merge | Excel Discussion (Misc queries) | |||
how do i get my mail merge to update the data source at each merge | Excel Discussion (Misc queries) |