Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Help Please
2) how can I add a soft return after a field but only if it exists, so there
is no space if there is no data in the field 3) as I have 16,000 records in 4 databases this is a big one for me, I have 41 columns and 41 products (Each product isnt named, its represented by a number, but they dont always have product one in column 1, product 2 in column 2... Some have product 6 in column 2 and product 7 in column 3 there are a ton of different formats. Some people get all 41 some people get less. So can I : a) is there a way to format the excel file that will move the 2's under the 2 column, the 3's under the 3 column etc...? b) Is there a way to tell mail merge that when it encounters a 1 in a field to post product name 1, if it finds 2 post product name 2 etc... |
#2
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Help Please
Not sure what happened to your first question, but for the second one, use
an If...then...Else field construction { IF { MERGEFIELD "nameoffieldthatmightbeempty" } ="" "{ MERGEFIELD "nextmergefield" }" "{ MERGEFIELD "nameoffieldthatmightbeempty" }¶ { MERGEFIELD "nextmergefield" }" } where the ¶ appears in the above construction, press the Enter key. You must use Ctrl+F9 to insert each pair of the field delimiters { } and use Alt+F9 to toggle off their display. For your second (sorry third) question, while you may be able to set up a new sheet in Excel that references the data in the existing sheet, using a Function to move things over, a low tech way of doing it would be to sort the data by as many fields as your version of Excel will allow (that is by the second, then the third, then the fourth, etc) then select and delete each of the empty blocks of cells, moving the data to the left. -- 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, originally posted via msnews.microsoft.com "Yookaroo" wrote in message ... 2) how can I add a soft return after a field but only if it exists, so there is no space if there is no data in the field 3) as I have 16,000 records in 4 databases this is a big one for me, I have 41 columns and 41 products (Each product isnt named, its represented by a number, but they dont always have product one in column 1, product 2 in column 2... Some have product 6 in column 2 and product 7 in column 3 there are a ton of different formats. Some people get all 41 some people get less. So can I : a) is there a way to format the excel file that will move the 2's under the 2 column, the 3's under the 3 column etc...? b) Is there a way to tell mail merge that when it encounters a 1 in a field to post product name 1, if it finds 2 post product name 2 etc... |
#3
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Help Please
Not sure what happened to my first question either.. Heck I cant even
remember what it was. Anyways this is a big help, where you say nextmergefield, do I put the name of the next field in or just leave it as is? As for the find replace I spent the last couple of hours find replacing into the excel file which is now huge but working. Thanks again "Doug Robbins - Word MVP" wrote: Not sure what happened to your first question, but for the second one, use an If...then...Else field construction { IF { MERGEFIELD "nameoffieldthatmightbeempty" } ="" "{ MERGEFIELD "nextmergefield" }" "{ MERGEFIELD "nameoffieldthatmightbeempty" }¶ { MERGEFIELD "nextmergefield" }" } where the ¶ appears in the above construction, press the Enter key. You must use Ctrl+F9 to insert each pair of the field delimiters { } and use Alt+F9 to toggle off their display. For your second (sorry third) question, while you may be able to set up a new sheet in Excel that references the data in the existing sheet, using a Function to move things over, a low tech way of doing it would be to sort the data by as many fields as your version of Excel will allow (that is by the second, then the third, then the fourth, etc) then select and delete each of the empty blocks of cells, moving the data to the left. |
#4
Posted to microsoft.public.word.mailmerge.fields
|
|||
|
|||
Mail Merge Help Please
Where I used the { MERGEFIELD nextmergefield } you need to use the actual
next merge field. -- 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, originally posted via msnews.microsoft.com "Yookaroo" wrote in message ... Not sure what happened to my first question either.. Heck I cant even remember what it was. Anyways this is a big help, where you say nextmergefield, do I put the name of the next field in or just leave it as is? As for the find replace I spent the last couple of hours find replacing into the excel file which is now huge but working. Thanks again "Doug Robbins - Word MVP" wrote: Not sure what happened to your first question, but for the second one, use an If...then...Else field construction { IF { MERGEFIELD "nameoffieldthatmightbeempty" } ="" "{ MERGEFIELD "nextmergefield" }" "{ MERGEFIELD "nameoffieldthatmightbeempty" }¶ { MERGEFIELD "nextmergefield" }" } where the ¶ appears in the above construction, press the Enter key. You must use Ctrl+F9 to insert each pair of the field delimiters { } and use Alt+F9 to toggle off their display. For your second (sorry third) question, while you may be able to set up a new sheet in Excel that references the data in the existing sheet, using a Function to move things over, a low tech way of doing it would be to sort the data by as many fields as your version of Excel will allow (that is by the second, then the third, then the fourth, etc) then select and delete each of the empty blocks of cells, moving the data to the left. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error: Mail merge not completed....doesnot contain mail merge fiel | Mailmerge | |||
Mail-Merge: Can we have master detail relationship or multiple entities in word Mail-Merge? | Microsoft Word Help | |||
Take Mail Merge in Word back the the Mail Merge Helper 1,2,3 Form. | Mailmerge | |||
Proteced Form with Mail Merge Section-Mail Merge is "lost" whe | Microsoft Word Help | |||
mail merge doc with further linked/embedded mail merge docs not playing the game | Mailmerge |