The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
20 views

Mail Merge using mutiple fields/next record

I am trying to merge the following: {MERGEFIELD Signer} Date Page 2 {MERGEFIELD Payername} {MERGEFIELD Number} {MERGEFIELD Description} {MERGEFIELD Year} PB If the client has multiple Payer ...
0
votes
1answer
24 views

Macro to merge data on to template

I am attempting to basically do a mail merge in Excel. I would like to take employee data from one Excel worksheet and populate fields on an Wxcel template. So far I have written code to open the ...
0
votes
1answer
28 views

mail merge to separate documents with filename based on Merge field

I'm doing a mail merge from a Access database and I'd like to make many documents from the mail merge, instead of just one. I found a macro that lets me split the merged document after it's made, that ...
0
votes
0answers
35 views

How do I turn html tags in word to formatted text

I'm trying to make multiple documents using mail merge and an access database, but there is one field where in Access I have it saved as rich text. I need it as rich text because it's a single field ...
0
votes
2answers
155 views

Mail Merge Multiple Rows into one document

I have an excel file with different fields in each column: Field 1__ | Field 2__ | etc. F1 Item 1 | F2 Item 1 | etc. F1 Item 2 | F2 Item 2 | etc each field has a different number of items in it. ...
0
votes
0answers
15 views

Serial printing on LibreOffice Writer is not working

I have written this document and linked the corresponding fields from a LibreOffice Calc database (spreadsheet) correctly, and when I try to print it I am being prompted about "Serial printing" the ...
1
vote
0answers
30 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 ...
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 ...
0
votes
2answers
614 views

Mail Merge, Split, Protect, and E-mail Word 2013 Document

I have created the perfect form for time sheets at work. My goal was to mail merge the pages with personnel data. Then protect the document with a password so people don't accidentally change the ...
0
votes
3answers
143 views

How do I stop a mail merge from adding zeros to the end of amounts of currency?

I am using an excel spreadsheet as my data source in a Word document mail merge. I have formatted the amounts in excel as currency with 2 decimal places. When I complete the merge, the amounts have ...
1
vote
1answer
71 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
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 ...
0
votes
1answer
81 views

Mail Merge using the Data Bar Conditional Formatting

I am creating a mail merge which produces customized reports for each student. The content of the word document contains a bar which is marked off in units from the lowest possible to highest ...
1
vote
3answers
12k 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 ...
0
votes
1answer
502 views

Removing carriage returns from a mail merge field in Word

I have a mail merge field called, «ADDRESSLINE2» My data is bad how do remove the carriage return from this merge field.
1
vote
2answers
185 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 ...
0
votes
0answers
83 views

Word 2010 Mail Merge multiple IF statements

I'm at a lost. I haven't used the IF statement in a Mail Merge since 2003 and I'm must be missing something. I have a field called Type if Type="Tax" then it should insert a sentence about taxes if ...
0
votes
1answer
84 views

What should I do with the newlines in this CSV file so it will import properly into a database or spreadsheet?

I have a .csv file which was exported from a proprietary electronic health records database system. I was a subscriber to their service but upon ending my subscription this is how I get to keep my ...
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 ...
1
vote
0answers
105 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
78 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 ...
0
votes
1answer
138 views

MS Word Mail Merge: Validate Data

Is it possible to implement validation rules in a Word mail merge? I want to set up the Word file so that if a given test fails, Word will take some action when attempting to complete the merge. ...
0
votes
1answer
703 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 ...
0
votes
0answers
110 views

How do I Mail Merge from a SQL DB to Word 2013 with a date filter?

I have a SQL database view that returns the data I need for my mail merge. This data needs to be filtered by a Date Range. i.e. >1/1/2014 and <3/1/2014 I have attempted to put it in the filter ...
0
votes
0answers
221 views

MS Publisher 2013 mail merge - date field in excel file format issue

The date field in the source Excel file is formated in long format, 23 April, 2014. But in the mail merge results from Publisher 2013 it goes to 2014-04-27 00:00:00. The format control in the ...
1
vote
0answers
34 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, ...
0
votes
0answers
86 views

