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
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 2,348
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 13,014
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 5,610
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 4,155
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 2,406
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,880
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 2,214
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 06:12 PM
by Rounder Go to last post
1 2,550
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 02:22 PM
by Mr Penguin Go to last post
3 7,461
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 07:15 PM
by Shakeel Akhtar Go to last post
1 2,251
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 10:03 PM
by kckay Go to last post
1 2,462
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 09:41 PM
by Animosity Go to last post
0 1,942
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 08:38 PM
by School Counselor Go to last post
0 2,374
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,763
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 2,356
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,838
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,880
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 2,163
Custom Subject Line from Excel Data by Kiran
Hi, I need to use mail merge to send multiple e-mails to different individuals for which subject line needs to be pulled from a excel column.My excel file name is sample.xlsx. The data in the sheet is as below, the issue column would be the source for subject.Request assistance in getting this...
August 22nd 13 01:38 AM
by KiwiRyu Go to last post
2 7,379
Conditional Formatting of background and text by KevinMoses
Greetings all I have created a mail merge document from a spreadsheet. One of the merge fields captures Residual Risk Ratings. I am trying to create an IF statement in order to use the following conditional formatting: Extreme (Pink shading, white text) High (Red shading, white text) Medium...
August 21st 13 01:56 AM
by K R Go to last post
2 8,176
Post New Thread

Display Options
Showing threads 141 to 160 of 12085
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:43 AM.

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