Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Poonam Poonam is offline
Junior Member
 
Posts: 2
Default Mail Merge - Very Urgent

Dear Graham Mayor,

In my excel sheet i have following fields:

Account No, File No, 1st Name, 1st Name Address, 2nd Name, 2nd Name Address, 3rd Name, 3rd Name Address... and so on...

All these fields are in each record i.e. one field.

My Letter templates are as follows:
P1:
Account No./File No.
1st Name
1st Name Address

P2:
Account No./File No.
2nd Name
2nd Name Address

P3:
Account No./File No.
3rd Name
3rd Name Address

However some fields in excel are empty, like sometime 2nd Name and 2nd Name address is Blank or like wise. Can u help with some coding to make entire page empty if one field on the said page is empty, like:
P1:
Account No./File No.
1st Name
1st Name Address

P2:


P3:
Account No./File No.
3rd Name
3rd Name Address

i tried skipif n nextif but that miss out fields in record, so that is not working.
Please need your help its urgent
 
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
URGENT URGENT - Textbox seems linked to drawing object. RBear3 Tables 4 August 1st 07 01:32 PM
URGENT URGENT - Textbox seems linked to drawing object. RBear3 Page Layout 4 August 1st 07 01:32 PM
URGENT! How to merge jpgs with an excel list into a name badge [email protected] Mailmerge 1 June 6th 07 07:01 AM
urgent mail merge with different pictures problem oli merge Mailmerge 7 March 20th 07 02:54 PM
Merge does not filter to specific Access queries URGENT HELP PLEAS JCE_UK Mailmerge 1 February 11th 07 01:06 PM


All times are GMT +1. The time now is 04:11 AM.

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

About Us

"It's about Microsoft Word"