For issues relating to setting up or running mail merge operations.
1
vote
0answers
14 views
Running Mail Merge on Embedded Document in Word
I am looking for code that will open all embedded documents within a Word document, update the mail merge info, and close the file again.
Here's the story: I have about twenty documents that contain ...
0
votes
1answer
23 views
Saving a Word File from Mailmerge with Data Base Field Name as the File Name
I would like to able to save the active file in Word 2010 MailMerge, with its file name derived from the database field "First_Name" and from the database Field "Last_Name" into a subfolder that is a ...
0
votes
0answers
8 views
Merge Pages document with Contact List and Email it?
I have imported contacts into Contacts, and I'm including Mail Merge fields in Pages. I need to merge the Pages document with the Contact Lists (I could use a .csv or Numbers file if necessary) and ...
1
vote
1answer
22 views
Mail merge displaying wrong numeric data
I am using Office 2003
On Access, I export values from a form into a .xls, after that using mail merge on word I import the data to be displayed on the file. Data such as dates and strings are ...
0
votes
1answer
47 views
Conditional Merge Fields Open XML SDK
I've looked all over and I can't seem to find any suitable information on Mail Merging (for Conditional Fields) using the Open XML SDK.
We have a conditional merge field, that is consequently made up ...
0
votes
0answers
37 views
Merge ALL rows of Excel sheet to Word document
I have a spreadsheet with 5 columns and a varying number of rows that I need to merge to a single Word document. I tried to merge to a Directory document but it either returns one row or creates a ...
0
votes
0answers
48 views
Reading Mail Merge Field Using Aspose
While reading mail merge field using Aspose Words I got incorrect result for fields like {MAILMERGE Country Name}, it is only reading it as Country and not as Country Name.
An older version of Aspose ...
0
votes
0answers
28 views
Google Mail Merge getAs(application/pdf) save file as application.pdf
since a week i see that the script
// Convert temporary document to PDF by using the getAs blob conversion
var pdf = DocsList.getFileById(copyId).getAs("application/pdf")";
is generating a ...
0
votes
1answer
181 views
Excel macro to Word mail merge is trying to merge ALL rows in the column
I created a VBA form and macro that will generate auto-numbered documents for my company. Depending on the cost-center selected it will choose a Word document to complete the merge. It basically ...
0
votes
1answer
195 views
Change value of Word MailMerge field using VBA
I have a document with MailMerge fields, however I do not want to use the whole datasource->mailmerge idea. Instead I am presenting a UserForm on Autonew() and asking the user to type the data into ...
0
votes
0answers
55 views
Mail merge. How to include a list of items
I need help with some code. The actual application will be more complicated but I just need help with one aspect.
I have an excel sheet that eventually will need to populate three word documents.
...
0
votes
2answers
103 views
MS Word 2010 mail merge: dynamic url, same text
I have a MS word 2010 mail merge that needs a personal url as href and a generic title for all users
i can send a url that displays as the full url, but i want a generic display text so users dont ...
0
votes
0answers
71 views
VBA Excel to Word Merge, Choosing Row
Executing Word Mail Merge
Following the above, I have achieved the mail merge for the entire spreadsheet.
How would I specify that only Row "rowno" is merged? Where Rowno is a msgbox result.
I ...
0
votes
1answer
54 views
aspose.words putting parentheses around negative numbers
I have a little problem with numbers in word documents. I need to merge data into a table with Aspose.Words, this part works fine. Only I need to put parentheses around negative numbers (and multiply ...
0
votes
0answers
45 views
Word 2010 sql query as datasource
I have a task where I need to create a Mail Merge document with Word 2010. The datasoruce is a SQL Server database. This is easy enough to do when I select a single table as the datasource. ...
2
votes
1answer
211 views
Closing embedded object after editing
I'm having some trouble performing a mail merge using an embedded Word file. Essentially
I'm trying to build a macro to:
Open an embedded Word file (let's say the file is Object(2))
Connect the ...
0
votes
0answers
137 views
Export data from excel into word document
I have this excel document with multiple rows;
Column A: article no., Column B: article name, Column C: status, Column D: additional information.
Row1; 1, Article A, 15 in stock, Information about ...
0
votes
1answer
41 views
MS Word not trusted by Outlook?
a Delphi app automating Word mail merge and emailing via Outlook (Office 2007).
Windows XP2
Anti Virus Software Status -Valid
Trust Center Programmatic Access NEVER WARN ME.
(A different app not ...
-1
votes
1answer
124 views
Word 2007 ~ Aspose Skip Empty Cell
I am using Aspose with Word for a Mail Merge.
I have a 3x2 table as follows
<a> <b>
<c> <d>
<e> <f>
However under certain conditions one field might be ...
1
vote
1answer
345 views
Losing format with MS Word Mailmerge Macro
Using MS Word 2010 I want a Mailmerge to run with a macro, saving each record out as a separate file, in PDF format using one of the fields as the filename. This will save me loads of time.
The ...
0
votes
1answer
49 views
Nodejs Mail Merge
Is there any library in nodejs using which I can create templates do a mail merge. I see many cloud services
http://saaspose.com/
http://www.docmosis.com/
Is this the only option or is there a ...
0
votes
1answer
316 views
How to print a single document in pdf via Word 2007 (mail merge)
I have got an interesting question and I couldn't find an answer somewhere.
I need to print around 2000 letters and of course I will do it with Mail Merge. Problem: I need every single one printed ...
1
vote
0answers
100 views
Using 2d array as datasource of word mailmarge datasource in vb6
I'm creating a word automation in vb6 to create mail marge for mailing labels.Here is a help link to do it using a text file as data source. Now I want to do it using a 2d array as data source. I ...
0
votes
1answer
753 views
Run Word 2010 mail merge from access without query prompt
My scenario is similar to that described in excel VBA to Automatically select Yes when prompted during mail merge, except that I am running the VBA from the Access database that contains the data to ...
0
votes
1answer
66 views
Mail merge dropping the zip code [closed]
I have already gone into excel, which my original addresses are located, and I formatted the block titles zip codes to a special format for the zip. When I complete mail the mail merge field document ...
0
votes
1answer
127 views
Access SQL query to mailmerge
How can I transform this table from this
id name
1 sam
2 nick
3 ali
4 farah
5 josef
6 fadi
to
id1 name1 id2 name2 id3 name3 id4 name4
1 sam 2 nick 3 ali ...
0
votes
0answers
291 views
Applescript to mailmerge from Excel (MAC)
I am trying to create a way to be able to send personalized emails from the Mail app that pulls information from an excel sheet.
I have some code from other people that pulls information from a text ...
1
vote
1answer
310 views
VBA MailMerge length > 255
i'm trying to use MailMerge with Word 2010.
I have a TAB delimited file database.dat which looks like the following:
ID Name Street
1 John FooBar 1
2 Smith ...
0
votes
0answers
212 views
Word Mailmerge to document with more fields that datasource
I am trying to perform a word mail merge from access using VBA with a data source that sometimes has less fields than the original data source the document used. The problem I am getting is that ...
2
votes
2answers
320 views
How to set the file name of a word document without saving it from c# and automation
I create word documents via automation and mailmerge with office Interop from c# (.net4). The merge works well and the user receives the created document as he desires. So far all is well.
The client ...
0
votes
0answers
114 views
MailMerge problems in C#?
I have a mail merge template in .dotx format. Now, I can successfully open it as a document using Interop.Word functions. The problem is, it continuously opens a window which urges me to choose it as ...
2
votes
1answer
499 views
How to add data into a Merge Field in C#?
I would like to automate printing invoices from a Word Template. I think I have the logic down but I just don't know the right way of coding it. Here is my current code
Selection wrdSelection;
...
2
votes
1answer
1k views
Access / Word 2010 VBA Mail Merge Tries to Open [Foldername].mdb Instead of ACCDB Source
We are attempting to automate a mail merge process from within Access - upon clicking a button, VBA runs that specifies the current database (an accdb) as the data source and runs SQL, per the code ...
0
votes
1answer
460 views
Categorizing MailMerge on ONE Page - Directory/Catalogue
I am trying to get the mail merge work with directory as the source that would help me categorize the records in my current template.
I am using this field code: {QUOTE{IF{MERGESEQ}=1{SET Key ...
0
votes
1answer
93 views
Mail Merge Script with inputbox
I am trying to change one word from a template I have in a spreadsheet, for the value that the user inputs through the inputbox. When I run my script it doesnt change the word, any ideas??
function ...
google-apps-script
2
votes
1answer
132 views
.net textbox with user added fields
I would like to create a control class that would allow the user to type text like a normal text box. However, it should have a "mail merge field" functionality that would allow the user to insert a ...
0
votes
1answer
390 views
Templating Mail Merge in .NET [closed]
I am planning to create a Mail Merge Web Application of some sort, and am wondering if there are any 3rd party alternatives available I can leverage instead of trying to write everything from scratch.
...
0
votes
1answer
101 views
PHP fwrite - which files types work? - linux server
My client has asked me to set up a mail merge structure with an existing database of contacts. They want to be able to upload some sort of Microsoft office document into the system, then I need to be ...
0
votes
3answers
4k views
How to split a mail merge and save files with a merge field as the name
I have a bunch of mail merge templates setup, when I merge the documents I want to split the results into separate files each one with a name based on the merge field “FileNumber”.
The code I have ...
0
votes
1answer
609 views
Changing the value of a Word 2007 document field using VB.Net
I have a word document with a number of fields scattered around the text. The fields were created using insert > quick parts > field. Each field has a unique name.
I managed to open the document but ...
0
votes
1answer
478 views
Mailmerge, querystring returns incorrect recordset
I have the problem related to word automation \ mailmerge, QueryString command
and SQL sentence in Word 2007.
If I use select and "=" operator, everything work as expected.
...
0
votes
0answers
255 views
How To Make A Nested Mail Merge, Access 2007
I am a novice as to technology and specifically MS Access 2007 and VBA but I managed to build a small application for my botique office using MS Access 2007/VBA and MS Word for Mail Merge.
I am now ...
0
votes
0answers
166 views
Lost macros after mail merge (MS Word)
I've got a few Word templates containing macros, that I use customize with data via mail merge.
This is done through the microsoft.office.interop.word namespace in C#.
using Word = ...
0
votes
0answers
87 views
Delete rows from the table in mail merge document
I have a mail merge document, within that i want to delete 3 rows from the tables if the merges field within those rows are returning null values.
How can i performs this either by macro or by any of ...
4
votes
1answer
176 views
Mail merge in ruby on rails, but in big numbers
I am trying to implement sort of mail merge for printed documents in Ruby on Rails 3.2. I have about 8000 recipients and template origin in Microsoft Word. Template includes images (photos) and ...
0
votes
2answers
236 views
Textfile as a datasource for MailMerge in MS Word - how to insert manual linebreak instead of paragraph mark in field?
I have created a textfile as a datasource for a mailmerge in microsoft word. This is working great. Now, i have fields which contains multiline values. When I use this field in the template it creates ...
0
votes
1answer
1k views
MailMerge using sql server database
I'm trying to do MailMerge with SQL server database as the datasource in c#. Is it possible? I've googled for days without any valid results. Can someone provide me with any valid links or explain how ...
0
votes
1answer
417 views
MailMerge from arrays or lists
In this site is an example about doing a mailmerge with 2 arrays and the MailMerge.Execute method but the method don't accept 2 arguments.
Anyway, Is there a way of doing something similar with 2 ...
0
votes
2answers
160 views
Is it possible to write a word add-in or something similar to provide a custom mailmerge datasource?
I've a backend system which I want to use as the datasource for MS Word 2010 mailmerge.
I've the idea that I should write a word add-in which provides the datasource and is communicating with my ...
1
vote
1answer
220 views
Mail Merge Google App Script
I need some help with a google app script for a mail merge. What I have is a google form that is a sign up form for an event. What I want is for the fist 5 (random number) people to get one email ...
