A Microsoft Word forum. Microsoft Office Word Forum - WordBanter

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » Microsoft Office Word Forum - WordBanter forum » Microsoft Word Newsgroups
Site Map Home Register Authors List Search Today's Posts Mark Forums Read Web Partners

Post New Thread
Threads in Forum : Mailmerge Forum Tools Search this Forum Feed Icon
  Thread / Thread Starter Last Post Reverse Sort Order Replies Views
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...
April 26th 12 02:31 AM
by jo15765 Go to last post
0 1,799
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...
April 25th 12 07:15 PM
by Ralph Long Go to last post
0 1,233
Question
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?
April 25th 12 05:54 PM
by Mschumacher Go to last post
0 1,130
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 Go to last post
0 1,443
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...
April 22nd 12 04:54 AM
by Juan Carlos Silva Go to last post
2 5,982
Unhappy
catalog type doc where syntax prevent an record from overrunning the bottom of the pg by erkjoel
In my attempt to create a directory type document in mail-merge how can I prevent an address block from over running the page. I want each block that will not fit on a page to start a new page. Thanks.
April 16th 12 07:27 AM
by erkjoel Go to last post
0 1,268
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 Go to last post
2 1,393
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...
April 13th 12 09:08 PM
by wilkisa Go to last post
1 1,754
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...
April 11th 12 10:54 AM
by handeiere Go to last post
6 3,281
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...
April 9th 12 06:22 PM
by Brad Bender Go to last post
0 1,804
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...
April 3rd 12 01:28 PM
by Nuno Santos Go to last post
3 5,752
Exclamation
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 Go to last post
0 1,282
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
March 28th 12 09:20 PM
by paul_53 Go to last post
0 1,282
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...
March 26th 12 07:04 PM
by Reinaldo123 Go to last post
1 4,726
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...
March 26th 12 12:51 PM
by pauljbutler Go to last post
0 1,934
Question
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...
March 13th 12 04:16 PM
by BenBrown Go to last post
2 2,446
Question
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...
March 2nd 12 09:41 AM
by bristolbanter Go to last post
0 1,617
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...
February 28th 12 10:25 PM
by daymaker Go to last post
0 1,623
Using SkipIf with date problem by dragonballcity
I have a list of people in an excel spreadsheet according to date. The first column in the sheet is labeled Date and I manually enter the date as m/d/yyyy (so for today 2/24/12). I create letters using mail merge in Word 2010 each day, but only want letters for people that are entered into the...
February 24th 12 05:09 PM
by dragonballcity Go to last post
0 1,522
Time shows as 0,375 by JamesG
Hi, My switch is "Time" \@"HH:mm" usually this works fine but there is strange problem today, now all i get is.. 0,375 instead of 9:00 It's merging from Excel, a restart didn't help.
February 15th 12 12:16 PM
by JamesG Go to last post
0 1,296
Post New Thread


Display Options
Showing threads 141 to 160 of 12021
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread Thread is closed  
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:00 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.