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: {...

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...

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...

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...

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...

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...

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:

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...

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...

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,...

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 ...

Hi folks! Thank you for taking the time to help. I am working with a client who wants to generate individual Word document "letters" for each of his constituents. The Individual Merge Letters Add-on created by Doug Robbins and Graham Mayor did a fantastic job of splitting the merged Word...

Hi all, I've read over lots of info on this forum and others about how to apply spellcheck to a document after a mail merge (Ctrl A/Select All, and then unchecking the check box under languages.) For some reason this is not working for me. It seems to be an issue with the "Selecting All" portion...

I have an excel spreadsheet with the list of accounts and the description types that looks something like this: Account Type 12345 1A 45678 1B 78912 1A 55679 2 24567 ...

I am using Graham Mayor's mail merge utility "Many-to-One" to generate several hundred purchase orders. Each purchase order has a varying number of items for which the total cost is calculated in the last row of the table. I need to put the total from this table into a cell on a summary table. ...

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...

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...

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...

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...

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...