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
If Then Else = Fail by MP1985
Never had this big a struggle with if then, but then I've never introduced a second variable. This works fine and dandy: { IF { MERGEFIELD f3 } = "Y" "{ MERGEFIELD f18 }" "{ MERGEFIELD f2 } (If party is a child, insert this name, if not insert that name). It's when I go for two conditions to...
February 19th 18 01:52 PM
by Charles K. Kenyon Go to last post
2 37
Printing on a postcard two sides using mailmerge by Anu
Hi, I already have the premade with blank information post cards. I am using mail merge to print the information on one side. I have to print the address on the back side of the postcard. How do I do it? I have seen several posts on this forum but could not find a solution. I am using word 2013....
February 16th 18 09:08 PM
by Charles K. Kenyon Go to last post
1 132
1 Attachment(s) Mail Merge Multiple data from Excel...Help!!!!!! by nicole327
Ok, so I am trying to send out letters to students showing them how many missing assignments they have. I want to transfer this information using a mail merge. Is this possible? Some students have 2 some have 4 or 5. I want to transfer what assignments they are missing and then have it move on to...
January 19th 18 05:10 PM
by nicole327 Go to last post
0 71
Selecting which sheet to use from Excel VBA by BAC
XP pro, Office 2003 pro I am trying to automate a mailing from multiple Excel workbooks. Even though I have only 1 worksheet in each book, my routine still pauses waiting for me to select the worksheet before completing the merge, How do i tell Word to continue, using the only worksheet there,...
January 4th 18 07:41 PM
by RaRdEvA Go to last post
6 1,821
Format number with either 0 or 1 decimal place by FiFo
Hi I am trying to do a mail merge where I have no access to edit the original data. I have a field that currently sits to 2 decimal places but I want the figure to pull through with either no decimal place or 1 if it is not a whole number. I have tried using #.# which works for those with a...
October 9th 17 11:37 AM
by FiFo Go to last post
0 445
Insert page break in mailmerge using conditional rule by cody5679
Hello, I need help creating a statement to insert a page break in my mail merge based on conditions such as the name changing on the record set. I've seen examples on this weekend from back in 2005 but I couldn't get any of it to work in Word 2017. I need help!
September 22nd 17 10:06 PM
by cody5679 Go to last post
0 304
Mail Merge 2000+pages by Gazzaman22
Hi Guys Im new here, But found this site through a search. I dont know if its possible but i have a mail merge document with over 2000 pages, my printer has the option to staple, I'd like my document to staple every 3 pages together. We are using word 2010, Does any body know it this is possible...
August 31st 17 10:40 AM
by Gazzaman22 Go to last post
0 408
Thumbs down
Creating Labels Over 3-Up Image by dEaF TO LiGhT
Hi, I'm pulling my hair out trying to do something that should be simple, but is turning out to be difficult. I have these name badges I need to create that are white with a blue logo on top. I included a sample (with the logos blurred out) to give you a visual. https://ibb.co/cSs3H5 Basically,...
July 24th 17 09:28 PM
by dEaF TO LiGhT Go to last post
1 433
\*DollarText with Large Values by Hulan
Hello, I need to make a mergefield that returns a large value display as text. I have read and tried every single response on this site, as well as the sites of the contributors where possible. I am still unable to make this work. When I try the suggestion below, (both copied and typed manuallY),...
June 29th 17 03:24 PM
by Hulan Go to last post
0 414
Sum of two fields with possible blank option by Angie O.
Hi- I'm trying to add two mailmerge fields that are dollar amounts. However, each record may only have one field, not both. How do I create a formula for a field to add the amounts when one might not even be there? Thank you!
June 27th 17 07:36 PM
by Angie O. Go to last post
0 246
How do I format a phone number in a mail merge field? by Halley
I tried the following, and it did nothing. I tried a few other variations, but they all gave me errors. { MERGEFIELD "PHONE" \"(###) ###-####"}
June 24th 17 08:43 PM
by Varda Go to last post
9 7,185
Mailmerge failure by bobgrand
Hello all, I am using Office 2013. I need to make item identification labels for bins we have on our shelves. I created a list in excel (.xlsx) of 200+ items that I need to merge into word for my label template. I start with a fresh blank document. I then proceed to Step-by-Step Mailmerge wizard....
June 12th 17 06:16 PM
by bobgrand Go to last post
0 323
Delete entire line base on a returned value by Nightofthehawk
I've read a number of posts to remove a line based on a no value being returned but can't find out how to remove based on a specific value being returned. e.g. I have a merge line below where 'UK Equity' is text UK Equity { =100* { MERGEFIELD BenchUK2 } \# "0.0%" } Currently, if the value...
January 27th 17 06:08 PM
by Nightofthehawk Go to last post
0 3,525
Mail Merge Conditional Formatting with Colour by JO GS
Hi all, I am trying to perform a mail merge into word using data from excel. The data is exam target grades and review grades which are colour coded according to progress made (red, amber, green and so on). Is there a code I can use to make the colour coding appear in the word document? The...
December 5th 16 11:17 AM
by JO GS Go to last post
0 1,558
1 Attachment(s) Conditional formatting numbers with more than by k11ngy
Hi Tried many times and got as far as this but no success I have added image with my formula but does not work for me, sure its wrong, just need some advice? Thanks Steve
November 29th 16 05:34 PM
by k11ngy Go to last post
0 907
1 Attachment(s) How can I apply conditional formating to a Word mergefield? by BruceAus
I would like to able to change the text colour in a mergefield based on the returned value. For example, if the returned value is "A" I would like to change the text colour to Yellow. Is this possible
November 29th 16 04:03 PM
by k11ngy Go to last post
3 5,641
If Statements by jadelouiselaird
hi could someone please help me with an if statement heres the scenario example: DESC UNITPRICE BLANK 0 TSHIRT 0
November 11th 16 10:00 AM
by jadelouiselaird Go to last post
0 1,518
Decimal issue for percentage x currency /100 by [email protected]
I cannot figure out why my decimal is being messed with for the following mail merge math: 5.375% x $8,213.28 = $441.46 (is what the correct match should be) My merge fields a { Mergefield Interest Rate } x { Mergefield Balance } = {= { Mergefield Interest Rate } x { Mergefield Balance }/100...
November 10th 16 11:08 PM
by [email protected] Go to last post
1 1,029
1 Attachment(s) Mail Merge Question by mklindquist
I'm working on a mail merge to create a letter. It includes a table within the letter. A student can have 1-many rows in the table depending on the aid they are receiving. What I am trying to do is list some date ranges for the column headings and then below is the amount of aid per each type of...
October 27th 16 05:58 PM
by mklindquist Go to last post
0 1,272
automatic future dates by emismile
Hi, I have been asked to produce a letter in mail merge that has a response due date within it (2 weeks from day of printing), unfortunately the database that I am using I cannot calculate it and add it as a new field as I cannot change the date within it. Is there any way to calculate a date...
August 24th 16 10:45 AM
by emismile Go to last post
0 1,743
Post New Thread

Display Options
Showing threads 1 to 20 of 12012
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 12:31 AM.

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