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

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

We are trying to place an intelligent mail barcode in mailmerge using word 2007. Is there someone that can help us with this problem.

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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