The tag has no usage guidance.

learn more… | top users | synonyms

0
votes
1answer
14 views

Mailmerge 2 spreadsheets

Can I mailmerge in Word 2010 using 2 Excel spreadsheets? Have found article that says Get Data and then click Data Source but cannot find this in Mailmerge Wizard as an option.
0
votes
0answers
6 views

Mail Merge 2007 letter with data from multiple rows if same recipient

I am a novice mail merge user attempting to create a mail merge letter notifying students of incomplete work that must be completed over the summer in order to advance grades. I have an excel ...
0
votes
0answers
8 views

I need to pass a value to MS Word MergeFiled?

I need to pass the Revision Number to a Mergefiled in MS Word. TableStart:ClaimScoping{RevisionNumber='1'} There might be up to 7 revisions on every Claim Scope. I need to print revisions ...
0
votes
2answers
28 views

Microsoft Word Merge Field Problems

I'm doing a mail merge to a template with data pulled from an Excel table. I'm attempting to add text if the letter is for Program A or Program B, and different text if it's from Program C. The method ...
-1
votes
0answers
26 views

VBA Mail merge save individual docs not working

I have this code which worked before, so I'm not sure what's gone wrong. As far as I can tell the code stopped working after I edited my template, but I can't find anything online about the template ...
1
vote
1answer
3k 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
3k 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.
0
votes
3answers
20 views

How can I change the date format in MS Word 2016 to show only hours and minutes when mailmerging with an Excel file?

I'm trying to mail merge a MS Word letter with a MS Excel file which contains dates and times as well as other fields. I'm trying to put together for calling people to interviews at different times. ...
1
vote
3answers
8k 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 ...
3
votes
3answers
47k 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
0answers
19 views

CRM Dynamics 2016 MS Word 2013

In Dynamics CRM 2016 we have the merge documents. I do miss the former switch options. I saw you can manipulate the format in the docx by renaming to .zip and edit the xml... but what to do? I want to ...
0
votes
0answers
25 views

Is it possible to mail merge a tables from the database into word?

I'm trying to use MS Word as an alternative to some basic reporting using mail merge from an MS Access database. I'm able to do basic mail merge with fields from one table. What I want to do next is ...
0
votes
0answers
39 views

Word Mail Merge - Filter Based on Partial Match of Text?

I'm using Word 2010 and Excel 2010 to do a mail merge. In the spreadsheet, the Employer field has variations of the employer name, such as: - SkyScraper - SkySraper Inc. - SkyScraper Mexico In ...
0
votes
1answer
561 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
25 views

Mail merge record not stay next to others, split by Section breaks [closed]

I have a picture with an text field inside it. I want to use mail merge to auto fill this textfield with 20 different numbers. When I use mail merge, each record stay in a page, and split with the ...
0
votes
0answers
21 views

How do I attach a PDF document to Outlook 2011 mail merge on a Macbook?

I want to generate e-mail message of letter form as HTML and add a PDF document as an attachment to the message. How can I do that?
0
votes
0answers
31 views

Outlook 2010 E-mail Merge

We need to send over 100 e-mails out to different recipients with an attachment. Is there a way to create an e-mail merge so that the same document is sent to hundreds of addresses. Similar to mail ...
0
votes
3answers
66 views

Printing multiple sheets with Mail Merge (Excel/Word)

I need to create letters with MS Word. On each letter we need a code which is placed on the letter using Mail Merge. Some letters need to be printed more often than others. I need to find a way to ...
0
votes
0answers
102 views

Word Mail Merge with Excel - Can't open both at the same time

