Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Empty cells in data source
I am using Excel as my data source for merge document I created myself. The
document has borders around certain areas. Problem is, I don't want to fill the Excel empty cells with "NA" if there is no data (no mobile phone number or email address for example). When I perform the merge, it "deflates" if you will, the borders I had set up where no data merged and messes up my formatting (columns). I tried to add a switch ( {Mergefield Mobile_Phone \b" "} ) with no luck. Plus, this drops my very last bordered item that is currently in a column (right side of column 2 set up) to page 2. I don't know how to prevent this from happening. |
#2
|
|||
|
|||
Try either of the following:
a. just put a space after the merge field (of course that may screw up the output where there /is/ a phone number) b. use a nested IF field, e.g. { IF "{ MERGEFIELD Mobile_Phone }" = "" " " "{ MERGEFIELD Mobile_Phone }" } All the {} need to be the special field codes you can enter using ctrl-F9. Peter Jamieson "Shan" wrote in message ... I am using Excel as my data source for merge document I created myself. The document has borders around certain areas. Problem is, I don't want to fill the Excel empty cells with "NA" if there is no data (no mobile phone number or email address for example). When I perform the merge, it "deflates" if you will, the borders I had set up where no data merged and messes up my formatting (columns). I tried to add a switch ( {Mergefield Mobile_Phone \b" "} ) with no luck. Plus, this drops my very last bordered item that is currently in a column (right side of column 2 set up) to page 2. I don't know how to prevent this from happening. |
#3
|
|||
|
|||
Can I still use the nested IF field below if I have already formatted the
mobile phone field to be display as a phone number (555.555.5555) ? Thanks! "Peter Jamieson" wrote: Try either of the following: a. just put a space after the merge field (of course that may screw up the output where there /is/ a phone number) b. use a nested IF field, e.g. { IF "{ MERGEFIELD Mobile_Phone }" = "" " " "{ MERGEFIELD Mobile_Phone }" } All the {} need to be the special field codes you can enter using ctrl-F9. Peter Jamieson "Shan" wrote in message ... I am using Excel as my data source for merge document I created myself. The document has borders around certain areas. Problem is, I don't want to fill the Excel empty cells with "NA" if there is no data (no mobile phone number or email address for example). When I perform the merge, it "deflates" if you will, the borders I had set up where no data merged and messes up my formatting (columns). I tried to add a switch ( {Mergefield Mobile_Phone \b" "} ) with no luck. Plus, this drops my very last bordered item that is currently in a column (right side of column 2 set up) to page 2. I don't know how to prevent this from happening. |
#4
|
|||
|
|||
Trying it is usually the best and most reliable way to find out :-)
The only thing that counts is what the value of { MERGEFIELD Mobile_Phone } is when you have a "blank" number. If it is "", then the IF filed should work. If it is something like (..), then modify the comparison so you get { IF "{ MERGEFIELD Mobile_Phone }" = "(..)" " " "{ MERGEFIELD Mobile_Phone }" } Peter Jamieson "Shan" wrote in message ... Can I still use the nested IF field below if I have already formatted the mobile phone field to be display as a phone number (555.555.5555) ? Thanks! "Peter Jamieson" wrote: Try either of the following: a. just put a space after the merge field (of course that may screw up the output where there /is/ a phone number) b. use a nested IF field, e.g. { IF "{ MERGEFIELD Mobile_Phone }" = "" " " "{ MERGEFIELD Mobile_Phone }" } All the {} need to be the special field codes you can enter using ctrl-F9. Peter Jamieson "Shan" wrote in message ... I am using Excel as my data source for merge document I created myself. The document has borders around certain areas. Problem is, I don't want to fill the Excel empty cells with "NA" if there is no data (no mobile phone number or email address for example). When I perform the merge, it "deflates" if you will, the borders I had set up where no data merged and messes up my formatting (columns). I tried to add a switch ( {Mergefield Mobile_Phone \b" "} ) with no luck. Plus, this drops my very last bordered item that is currently in a column (right side of column 2 set up) to page 2. I don't know how to prevent this from happening. |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DotNet Data Table as Mail Merge Data Source | Mailmerge | |||
Data Source | Mailmerge | |||
Specific Email Merge w/ Specific Attachements | Mailmerge | |||
Cannot Find Its Data Source | Mailmerge | |||
Merge Data Source path | Mailmerge |