Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Mail Merge needs to return to 2000 format
The insertion of merge fields is barbaric, you have to add all fields on a
single line and then format the content, or close out of the popup window after each insertion so you can add the field and formatting at the same time. I like the check box beside each record to select records that do not fit a query. Your tutorial on Mail Merge has a spreadsheet with both first and last name in the same column of an Excel spreadsheet. You suggest to split the data, but use an antiquated method. Instead of adding a column and cutting and pasting each last name individually, why not use the features of the product. Click on data-text to columns, choose delimited length and space as a seperator and the data is split quickly. |
#2
|
|||
|
|||
It's not clear what tutorial you're referring to or whom you think you're
addressing. We're all just users here. For the first problem, see http://home.earthlink.net/~wordfaqs/...ailMerges.htm; for the second, see http://word.mvps.org/FAQs/TblsFldsFm...meLastName.htm -- 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. "SharronTucker" wrote in message ... The insertion of merge fields is barbaric, you have to add all fields on a single line and then format the content, or close out of the popup window after each insertion so you can add the field and formatting at the same time. I like the check box beside each record to select records that do not fit a query. Your tutorial on Mail Merge has a spreadsheet with both first and last name in the same column of an Excel spreadsheet. You suggest to split the data, but use an antiquated method. Instead of adding a column and cutting and pasting each last name individually, why not use the features of the product. Click on data-text to columns, choose delimited length and space as a seperator and the data is split quickly. |
#3
|
|||
|
|||
See http://www.gmayor.com/mail_merge_lab...th_word_xp.htm -- Graham Mayor - Word MVP My web site www.gmayor.com Word MVP web site http://word.mvps.org SharronTucker wrote: The insertion of merge fields is barbaric, you have to add all fields on a single line and then format the content, or close out of the popup window after each insertion so you can add the field and formatting at the same time. I like the check box beside each record to select records that do not fit a query. Your tutorial on Mail Merge has a spreadsheet with both first and last name in the same column of an Excel spreadsheet. You suggest to split the data, but use an antiquated method. Instead of adding a column and cutting and pasting each last name individually, why not use the features of the product. Click on data-text to columns, choose delimited length and space as a seperator and the data is split quickly. |
#4
|
|||
|
|||
It was posted as a "Suggestion to Microsoft" on the web based
newsgroup: http://www.microsoft.com/office/comm...8-e0317006c121 Hopefully the next version due out will include more information on Suggestion posts for NNTP users. -- Please post all follow-up questions to the newsgroup. Requests for assistance by email can not be acknowledged. ~~~~~~~~~~~~~~~ Beth Melton Microsoft Office MVP Word FAQ: http://mvps.org/word TechTrax eZine: http://mousetrax.com/techtrax/ MVP FAQ site: http://mvps.org/ "Suzanne S. Barnhill" wrote in message ... It's not clear what tutorial you're referring to or whom you think you're addressing. We're all just users here. For the first problem, see http://home.earthlink.net/~wordfaqs/...ailMerges.htm; for the second, see http://word.mvps.org/FAQs/TblsFldsFm...meLastName.htm -- 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. "SharronTucker" wrote in message ... The insertion of merge fields is barbaric, you have to add all fields on a single line and then format the content, or close out of the popup window after each insertion so you can add the field and formatting at the same time. I like the check box beside each record to select records that do not fit a query. Your tutorial on Mail Merge has a spreadsheet with both first and last name in the same column of an Excel spreadsheet. You suggest to split the data, but use an antiquated method. Instead of adding a column and cutting and pasting each last name individually, why not use the features of the product. Click on data-text to columns, choose delimited length and space as a seperator and the data is split quickly. |
#5
|
|||
|
|||
It's still not clear what tutorial the OP is referring to.
-- 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. "Beth Melton" wrote in message ... It was posted as a "Suggestion to Microsoft" on the web based newsgroup: http://www.microsoft.com/office/comm...8-e0317006c121 Hopefully the next version due out will include more information on Suggestion posts for NNTP users. -- Please post all follow-up questions to the newsgroup. Requests for assistance by email can not be acknowledged. ~~~~~~~~~~~~~~~ Beth Melton Microsoft Office MVP Word FAQ: http://mvps.org/word TechTrax eZine: http://mousetrax.com/techtrax/ MVP FAQ site: http://mvps.org/ "Suzanne S. Barnhill" wrote in message ... It's not clear what tutorial you're referring to or whom you think you're addressing. We're all just users here. For the first problem, see http://home.earthlink.net/~wordfaqs/...ailMerges.htm; for the second, see http://word.mvps.org/FAQs/TblsFldsFm...meLastName.htm -- 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. "SharronTucker" wrote in message ... The insertion of merge fields is barbaric, you have to add all fields on a single line and then format the content, or close out of the popup window after each insertion so you can add the field and formatting at the same time. I like the check box beside each record to select records that do not fit a query. Your tutorial on Mail Merge has a spreadsheet with both first and last name in the same column of an Excel spreadsheet. You suggest to split the data, but use an antiquated method. Instead of adding a column and cutting and pasting each last name individually, why not use the features of the product. Click on data-text to columns, choose delimited length and space as a seperator and the data is split quickly. |
#6
|
|||
|
|||
I see that now. Help maybe???
-- Please post all follow-up questions to the newsgroup. Requests for assistance by email can not be acknowledged. ~~~~~~~~~~~~~~~ Beth Melton Microsoft Office MVP Word FAQ: http://mvps.org/word TechTrax eZine: http://mousetrax.com/techtrax/ MVP FAQ site: http://mvps.org/ "Suzanne S. Barnhill" wrote in message ... It's still not clear what tutorial the OP is referring to. "Beth Melton" wrote in message ... It was posted as a "Suggestion to Microsoft" on the web based newsgroup: |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Mail merge - Word 2003/Access 2000 | Mailmerge | |||
mail merge with attachments | Mailmerge | |||
mail merge from excel that changes my format from UK to US format | Mailmerge | |||
Mail Merge Problem w/ MS Word 2000 | Mailmerge | |||
Mail Merge - Date Format | Microsoft Word Help |