A Microsoft Word forum. Microsoft Office Word Forum - WordBanter

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 » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Post New Thread
Threads in Forum : Mailmerge Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
Mailmerge Skips First Record by pm84280
I have a mailmerge using Excel/Word 2007 and there are no errors during validation. However, when activating the mailmerge the second and third records get sent but the first does not. There is a skipif in the first which should return a blank. The second and third are populated under the...
April 9th 15 09:40 AM
by pm84280 Go to last post
0 3,006
Exporting specific fields from mail merge to excel by edwards438
I have a Microsoft word mail merge with around 11 fields, I wish to export 2 specific fields into an excel spreadsheet, is this possible and how would I go about doing this? I use Windows 7, Microsoft Word 2007 and Microsoft Excel 2007 Please assume I have very basic skills in relation to these...
February 24th 15 10:42 PM
by edwards438 Go to last post
0 3,039
Format Envelope in mail merge by Sam02
Hi I am trying to learn mail merge in word 2010 I can get word to save a list of recipients and then place them on the envelope The problem I then have they are always at the bottom of the envelope I know I can drag this address block anywhere on the envelope But is there not a way I can make...
February 12th 15 02:01 PM
by Sam02 Go to last post
0 2,479
Customised Mail Merge .... by callsidd
Hi Guys !!! Hope all of you are well & enjoying good sound health ... I've a serious problem & once again I'm on your board with believe that my issue will be solved I'm working in a organization where I'm supposed to send almost 100 letters to the clients whom have been charged different charges...
December 2nd 14 07:27 AM
by getlinkz Go to last post
1 3,022
Address Formatting Mail Merge by S_G_P
Hi, Iím trying to produce a mail merge that is linked to a list of Addresses - 7 fields in total all of which are in CAPITALS and can included a number or be blank. In Excel terms Iím trying to replicate something like the PROPER function. I would like the address formatted so that the start of...
November 28th 14 01:42 PM
by S_G_P Go to last post
0 2,879
mail merge using if compare and ranges of values by bill koeninger
Help! I am working on a document that needs to fill in text that is dependent on amount ranges in a single mergefield. I have three ranges of values and text associated with each. The ranges are 0 - 417000 417001 - 650000 650001 and higher I can get two of the three to work but not all three at...
November 14th 14 06:40 PM
by bill koeninger Go to last post
0 2,400
adjusting envelope address for a windows envelope in mail merge by Michael Jones
I need to know how to adjust envelope addresses for a windows envelope in mail merge
October 17th 14 03:56 AM
by Michael Jones Go to last post
0 2,270
Display mail before sending in mail merge by Balamurali
Hi, Using word 2010 and outlook 2010, i have tried sending mail through mail merge. My question is, Can we able to see the mail before sending? That is after clicking finish and merge mail sends as per my data table in excel. Its not even kept in my outbox? without reviewing or adding attachment...
September 23rd 14 09:08 PM
by Balamurali Go to last post
0 2,247
custom merge fields by ram_gummadi
Hello, How do I create custom merge fields? I have a document with custom merge fields (Insert Merge Field) and I want to add a custom merge field. I am new to Microsoft word mail merging. I want to map these custom fields to the data file by using edit recepients. Thanks for your help. Ram
September 4th 14 05:20 PM
by ram_gummadi Go to last post
0 2,213
Word 2003 mail merge-can you auto save letters individually? by [email protected]
I have a monstrous mail merge to do where I have to individually save each letter with the title in a certain format. (It needs to contain a reference number) I have literally SEVEN HUNDRED letters to save and it's going to take me forever to do it one by one! Does anyone have ideas on an...
August 29th 14 05:41 PM
by mutludeli Go to last post
2 4,801
Date format in merged document by Jackpot
I have merged my data from an excel file into the word document and the date is being changed from DD/MM/YY to MM/DD/YY. How do I stop it from changing?
August 19th 14 07:09 AM
by Jackpot Go to last post
0 2,413
Word Mailmerge IF..THEN..ELSE by muftib
Hi, I'm trying to use If,then,else in a letters mailmerge to do the following: if the greeting field is blank, insert Title and Lastname fields, otherwise insert the greeting in the greeting field So: {IF {MERGEFIELD Greeting} = "" "{MERGEFIELD Lastname}" " {MERGEFILED Greeting}"} this works...
August 11th 14 06:02 PM
by muftib Go to last post
0 2,282
Merge using Excel...formulas not recalculating when data source is edited by cplettner
Hi all this is my first post on this forum. I'm trying to do a rather complex mail merge that uses an excel file as the data source. I multiple merge fields that are dependent on the value of other merge fields and some calculations that the excel file does. For example... I have a...
July 29th 14 11:04 PM
by cplettner Go to last post
0 2,262
dynamically formatting text color in mail merge by xray
Hi, I want to create labels but I want the text color to change based on data in the excel spreadsheet. For instance, I have a row of data with a column that contains a color such as "blue" or "red" and I want the label text color to be that color. Is there a way to do this using MS Word...
July 11th 14 09:02 PM
by Jazzman19 Go to last post
3 12,702
intelligent mail barcodes by Frank
We are trying to place an intelligent mail barcode in mailmerge using word 2007. Is there someone that can help us with this problem.
June 30th 14 04:45 AM
by hongdida Go to last post
6 5,445
How do I get postnet bar code using the mail merge feature? by Mitch
I can't create a postnet bar code on envelopes when I use the mail merge feature. I am printing out 100 letters with envelopes and would like to use the postnet bar code feature on the envelopes.
June 27th 14 09:44 AM
by arronlee Go to last post
4 4,023
2 Attachment(s) Mail Merge code for resizing pictures by silk74uk
Hi, I currently have a Word 2007 Doc that uses mail Merge to add 2 images using the attached (Mail Merge 1) mergefield. I want the two Images to be resized to say 8 x 6cm and for the images to then appear next to each other as per the attached (Mail Merge 2). Currently they autofit to the width...
May 23rd 14 03:52 PM
by silk74uk Go to last post
0 2,297
Mail Merge and Autocorrect by redzan
I have a mail merge that adds in doctor's names from an excel sheet into a word file. The excel sheet does not have the doctors credentials only the first and last name. I have entered the credentials in autocorrect so if John Smith is typed it will autocorrect to John Smith, MD or whatever the...
May 22nd 14 09:04 PM
by redzan Go to last post
0 1,789
All fields not populated by keeylyme
Hi guys, I'm in a bit of a time crunch so apologies if this has already been answered. I'm using Outlook 2007's categories to do a mail merge in Word 2007 and everything is going fine until I get to the step to populate the labels. My first line is fine and the last 2 labels in the final row are...
April 8th 14 04:33 PM
by keeylyme Go to last post
0 2,118
Using a formula in mail merge by Rounder
Hi, New to the forum as I am looking for an answer on using one field to change another. Not the sharpest tool in the shed so would appreciate any help. I have created a merge document to send to tenants when it is time to renew their lease. If they don't renew the lease they go to a month-to-month...
January 30th 14 07:12 PM
by Rounder Go to last post
1 2,433
Post New Thread

Display Options
Showing threads 81 to 100 of 12043
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 On
HTML code is Off
Forum Jump

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

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright ©2004-2022 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.