The tag has no wiki summary.

learn more… | top users | synonyms

4
votes
2answers
2k views

In Word 2007 how can I set up a repeating section for Mail Merge

In Word 2007, I want to set up a mail-merge template where multiple rows from the data-source will appear on a single page. So, something like this: ---Page-Boundry-------- Header blurb 1 Header ...
4
votes
2answers
12k views

Changing Word mail merge data source locations in bulk?

I've just moved a number of Word mail merge files, and a number of Excel spreadsheets that are the data sources for the mail merges, from a Windows XP computer to a Windows 7 computer, and now all the ...
4
votes
2answers
3k views

mail merge e-mail in Word 2007 with attachment

Is there a simple way to mail merge with Word 2007 and add an attachment? I've searched google, and all results point to pasting in VB code. I want to a small team of novice users to be able to mail ...
3
votes
2answers
2k views

Generating a pdf using data rows from excel and an image as the template with placeholders

I have lots of data rows in excel, each row has columns such as first name, last name, gender...etc. I also have an image as the template, I would like to define some placeholders on it. And then for ...
3
votes
2answers
5k views

Microsoft word - conditional formatting in mail merge?

Is it possible to use conditional formatting in Microsoft Word 2007 Mail merge? I would like it to color the font, depending on the field value, for instance: if "Priority" field equals 1, color the ...
3
votes
1answer
769 views

Word 2007 prompts twice for “Opening this document will run the following SQL command” for Mail Merge

I am trying to figure out why my mail merge in the a Word document is prompting me twice for seemingly two different data sources. Both prompts look like the following: . The first prompt points ...
2
votes
3answers
17k views

Remove mail merge data source from MS Word Document

I am using MS Word 2013. I have a document that, when opened, prompts me with: Opening this document will run the following SQL command: SELECT * FROM C:\somepath\somefile.mrg Data from your ...
2
votes
1answer
1k views

How to do a mail merge with attachments

I'm trying to use MS Word and Outlook 2003 to send a bunch of emails with attachments but apparently this option is not allowed. ¿Any clean way to do this?
2
votes
1answer
878 views

Word mail merge: show or hide table

