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
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 2,680
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 2,461
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 2,644
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 2,898
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 2,096
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 05:11 PM
by Poonam Go to last post
0 2,501
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 12:33 PM
by Poonam Go to last post
0 2,429
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 12:22 PM
by shelfstacker Go to last post
1 3,019
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 01:48 PM
by LotusN Go to last post
0 3,158
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 12:33 PM
by borntorun75 Go to last post
0 2,444
"Individual Merge Letters" Add-On Converts Excel Table to Picture by Barrettsan
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...
August 31st 15 05:30 PM
by Barrettsan Go to last post
0 2,677
Mail Merge Spellcheck by Risleytine
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...
June 12th 15 02:50 PM
by Risleytine Go to last post
0 2,815
How to do arrays with mail merge. by ibbm
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 ...
May 20th 15 06:53 PM
by Jason Smith Go to last post
2 4,643
Copy calculated total from cell in one table to another table by N. Goldberg
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. ...
May 12th 15 04:48 PM
by N. Goldberg Go to last post
0 2,351
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 2,570
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 09:42 PM
by edwards438 Go to last post
0 2,727
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 01:01 PM
by Sam02 Go to last post
0 2,179
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 06:27 AM
by getlinkz Go to last post
1 2,620
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 12:42 PM
by S_G_P Go to last post
0 2,500
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 05:40 PM
by bill koeninger Go to last post
0 2,085
Post New Thread


Display Options
Showing threads 41 to 60 of 12026
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 07:11 AM.


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