Publisher catalog merge: How can I make the catalog area follow the inner/outer margins

I am using MS Publisher 2013 to create a brochure. It has two-pages layout with a greater margin on the inside so there is extra space for the binding. I am using catalog merge to populate a lot of ...
0
votes
0answers
32 views

Word 2010 Mail Merge

I have an Excel file with 4 Columns: Client_ID, Name, Date, Item bought. I have to use this data base to create a mail merge that has a table. This table has date, items that are available in the ...
0
votes
1answer
93 views

Suggestions to make Outlook mail merge quicker

I am using Microsoft Publisher 2007 to create Newsletters and 'Mail Merge' them to Outlook 2007. The newsletters consist mainly of images of size between 200-500KB. My contact list is around 5000, ...
0
votes
0answers
50 views

Printing 24 labels per page from Excel

I'm trying to print 24 labels per page in Word using Excel list. First page is fine, but when it moves to next page only difference is that second record from first page becomes first record on ...
2
votes
2answers
4k 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 ...
1
vote
0answers
97 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 ...
0
votes
0answers
109 views

Custom sender and reply-to in MS Office email mail merge using gmail as the email client

Can you do the same using Gmail instead of Outlook (see below)? Here's a workaround for Outlook. It's still a little manual, but for small merges like mine it's fairly effective. The key is to get ...
0
votes
1answer
9k views

Labels mail merge repeats on subsequent pages?

I'm trying to do a mail merge to print to labels. The first field in the document does not contain a { NEXT } field code, and because of this the records repeat between label pages for example: ...
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 ...
1
vote
1answer
285 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 ...
0
votes
0answers
55 views

Mail-merge in Word 2010 won't print static image

I'm trying to create a mail-merge letter that has an image of a signature at the bottom. However, when I do the finish and merge and print one of the records, the image isn't printed. I have tried ...
0
votes
0answers
52 views

Mail Merge | Excel transpose or any other solution

i have an excel with 3 columns: domains, clients, email clients each client can have more than one domain. I want to mail merge all my clients to make a change in the dns. but i don't want to send 5 ...
1
vote
1answer
4k 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 ...
0
votes
3answers
3k views

Office 2007 Mail Merge: How do I view field names instead of data?

I've just received a document which forms the basis of a mail merge as an attachment and I need to view the field names like they display in 2003 with the double chevrons e.g. ...
0
votes
1answer
709 views

Hide mail merge fields in Microsoft Word 2010

I have a document full of merge fields that are used to display information from a spreadsheet. Sometimes we want this data to be filled manually, so we have to print the document without these ...
2
votes
1answer
734 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
200 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 ...
1
vote
1answer
280 views

How to leave a blank space on IF_THEN_ELSE condition in MS Word Merge

I am running an mail merge program, where I need to merge certain fields. I have done these in the past. Just to add on these, I have to print certain text based on the value of the field in MS Excel. ...
0
votes
2answers
420 views

How to properly use nested conditional Mergefield in Word 2010

I want to refer two names in my condition, for example there is at least one Referral_Name and if there's a second one put the the second one, Referral_Name_2. So far I have the following nested if ...
0
votes
2answers
491 views

Word 2011 Envelope Mail Merge button is greyed out. Why

Steps to reproduce: Launch Word Create a New Document Display the "Mail Merge Manager" from the Tools menu Under "Select Document Type", click "Create New", select "Envelopes..." Stare in disbelief ...
1
vote
1answer
489 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
1answer
95 views

Mail merge multiple rows

My table in excel : Joe Smith, 11-1-12, 9-10am Joe Smith, 11-1-12, 11-12pm Joe Smith, 11-2-12, 7-8am Sara Roy, 11-1-12, 9-10am Sara Roy, 11-1-12, 11-12pm Needed result which should go in mail to ...
4
votes
2answers
11k 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 ...
0
votes
1answer
204 views

Where is the 'Query Options' command in Word 2010?

I want to attempt a mail merge by category. Was it removed from the app?