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
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 601
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 606
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 282
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 4,550
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 801
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...
1 342
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 492
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 886
How can I add OMR to a word Document by Elinus
I have a Mail merge document that I need to Add Optical Marks to so that my automatic letter stuffing machine can tell how many pages there are in each document. THE OMR can be the underscore character.
August 12th 16 01:07 PM
by Vladan Majerech Go to last post
4 2,926
Mailmerge with IF by Pat88
I have an excel data sheet and like to use MERGEFIELD and IF to check if a part of the value is in the excel field. For example i have the field "participants" with the following values: Thomas;Philip;Patrick I like to check with the following command if the Name "Patrick" is in this field: {...
June 29th 16 02:38 PM
by Pat88 Go to last post
0 1,052
Mail merge - how do I know it has finished? by GarryB66
I am kicking off a Word Mail Merge from an Excel macro. The code looks like this - With objDoc.MailMerge .Destination = wdSendToNewDocument .MainDocumentType = wdFormLetters With .DataSource .FirstRecord = wdDefaultFirstRecord .LastRecord = wdDefaultLastRecord End...
May 31st 16 11:57 AM
by GarryB66 Go to last post
0 1,422
Mailmerge - some records with photos, some without by Smitty777
I am creating a company directory. Some people in the directory have photos on file, some do not. In my directory template I have the line { INCLUDEPICTURE { MERGEFIELD "Image_URL" } } where "Image_URL" is the column in my excel file that has links to profile photos. If no photo exists, the...
May 19th 16 09:24 PM
by Smitty777 Go to last post
0 1,098
Mail merge formula by Nicci
Hi, I am trying to mail merge a letter from data in a spreadsheet. I need to be able to find a company name and bring back multiple employees from that company. I can bring back the first person it finds for that specific company but not multiple names on the same letter. Does anyone know the...
May 12th 16 09:33 AM
by WelshGasman Go to last post
1 1,209
Problem With Saving Newly Created Mail Merge Documents by Jenn68
I am having a significant problem with an Excel VBA based application that uses a processed excel database as source for mailmerged reports. Depending on the user's input any number of different reports can be created based on the data in the database. In Excel, based on the user's selection(s) a...
May 10th 16 05:07 PM
by WelshGasman Go to last post
2 1,073
Mailmerge fails on one computer by WelshGasman
Hi all, I have not tried every computer in the office, but I have tried 3 and they all work, and one particular one does not, and I am attempting to find out why as the person using this computer is meant to carry out the this particular mailmerge. I created a mailmerge document in Word 2007 and...
May 10th 16 04:53 PM
by WelshGasman Go to last post
0 951
Mail Merge - Very Urgent by Poonam
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:
February 20th 16 06:11 PM
by Poonam Go to last post
0 1,319
Mail Merge by Poonam
We maintain MIS in excel for sending out letters on behalf of Bank for people who have taken loan. Therefore there is one Borrower and 2 to 15 Co-Borrowers, who have same account number and same outstanding amount and the excel that we receive from Bank have following fields: A B C D E F...
February 14th 16 01:33 PM
by Poonam Go to last post
0 1,179
MailMerge Section Breaks? by shelfstacker
Hi, Word2010 - when creating a mail merge, it seems to insert "section breaks Next Page" I want it to insert "section breaks Odd Page" (instead). OR I want to search/replace all "section breaks Next Page" with "section breaks Odd page" In case I've misundestood this - I beleive a "section breaks...
February 5th 16 01:22 PM
by shelfstacker Go to last post
1 1,297
Formatting problem of Mailmerge data in Word by LotusN
Hi all, after searching both at this and and other forums to no avail I decided to post a question. I have a Mailmerge set up from Excel (directory) and it populates invoices and it produces one invoice per family. It has a different number of family members for each invoice but everything works,...
November 16th 15 02:48 PM
by LotusN Go to last post
0 1,832
VBA : navigating to the nth record of a .Datasource before executing the mailmerge by borntorun75
Hi, I'm writing some VBA to complete a mailmerge and have got it working more or less as I want it. I'm looping around the DataSource, incrementally setting the .FirstRecord and .LastRecord With ActiveDocument.MailMerge .Destination = wdSendToNewDocument ...
November 12th 15 01:33 PM
by borntorun75 Go to last post
0 1,376
Post New Thread


Display Options
Showing threads 1 to 20 of 12003
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 09:02 AM.


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