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
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 1,843
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 1,796
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 11,371
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 4,633
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 3,383
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 1,777
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,331
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 1,677
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 1,993
Creating a Table of Contents inside a Directory Mail Merge by odudley
My current dilema is that I cannot figure out how to enter a TOC into my mailmerge. I have an introductory page that has a Title and TOC, then a pagebreak, then the directory. The table of contents is based on a field in the directory. The directory function is causing my title, TOC and...
January 30th 14 03:22 PM
by Mr Penguin Go to last post
3 6,018
Naming issue on saved mail merge documents by Shakeel Akhtar
Hi Having now learnt how to save mail merge documents as separate files, is there a way of naming each individual file based on a combination of the merged fields (e.g. First name, Surname and ID)? Am using Word 2011 on a Mac (OX 10.8.5) Thanks
December 22nd 13 08:15 PM
by Shakeel Akhtar Go to last post
1 1,686
Spell Check and Mergefields not working by kckay
Using Office 2007. I have a project to enter data in an Excel workbook and then generate a Word document from the Excel data. This is working wonderfully and is stable. Unfortunately, I found that the Mergefields in the Word template are exempt from the Spell Check tool within Word. I have...
December 15th 13 11:03 PM
by kckay Go to last post
1 1,928
MailMerging for Labels by Animosity
I have been perusing threads as well as the internet, but I haven't found a definitive answer to my problem. Basically, I am printing labels for definite oil reservoirs in an industrial environment. I image that because of the conditions, I'll have to remake these labels at some points, and I would...
December 3rd 13 10:41 PM
by Animosity Go to last post
0 1,424
Mail Merging into PowerPoint by School Counselor
I need to take an Excel file of informative data and make a PowerPoint presentation with it. There needs to be an individual slide for each respondent's answers with the database. I am well versed in how to use the mail-merge feature in Word and can create pages in Word like the slides I hope to...
November 21st 13 09:38 PM
by School Counselor Go to last post
0 1,763
Editing header/footer in merged doc by libFL
I have a long merged document that contains a header and footer. I am trying to delete the header/footer in the merged doc but it will only change the first page. Is there a way to do this, or do i have to change it in the source document and remerge?
October 27th 13 12:22 AM
by solivitaretha Go to last post
1 2,200
Dynamic Subject Line Email Merge by MHutcheson
I have a Word 2010 document linked to an Access 2010 data source. When a user clicks a button in Access, the Word document loads and performs a email merge using the below VBA code: Private Sub Document_Open() With ActiveDocument.MailMerge .Destination = wdSendToEmail .SuppressBlankLines =...
October 7th 13 04:05 PM
by MHutcheson Go to last post
0 3,072
email directory by nadja
Hi, I've created a mail merge (directory) which I would now like to send by email. The merge works perfectly fine as I'm able to finish the merge to individual pages or print. But when I click on "Send E-Mail messages" I get the error message "You cannot send catalog created by merging documents...
September 11th 13 01:43 PM
by nadja Go to last post
1 1,809
LINKing image using a conditional parameter by Bold Creature
!!!SOLVED!!! Hi, I need to merge three images (coloured circles) into a file, depening on a status in the data: - red circle if value is RED - amber circle if value is AMBER - green circle if value is GREEN I found how INCLUDEPICTURE allows me to insert images in Word, but how do I use the IF......
September 4th 13 09:17 AM
by Bold Creature Go to last post
0 1,276
2 Labels per record by PuffBunny
Hi (First post - please be kind) I am trying to create a series of mail merge labels for my movie database (in excel) and want to create two labels per movie - one to go on each side of the DVD sleeve. Label one is to include general data - such as Title, Genre, Cove image etc Label two is to...
August 27th 13 10:54 AM
by Ursul Go to last post
1 1,340
Red face
E-Mail Merge to Multiple Recipients by Vega10
I could use some help. I am trying to complete a mail merge via email and I would like to send the email to more than one person. For instance I am sending an email to the employee but I want to include the manager on the same email message. Is this possible? If so, how can I do this? I have tried...
August 22nd 13 11:16 AM
by Ursul Go to last post
1 1,634
Post New Thread


Display Options
Showing threads 61 to 80 of 12022
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:29 AM.


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