A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Word
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Post New Thread
Threads in Forum : Mailmerge Forum Tools Search this Forum Feed Icon
  Thread Reverse Sort Order / Thread Starter Last Post Replies Views
Suppressing a Blank Field by Kim Cose
I am merging an Excel spreadsheet with a first name, last name and class year for table tents. However, not all records have a class year. On my main...
May 11th, 2004 09:36 PM
by Charles Kenyon Go to last post
1 394
suppressing blank address lines in mail merge by Geoff Holt
Source is SQL 2000 database where there are blank address lines before the postcode. Is there a method of skipping blank lines resulting from blank fields in...
November 26th, 2004 07:16 PM
by Peter Jamieson Go to last post
1 357
Suppressing blank lines by Deedo
HI there, I'm having problems suppressing blank lines in a mailing label Word doc (drawing on data from Excel). The option is ticked to suppress the blank...
September 23rd, 2009 04:06 PM
by Graham Mayor Go to last post
1 131
Suppressing blank lines in a mailing label in Word 2007 by Oldsfan
I have been trying unsuccessfully for days to eliminate the blank line on a merged mailing label because the "Address 2" field is blank. Even though the...
March 5th, 2008 06:36 AM
by Graham Mayor Go to last post
8 228
Suppressing Blank Lines in Merge by Linda K.
Does anyone know how to suppress blank lines in a Word 2002 mail merge? Specifically, we're trying to keep blank lines from appearing when the merged record...
May 3rd, 2004 10:16 PM
by Cindy M -WordMVP- Go to last post
1 690
Suppressing Mail Merge Wizard and using menus instead by Margaret Hargreaves
Hi I sincerely hope Susanna Barnhill sees this as I understand she has previously sent info to this forum which I appear to have missed. At the moment,...
June 1st, 2004 08:12 PM
by Margaret Hargreaves Go to last post
4 235
suppressing part of a text field in a merged document by Thicklizzie
I am mail merging from an Access database and one of the fields contains full names (e.g. Mary Smith, Michael Jones, etc.) I want the merged document to...
April 28th, 2009 05:49 PM
by Thicklizzie Go to last post
3 124
Suppressing the Open Link box to a mail merged document by [email protected]
Hi all. I'm opening a mail merge document in word from an Access 2003 app, by calling the word object and then opening the document from code. When you open...
April 13th, 2006 07:49 AM
by Peter Jamieson Go to last post
1 205
Suppressing zeros in a mail merge document by Lyn
I am attempting to merge data from Excel into a word document (table). I have the zeros suppressed in Excel. However, after the merge, the word document...
June 18th, 2008 03:40 PM
by Graham Mayor Go to last post
3 140
Supress blank lines by Jan
The data source is a .csv file we receive for a merge form letter. It contains $0.00 in any amount field when no $$$ exist. The data from up to 10 columns are...
March 6th, 2006 03:52 PM
by Jan Go to last post
5 211
Supress Mail Merge Warning by JethroUK
Every time i open a megre document it issues a warning "Opening this document will run the following SQL results........." Anyway to supress this?
October 26th, 2005 05:48 PM
by JethroUK© Go to last post
2 120
Supress text if merge field is null by Laura_Christian
Hi there, I'm having a hard time figuring out how to use if/then field codes in Word for a mail merge. In my address block, for instance, I would like to...
August 8th, 2006 03:46 AM
by Peter Jamieson Go to last post
1 80
Supressing empty lines in Word 2003 during a mail merge by Red Sapphire
Hi all, I know that there is a button somewhere, that leaves out empty fields during a mail merge thus ensuring that you don't get empty lines or spaces when...
December 18th, 2009 03:10 AM
by macropod[_2_] Go to last post
3 132
Supressing in a table by Michele
Is it possible to suppress in a table that consists of 3 columns and 1 row? For example, in Col 1, we have several conditional statements for the mailmerge and...
February 3rd, 2006 05:03 AM
by Doug Robbins - Word MVP Go to last post
1 87
Supressing varying number of rows for each recipient by Albert
I am using Access as my data source. The project is a debt collection letter merge. Each recipent has a different number of items due. The relevant part of the...
September 1st, 2005 03:46 PM
by Albert Go to last post
7 227
supressing warning when opening a Word Mail Merge document from Access by Paul
I'm using the following line of code in Access to open a word document linked to my database with an ODBC connection that populates some Mail Merge fields: ...
March 31st, 2008 08:27 AM
by inge.larsson Go to last post
6 393
Surpress Blank Line by Dave C
I've looked through other posts but can't find a specific reference to what I need to achieve - sorry if I missed it. I have an if statement that prints...
September 2nd, 2008 04:06 AM
by Rich/rerat Go to last post
3 175
surpressing blank lines in address block by cbeck29483
the blank lines in an address don't automatically surpress when I run a mail merge. Is this a known bug? Where can I view the options in effect?
May 20th, 2005 02:10 PM
by Cindy M -WordMVP- Go to last post
1 173
Surpressing blank lines in Advanced Merge by cbeck29483
I've been living with a problem in the address mail merge component of mail merge which has become burdensome and I want to "fix" it: the blank lines in an...
May 20th, 2005 02:10 PM
by Cindy M -WordMVP- Go to last post
1 156
Swapping between 2 tables using if then else by Miranda Gray
I am trying to figure out if I am sleepy and missing an obvious step or if Word doesn't like what I am doing. I have a bilingual document. Based on a single...
December 14th, 2009 07:56 PM
by Peter Jamieson Go to last post
2 130
Post New Thread


Display Options
Showing threads 10041 to 10060 of 11598
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 06:43 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.