I have a word mail merge for letters using an excel file as the data source. My problem is that I am not able to have both files open at the same time for editing (i.e. the excel source data and the ...
1
vote
1answer
42 views

word - merge mailing with specific fields if another specific field has a certain value

I want to do a merge mailing and I got the following issue My word document is on the screenshot capture below I want to put specific merge fields like adr_A1 in Adresse1when my specific field,...
0
votes
0answers
54 views

Automatically scale font size to fit text box

I am currently setting up a mail merge but I need the size of text in a text box to scale. I want the font size to be the biggest I can whilst fitting in the text box. I've searched around, but I ...
0
votes
0answers
51 views

Mail Merge Multiple IF Conditions for cell

I have a conditional statement for two cases (and default) which works fine. This is simply to enter a cell value based on another cell value in an earlier column simplified and shorm of extraneous ...
0
votes
0answers
21 views

Microsoft Word for Mac adding shadows to merge fields

I recently installed Microsoft Word for Mac (2016), which seems to be a vast improvement over previous Mac editions. However, after creating a graphically complex (lots of shapes and text boxes) mail-...
1
vote
1answer
23 views

How to pull addresses from word to use in Mail Merge?

I am trying to figure out how to pull addresses from a Rich Text Doc. in Microsoft word to use the mail merge in Microsoft Access. This is being used for work and I need something as quick as possible,...
0
votes
1answer
407 views

How to concat mail merge IF fields in Word 2013

I have Word 2013 and I have a need to display a piece of text only if a mail merge field equals 1. Simple: { IF {MERGEFIELD Discount} = 1 "You get a discount" "You don't get a discount" } However, ...
0
votes
2answers
450 views

Word 2010 Mail Merge Suppress Blank Conditional Mergefields

I cannot get a conditional Mail Merge to suppress blank lines in a relatively clean and efficient way. The only solution I have found is one I am not willing to use yet as I feel there may be a better ...
1
vote
1answer
29 views

Microsoft Word 2010 mail merge - statement overdue calculations

My company hosts various events for clients (conference meetings, receptions, holiday parties, etc.). After an event is completed, we send out invoices. Monthly we also send out statements for all ...
0
votes
0answers
15 views

How do I set conditions in a mail merge in Publisher 07?

I want to do a mail merge where if a field is blank or empty, something else should be printed. How do I do that? Also, I used a mask for inputting phone numbers, but they are coming out 1234567890, ...
0
votes
0answers
72 views

MailMerge change Picture Size [Word2013]

I have a word document witch I'm using as a Template for my MailMerge. My problem is, that when I insert the Pictures into the document the pictures are too big. I want them to have a 50 px width (...
0
votes
1answer
461 views

Mail merge alternative

I have a template Word document which I use when writing supporting technical documents to send with CAD drawings. Due to the nature of the product we create, this accompanying technical note is ...
0
votes
2answers
1k 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 ...
0
votes
0answers
209 views

How to mail merge in a protected document or simular

I'm trying to do a mail merge with protected templates which Microsoft will not allow for some reason does anybody no of a work around or an alternate solution. The reason it is a protected document ...
0
votes
0answers
46 views

MS Word 2013 Mail Merge: I can't seem to make it retain formatting

I am doing a merge in MS Word 2013, I have a part of the document that says: Dr. «Contacts_Last_Name» When I Toggle Field Codes, it says: Dr. {MERGEFIELD Contacts_Last_Name} I have tried to format ...
0
votes
3answers
3k views

How can I print out or copy merge fields?

I have very complicated mergefields in Word 2010, thus I would like to print out what I coded already to analyze it. However, I cannot copy and paste the pure code, because it always converts to ...
0
votes
0answers
36 views

Is there an equivalent to CTRL+F9 in Microsoft Publisher 2007?

I'd like to be able to edit the fields in my Microsoft Publisher based mail merge. In MS-Word there is a feature where you can press CTRL+F9 and add things like if statements and images instead of ...
0
votes
3answers
14k 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 ...
2
votes
1answer
3k views

How do I attach a PDF document to an email merge using Outlook and Word

How do I attach a PDF document to an email merge using Outlook and Word. The merge is ready to go but I don't see a place to attach a file.
0
votes
0answers
31 views

3-level Mail Merger

I need to do a 3-level mail merge in Word 2010. I have done to 2-levels(with the help of these documents https://support.microsoft.com/en-us/kb/211303, Mail Merge - Multiple Rows Into One Document but ...
0
votes
1answer
23 views

Changing current mail merge to use new source data

I have a mail merge file that I created last year, I would like to use a new source data file to create new post cards. Can this be done and how do I go about doing it? I really don't want to create ...
1
vote
1answer
231 views

Multi-line merge fields and line spacing

A database field contains several lines. When the field is merged in the Word document, each line becomes a paragraph, therefore each of them get the paragraph spacing. Example: «my_merge_field» ...
2
votes
0answers
128 views

Suppressing Blank Mergefields in Word 2010 Mail Merge

I'm working on combining two mail merge letters into a Master template that will know which merge letter to populate based on information in a specific column. I have successfully combined the two ...
1
vote
1answer
54 views

Libreoffice: Import columns of spreadsheet as fields

I have a LibreOffice Calc spreadsheet with Columns A, B, C. I would like to create a document in LibreOffice Writer with format: A1 B1 C1 A2 B2 C2...
0
votes
2answers
3k 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
1answer
54 views

Retain email subject when sending mail merge via Publisher 2010?

I am using Publisher 2010 to send a mail merge via email. I choose "Finish & Merge" and then "Send Email Messages..." and finally, after entering a Subject, hit "Send." No problem! The expected ...
0
votes
1answer
201 views

adding image from excel to word using mail merge

I'm using mail merge to generate a word document from an excel sheet and some cells contain images (office 2013). Is it possible to export them as well to word directly with mail merge without putting ...
0
votes
1answer
488 views

Word 2010 - Mail Merge multiple conditions

I am attempting to get mail merge to process certain conditions eg: if mergefield spouse = 1 and mergefield lawyer = 2 and mergefield children = 3 and mergefield parent = 4 add certain text or if ...
0
votes
1answer
145 views

Mail Merge comparison between fields

I have a meeting merge document which is populated from a CSV file with data entered online from a facilitator. I am unable to work out how to do multiple conditions, there are a maximum of 10 clients ...
1
vote
0answers
47 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
127 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 \ |-------------------------...
0
votes
1answer
286 views

Word mail merge and page breaks

Looking for a way to put a page break after a number of rows in an Excel data source for mail merge in Word - the number of rows before the page break can vary, depending on he number of records that ...