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
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,498
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 1,834
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 5,389
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 1,478
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 1,760
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,273
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 1,560
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,025
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 2,804
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,619
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,104
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,194
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,470
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 6,078
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 7,150
Round Down Merge field by Niall
Hi I have got the following field in a mail merge document: {={MERGEFIELD Annual_Rent}/4} I am trying to round down the result to 2 decimal places and tried: {=ROUNDDOWN({MERGEFIELD Annual_Rent}/4,2)}
August 19th 13 09:05 PM
by 4zelka4 Go to last post
2 3,093
NEED HELP !!!!! Add another formula to the Mail Merge Forumla IF by Adi.Master
Hi.. I am new to this forum and have one question thats been bugging me since a month... hope to get a satisfying solution... I have a template which inputs data from an excel sheet.... I have entered the IF formula as follows: {IF {MERGEFIELD State} = "A" "My Paragraph 1" "{IF {MERGEFIELD...
August 18th 13 11:34 PM
by Adi.Master Go to last post
0 1,171
Multiplying a mail merge formula by Grazza215
Hi guys, Really hoping someone can help I've been trying to get this to work, but seem to be missing a trick. I am using a series of mergefields (linked to a CSV data sheet) and have this working fine: { = { mergefield "debits_H"} - { mergefield "EXPCT_AMT2"\#,0.00 } + { mergefield...
August 13th 13 04:42 PM
by Grazza215 Go to last post
0 1,568
Question
Insert variables into mailmerge documents by Force
I have the following code that I am attempting to print labels with. The code to identify an individual will be the same for all labels. What I am using the mailmerge for is to cycle through the various labels that we are creating. I am trying to print out the variable finalOut with a CFLR at the...
August 5th 13 06:00 AM
by Force Go to last post
0 1,123
Getting a sentenced inserted into a letter. by Greg D Isringhaus
I am needing to know how to make a rule that has 3 different variables. I need a rule to enter just one sentence. Basically need a formula that reads: If "Exception" = "Y" and "Disease" = "Y" and "Age" = "Y" then "paragraph to be inserted." I just can't figure this out, I'm sure that it is...
July 23rd 13 05:52 PM
by Greg D Isringhaus Go to last post
0 1,158
Post New Thread


Display Options
Showing threads 61 to 80 of 12017
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 04:01 AM.


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