0
votes
1answer
33 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 ...
1
vote
0answers
58 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
0answers
32 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 ...
1
vote
0answers
59 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
690 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
0answers
513 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
2answers
1k 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 ...
2
votes
2answers
6k 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 ...
0
votes
1answer
314 views

Is it possible to Link to Excel File Based on Dynamic Mail Merge Field?

If I were to create an excel sheet with merge fields for a Mail Merge, and one of those fields were to be a file location, for example, can I then create a link in my Word document to a second Excel ...
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 ...
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 ...
1
vote
1answer
260 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
1answer
296 views

Printing labels in word, starting in a specific (offset) cell

This is probably super simple and I'm just overlooking something... I hope. I'm creating labels in Word 2010 and pulling the data from Excel 2010. I've got them laid out perfectly, but I need to ...
1
vote
3answers
6k 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 ...
0
votes
2answers
6k views

How to mail merge 2 excel sheets in same workbook, to word

Hi have an excel workbook with this structure: course sheet with date and venue participants sheet with names and addresses How can I add the date, venue, names and addresses from these two sheets ...