I'm creating a mail merge document where I need to hide swathes of the document based on a field I have. OK. That's simple enough. {IF {MERGEFIELD My_Field} = "True" "a bunch of text ""}. But one ...
2
votes
2answers
9k views

How to combine several records in a single letter using Word mail merge

I have a long Excel list with data in the following format: A, B, C x, y, z1 x, y, z2 x, y, z3 I want to create a mail merge in Word 11 for Mac in the following style for each x, y , which is ...
2
votes
2answers
5k views

retain formatting from source document in mail-merge

I have set up a mail-marge in Word 2003. The source is a document where each field is a formatted text as the following one: I have different pieces of text to insert. However, when I insert such a ...
2
votes
1answer
1k views

Dynamic row height on Word tables, based on mail-merged contents

I'm working with Word templates which contain nested tables of mail-merged fields. I need the row height of one of the child tables to have a minimum height but be able to expand (height only not ...
2
votes
2answers
214 views

Mail-Merge on Steroids: Can Word 2003 do this?

I have a huge report to put together, made up of over 1,000 smaller, nearly-identical reports. Each report includes: General 1:1 information (basic mail-merge stuff) Lots of text, some of which may ...
2
votes
1answer
420 views

Mail Merge in Microsoft Word with images from Sharepoint

Is there any way of doing a Mail Merge in Microsoft Word 2007 taking data, including images from a Sharepoint site? It's a bit crude, but I've managed to merge text by taking the data off the ...
2
votes
1answer
98 views

Do data sources travel with a particular mail merge document?

Do data sources that you set up (particularly to SQL Server) travel with a mail merge document? In other words, if I set up data sources in a mail merge document on my machine and then save and send ...
2
votes
1answer
2k views

Word 2010 - Mail Merge with Superscript Formatting

I have a user with a letter in Word 2010, built for a mail merge. The source document for the addresses is another Word document. The source document includes addresses that have super-scripted ...
2
votes
0answers
283 views

Outlook 2010 mail merge group

I'm trying to send a personalized email message to a contact group, but I get this error message: "contact groups cannot be selected. you must select a contact group." If I select individual ...
1
vote
2answers
3k views

Microsoft mail merge incorrectly formatting numbers

I am doing a mail merge in Microsoft Word and pulling the data from an Excel spreadsheet. The text is being inserted perfectly, but when I go to insert a number value, the number goes out to fifteen ...
1
vote
3answers
7k views

MS Word 2007 Mail Merge fails on ZIP codes with leading Zeros (eg. 01234)

I have an Excel Spreadsheet with a ZIP code column. For some dumb reason the original spreadsheet I got had all the zip codes stored as numbers, so a ZIP code like 01234 was stored as 1234. Easy to ...
1
vote
1answer
5k views

Mail Merge - Multiple Rows Into One Document

I am trying to do a Mail Merge where I have 200 Franchise Owners, with approximately 1200 staff members who have taken part in an incentive program. I need to send a letter to the Franchise Owners ...
1
vote
2answers
753 views

Conditional Images in mail merge

A previous answer suggested here leads me to the conclusion I can merge images, but without control of the datasource how can I make the image different based upon a field condition? For instance if ...
1
vote
1answer
838 views

Easiest way to print hundreds of same letter with different addresses

There is a long list of names and addresses in CSV format (could be converted to a different). I need to print a hundred of letters with some formatting like: %address% Dear %name%, Blah-blah-blah ...
1
vote
2answers
270 views

How do I split a directory when a field changes in Word 2010?

I'm creating a directory mail merge in Word 2010 using an xlsx file as the record source. One of my fields is "Manager". Most of the fields will be different on every line, but Manager will be ...
1
vote
1answer
1k views

Inserting rows from an Excel spreadsheet as paragraphs in a Word document

I am trying to put the results of a questionnaire in a Word document. The questionnaire is completed using a web application, and the results are stored in a database. The letter needs to only ...
1
vote
1answer
2k views

Custom Sender and Reply-to in MS Office email mail merge

I'm trying to set up a mail merge that will be sent on behalf of another account. With a reply-to address set to be a completely different account in an exchange environment. Everything I've read ...
1
vote
1answer
240 views

Is there any way I can fix a word header to a specific height?

I'm making a template for a letterhead, and I've put in mail merge fields for name/address. Some of my address records don't have some fields like name or address line 2. When these records are used, ...
1
vote
1answer
17k views

Word 2010 mail-merge <<Next Record>> not working

I'm creating a mail merge in Word 2010. I have a simple XLSX which looks like this: Name Jack John Tammy Tim Sam Jill I have started the mail-merge with a blank Word document and added one field, ...
1
vote
1answer
357 views

How to do mail merge in Gmail and/or Mac with attachments?

I need to send a template email to about 700 email addresses, and need to personalize each email for the recipient's name, position, and employer. In addition, I have one attachment that I need to ...
1
vote
2answers
128 views

Mail merge, using my own fields: .xls, word 2003 xp pro

Office Version:Office 2003Operating System:Windows XP 0 I have a Word doc that looks like this: <<PracticeName>> <<PracticeAddress>> <<PracticeCitystate>> ...
1
vote
2answers
2k views

How do I do a mail merge that includes images? (Maybe in Word 2007)

I am trying to find out the practicalities of doing a mail merge when each “record” to be merged on includes some images. I need to: print letters And envelopes Both the letters and the ...
1
vote
1answer
330 views

How to use data contained in several related database tables for a form letter?

I want to create a form letter with LibreOffice Writer. The data is contained in a LibreOffice Base database, in several tables. I followed the guide Creating a Form Letter. It seems that I can only ...
1
vote
1answer
552 views

How do I create a nicely formatted directory with mail merge in Microsoft Word 2007?

I am trying to create a directory with mail merge in Microsoft Word 2007 and I hit a few issues. «Forename» «Surname» «Address_Line_1» «Address_Line_2» «Address_Line_3» «Address_Line_4» «Postcode» ...
1
vote
2answers
331 views

How can I do a batch find replace?

I'm writing a piece of software which requires the creation of a number of nearly identical blocks of code that only vary in a few locations which need to be replaced by a unique value for each ...
1
vote
1answer
2k views

How to mail merge a hyperlink in Microsoft Word or Publisher 2010

I am trying to do an e-mail merge in Microsoft Publisher 2010 (which appears to do mail merging like Microsoft Word) and I'm wanting a merged email address to automatically be hyperlinked in the ...
1
vote
1answer
872 views

MS Word mailmerge using Thunderbird

Can this be done?
1
vote
1answer
502 views

Is it possible to have cascading template updates in Word 2007?

This is potentially a very simple question, but I'm trying to create a letterhead template for work that will be used on dozens of different mail merge letters. The letterhead is saved as a Word ...
1
vote
0answers
12 views

Need to Selectively Merge Records to Different Places in a Word Directory-type Document

My company regularly creates "rosters" (or directory documents) that list contact info for people with roles for a trust fund. The rosters have a certain format -- people with an "Administrator" role ...
1
vote
1answer
29 views

Incorporate Excel formula Names in Word Mail Merge document

I have an Excel document with numerous constants defined in Names. For example: ------------------------------------------- / Edit Name ? X \ ...
1
vote
1answer
56 views

Mail merge - Change data in source from merged document

I have an excel file with thousands of records. I want to mail merge and build a directory which I have done. The problem is when directory was built I noticed that there were some errors. I want to ...
1
vote
1answer
102 views

How do you create a mail merge from excel in microsoft word and then overlay multiple images on top of each other

I know how to insert images into mail merge in word one at a time and have them next to each other, but I want to mail marge three images each onto a printable label. The first image is a background ...
1
vote
0answers
125 views

Is there an easier way to add multiple Mail Merge fields into separate table cells?

I have to create a relatively large Microsoft Word template file that will contains a couple of hundred Mail Merge fields. Some of these are duplicate fields but that isn't too much of an issue. I ...
1
vote
0answers
93 views

Word 2007 Merge Document - creating only one letter to recipient for multiple records

Record 1: Mary Smith, Barney Record 2: Mary Smith, Pebbles Record 3: Mary Smith , BamBam Record 4: Bill Shoe, Rocky For example, Mary Smith is listed in my database 3 times with 3 different ...
1
vote
1answer
1k views

Changing a Mail Merge Word document to point to a new datasource?

I am trying to change a MSWord 2013 mail merge document so that it points to a MS SQL DB rather then the original MS Access DB which just linked to the SQL DB tables. Basically I want to remove Access ...
1
vote
0answers
36 views

Merge Mail Directory

I am using Word 2010 and trying to implement into a cover letter a listing with all the recipients of the letter. I am using the Mail Merge (Mailings > Start Mail merge > Directories). The problem is, ...
1
vote
0answers
127 views

Word mail merge using excel column to select layout from other documents

I have about 30 word documents. There is 1 document that is the main one setup to use for mail merge. There is a column in the recipiant list that is meant to select the document that will be used ...
1
vote
1answer
38 views

Display text only in a merge master document (not in the resulting merged document)

I'd like to put some instructional text in a Word 2007 merge master document, but upon merging, not have the text present (or at least, not visible). The text won't print, because it is hidden, but ...
1
vote
2answers
2k views

How to set mergefield to show long date format?

How can I make Word 2012 display German date format in mail merge? { DATE \a "dd.MM.yy" \ * MERGEFIELD } returns 15.02.2012 for today, 15. Februar 2013 however is what I want.
1
vote
0answers
654 views

Excel/Word on MAC - includepicture containing url

I have the following: A excel spreadsheet with names and url's to a QR code, each in a column of the spreadsheet. The url returns a jpeg picture of the QR code. A word doc where these names and ...
1
vote
1answer
552 views

What's the difference between mergefields, field codes, placeholders and content controls in Word DOCX files?

I'm struggling to work out the differences between mergefields, field codes, placeholders and content controls in Word DOCX files. As part of a server-based system to generate 'mail merge' documents ...
1
vote
1answer
421 views

Put variables into Microsoft Word

Example I have a letter. I have to address it to 10 people. Each of the 10 people will have a unique info which I'll need to input in. So it's like Dear X, Check out Y! I'll like to pull the info ...