|
|
If/Then Merge with bullet points, but without blank lines by
GMarkham
Hello,
I'm trying to create an if/then merge based on the following logic...
If Condition A = true, output "• string A", else check for Condition B
If Condition B = true, output "• string B", else check for Condition C
If Condition C = true, output "• string C", else check for...
|
|
1 |
1,539 |
|
|
Inserting Images by
Nick2012
I have a basic mail merge letter and I want to include images from a folder that are named as a mailmerge field.
I have used the following code
{INCLUDEPICTURE "C:\{ MERGEFIELD "PLACEREF" }.TIFF \* MERGEFORMAT \d}
The picture stored under the C drive is named as the placeref of the mail merge...
|
|
0 |
1,194 |
|
|
Explain Mail Merge by
jo15765
I know nothing about how the mail merge works...but I use it on a day-to-day basis and was thinking there has to be a better way.
Currently, we have mail merge set up in a Word 2000 document that will run a query and pop up a box asking for the ID of the record to pull, the data for that specific...
|
|
0 |
1,836 |
|
|
Supress blank fields in merged doc by
Ralph Long
I can't seem to find an answer to this, but it may exist elsewhere. I am trying to create a packing slip using a Word doc using an Excel sheet as the merge source. On each row of the Excel sheet, I have the recipient name, address, etc and at the end of each row, i have 8 rows that list a quantity...
|
|
0 |
1,270 |
|
|
Directory Merge by
Mschumacher
I set up a Directory Merge document and now all my merge documents are directory merge documents, which means I have to merge data before I can preview results. How can I turn this option off and restore my documents to normal mail merge documents?
|
|
0 |
1,162 |
|
|
Thoughts on Mail Merge Automation by
Jenn68
I am developing a user friendly application utilizing Excel VBA to create and process a database to be used as the source of data for a Word mail merge.
From Excel, the user may choose to create one of 16 different documents based on the data in the database. The 16 different documents are based...
|
April 24th 12 02:25 AM
by Jenn68
|
0 |
1,479 |
|
|
How to prevent sql command warning when opening merge document by
Daversey
I am trying to automate word mail merge from access, but when I open the mail
merge document it comes up with a warning: "Opening this document will run
the following SQL command Select * from (and then the text file which merges
with the word document).
How do I automate it so I do not have to...
|
|
2 |
6,187 |
|
|
|
|
0 |
1,305 |
|
|
How do I link to GoldMine contact manager? by
MrsMomAZ
We use GoldMine 4.0 for our contact manager and I am trying to install the
link to have it print letters and envelopes in Word from GoldMine screen. I
cannot find the GMLink.dot file to enable macros and install the ODBC driver.
|
April 13th 12 11:40 PM
by Cjmac
|
2 |
1,430 |
|
|
Mail merge hyperlink wrong results by
wilkisa
My user has created a mail merge in Word 2010, using Excel 2010 workbook as source data. One of the many fields is called "Survey Link" and contains links to Sharepoint pages, either a DEVELOPMENT page or a PROJECT page. When the hyperlink is created in Word and the merge field is entered as...
|
|
1 |
1,792 |
|
|
Reading delimited text file into labels by
Clay Shannon
I am trying to populate Avery 5160 labels by using a file with contents like
this (semicolon-delimited, one record per line):
Mr. Joe Brown; 123 Cypress Lane; Sausalito; CA; ;;; 54567
Mr. Merle Haggard; 456 Fiddlestix; Redding; CA; ;;; 55555
Does anybody have step-by-step instructions on how to...
|
|
6 |
3,320 |
|
|
How can I Mail merge database to pre-printed letters by
Brad Bender
My boss just ordered promotion letters (standard 8.5" x 11") with two areas left to print our customer list/database into. The first area will be shown through a windowed envelope and the second is in the bottom right hand corner of the page for the return mailer. Both addresses will be the same...
|
|
0 |
1,849 |
|
|
How do I avoid a blank line if a mail merge field is empty? by
Geo 4
Some addresses need only one line before the city and state, that is, they
only need an Address 1 field. Other addresses require two or even three
lines so I have had to create an Address 2 and an Address 3 field.
Unfortunately, this means that when an address that has no data in Address 2
or...
|
|
3 |
5,822 |
|
|
Mail merge over 30 labels by
2kids
So I am making address labels from an excel sheet. I can mail merge no problem in Word when I have under 30 labels (Avery 5160 label is what I am using, fits 30 on 1 page) fits all on 1 sheet of labels. When I try and merge an excel sheet that has 160 addresses I am only getting 1 sheet of 30...
|
April 2nd 12 04:25 PM
by 2kids
|
0 |
1,315 |
|
|
Office 97 by
paul_53
I have been asked at work if there is a way to send the same email out to multiple recipients. However, the individual recipients must not see each others details.
Is this possible by setting up a mailmerge in Word?
Thanks
Paul
|
|
0 |
1,315 |
|
|
Directory Mail Merge with table layout by
3N1GM4
Hi all,
I am trying to perform a Directory type Mail Merge from Excel into Word where the data being referenced in Excel has repeated values in one column which I effectively want to group on so that I produce one document per value in that column instead of one column per record in the...
|
|
1 |
4,894 |
|
|
mmtodocs merge extra blank page by
pauljbutler
I am using the lastest version of the mmtodocs on word 2010 i am having the problem where its inserting a next page section break at the end so i am getting a blank page.
Both the merge template and the normal.dot have the same margins and set to a4 still nothing
Any ideas? I cant get to the...
|
|
0 |
1,971 |
|
|
Data source has changed - can't save the new path. by
Ryszard Mikke
Hello,
I've got a mailmerge document getting data from Excel (with Microsoft Office 12.0 Access Database Engine OLE DB Provider (Ufff, the longest name on the list ;) )) in Office 2010.
Now, I had to move the Excel file with data and I'm trying to update data link accordingly. Every time I Open...
|
|
2 |
2,479 |
|
|
Labels Mail Merge Issue 'new record' blank by
bristolbanter
I have gone through all the normal steps.
The data source is an excel spreadsheet and is correctly identified.
When I look at the recipient list they are all there in order.
All the necessary fields are matched.
However, the new record field that is automatically entered for each label...
|
|
0 |
1,645 |
|
|
Merging customer file with multiple orders by
daymaker
Let's say I have the following excel file that has NAME (customer account name), ORDER # and order DATE. (I can convert this to an Access file if better for my application...)
http://i67.photobucket.com/albums/h292/jkilday4/DummyexceltableforumquestionB40212-1.jpg
As you can see, some account...
|
|
0 |
1,657 |