Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 04-13-2021, 05:19 AM
reeshaw reeshaw is offline Mail merge with TXT template Windows 10 Mail merge with TXT template Office 2016
Novice
Mail merge with TXT template
 
Join Date: Apr 2021
Posts: 5
reeshaw is on a distinguished road
Default Mail merge with TXT template

I am looking for a tool or web service to generate Word documents from text templates. Any recommendations?
Reply With Quote
  #2  
Old 04-13-2021, 02:26 PM
macropod's Avatar
macropod macropod is offline Mail merge with TXT template Windows 10 Mail merge with TXT template Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Cross-posted at: How to mail merge with TXT template? - Microsoft Community
For cross-posting etiquette, please read: Excelguru Help Site - A message to forum cross posters
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #3  
Old 04-13-2021, 04:01 PM
macropod's Avatar
macropod macropod is offline Mail merge with TXT template Windows 10 Mail merge with TXT template Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Your question lacks clarity. Your post title refers to mailmerge, but nothing in the post itself indicates how your 'text templates' (whatever they are) might relate to a mailmerge.

Please clarify what your 'text templates' are and how you would propose to use them.

A Word mailmerge main document can use a text file as the mailmerge data source - provided the text file is suitably structured (e.g. one line per record, with a field name for each item on the row, and fields separated by tabs or commas).
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #4  
Old 04-26-2021, 05:38 AM
reeshaw reeshaw is offline Mail merge with TXT template Windows 10 Mail merge with TXT template Office 2016
Novice
Mail merge with TXT template
 
Join Date: Apr 2021
Posts: 5
reeshaw is on a distinguished road
Default

macropod, I have .TXT documents with placeholders that need to be merged with the data and exported to .DOCX format. By placeholders I mean {{Name}}. The data is in CSV format and it contains columns that match those placeholders.
Reply With Quote
  #5  
Old 04-26-2021, 05:40 AM
macropod's Avatar
macropod macropod is offline Mail merge with TXT template Windows 10 Mail merge with TXT template Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Provided you create a mailmerge main document that you connect to the text file and insert mergefields pointing to your placeholders, everything should be fine.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #6  
Old 04-26-2021, 06:26 AM
reeshaw reeshaw is offline Mail merge with TXT template Windows 10 Mail merge with TXT template Office 2016
Novice
Mail merge with TXT template
 
Join Date: Apr 2021
Posts: 5
reeshaw is on a distinguished road
Default

I am not sure that I understand your solution. What is a mailmerge main document and how am I going to connect it to my template? This is the same as mail merge in Word, except that template is in .TXT format which is not supported by Word. I would be doing this on weekly basis and have no control over templates (provided by a customer).
Reply With Quote
  #7  
Old 04-26-2021, 11:34 AM
macropod's Avatar
macropod macropod is offline Mail merge with TXT template Windows 10 Mail merge with TXT template Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

See: How to use the Mail Merge feature in Word to create and to print form letters that use the data from an Excel worksheet
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #8  
Old 04-28-2021, 01:22 AM
reeshaw reeshaw is offline Mail merge with TXT template Windows 10 Mail merge with TXT template Office 2016
Novice
Mail merge with TXT template
 
Join Date: Apr 2021
Posts: 5
reeshaw is on a distinguished road
Default

It seems that you don't understand my problem. I know how to do mail merge in Word. The problem is that you cannot use templates in plain text format in Word. They must be .DOCX or .DOTX. Since I cannot convert them to Word I am looking for a service or a tool that can do mail merge with plain text templates.
Reply With Quote
  #9  
Old 04-28-2021, 01:33 AM
macropod's Avatar
macropod macropod is offline Mail merge with TXT template Windows 10 Mail merge with TXT template Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Word can open and save .txt files, so that is not the issue. The issue is that .txt files absolutely cannot contain the mergefields necessary for a mailmerge. Given that stricture, how do you propose any application would be able to complete what you're calling a mailmerge?
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
  #10  
Old 04-28-2021, 05:24 AM
reeshaw reeshaw is offline Mail merge with TXT template Windows 10 Mail merge with TXT template Office 2016
Novice
Mail merge with TXT template
 
Join Date: Apr 2021
Posts: 5
reeshaw is on a distinguished road
Default

I am aware that Word is the best tool for mail merge, but it is not the only one. OpenOffice can do it too. Today, I believe that the term 'mail merge' is more related to MailChimp and Gmail than Word. Unfortunately, none of them can solve my problem. Anyway, I found this free web app called DocBlender that supports .TXT templates, but doesn't have API support (although they mention it on their website).
Reply With Quote
  #11  
Old 04-28-2021, 05:49 AM
macropod's Avatar
macropod macropod is offline Mail merge with TXT template Windows 10 Mail merge with TXT template Office 2016
Administrator
 
Join Date: Dec 2010
Location: Canberra, Australia
Posts: 21,956
macropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond reputemacropod has a reputation beyond repute
Default

Quote:
Originally Posted by reeshaw View Post
I am aware that Word is the best tool for mail merge, but it is not the only one. OpenOffice can do it too. Today, I believe that the term 'mail merge' is more related to MailChimp and Gmail than Word. Unfortunately, none of them can solve my problem. Anyway, I found this free web app called DocBlender that supports .TXT templates, but doesn't have API support (although they mention it on their website).
You posted on MSOfficeForums.com - which is quite obviously geared to supporting users of Microsoft Office products. You can hardly expect replies here to address what you may or may not be able to do with a non-Microsoft product. Moreover, it was you who specified:
Quote:
Originally Posted by reeshaw View Post
I have .TXT documents with placeholders that need to be merged with the data and exported to .DOCX format.
notwithstanding that:
Quote:
Originally Posted by reeshaw View Post
By placeholders I mean {{Name}}.
which quite obviously mean they're not mergefields. Hence your placeholders would have to be replaced with mergefields before a mailmerge could be implemented.

If you don't want a Microsoft Office product - which essentially means Word or Publisher - I suggest you ask elsewhere.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
Reply With Quote
Reply

Tags
word template

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
mail merge using word template GCRUZ Mail Merge 1 11-07-2018 03:43 PM
Mail Merge or Adjust Template? ShankedS Excel 3 07-27-2018 01:40 PM
Mail merge with TXT template Mail Merge template for all users cofee Mail Merge 1 09-08-2016 03:56 AM
Word Mail Merge Template newbie406 Mail Merge 2 02-20-2015 08:08 AM
Mail merge into a template born Mail Merge 1 09-13-2011 01:42 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 02:03 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft