ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Mail Merge (https://www.excelbanter.com/excel-discussion-misc-queries/223819-mail-merge.html)

pete5440

Mail Merge
 
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.

Shane Devenshire

Mail Merge
 
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.



All times are GMT +1. The time now is 02:46 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com