Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Shan
 
Posts: n/a
Default 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.
 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
DotNet Data Table as Mail Merge Data Source goraya Mailmerge 1 July 7th 05 09:51 AM
Data Source abarrett Mailmerge 1 May 6th 05 06:15 AM
Specific Email Merge w/ Specific Attachements Mark B Mailmerge 9 February 21st 05 05:10 AM
Cannot Find Its Data Source Dave Foote Mailmerge 3 December 17th 04 11:27 AM
Merge Data Source path Peter Jamieson Mailmerge 0 November 25th 04 07:15 PM


All times are GMT +1. The time now is 07:38 PM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"