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
merging custom labels? by jshean
How do I merge custom labels?
June 14th 05 09:31 AM
by Cindy M -WordMVP- Go to last post
1 788
Why is the WORD mail merge truncating information? by KristineB
I have a prayer list set up in excel that I merge into a Word document. It is truncating a part of some of prayer request fields. Is there a limit to the amount of characters that can merge?
June 14th 05 09:31 AM
by Cindy M -WordMVP- Go to last post
3 994
mailmerge cannot read data source by Bev
I am trying to merge individual records separately into separate documents, so I've written a looping macro which merges each record separately and loops according to the record count of the data source. It worked fine when we were using Word 97 but I've had problems since I re-wrote it in Word...
June 13th 05 10:00 PM
by Bev Go to last post
4 1,688
Duplicate Records Merging with Access by markmidwest
I am creating a mail merge document using data from an Access database as the source. The merge works fine but some records print twice on every letter that they are merged into. I viewed the code & can't find any reason for it. Any help would be greatly appreciated. Thanks, Mark
June 13th 05 07:10 PM
by Peter Jamieson Go to last post
3 1,227
Conditional Merge with Tables. by Andrew Minor
Hi, I'm using Word 2000 and I'm trying to work out how to do a merge whereby a table is printed dependant on a condition. The pseudo-code is: If (Mergefield(a) = "BACS") or (Mergefield(a) = "") then ---------------------------------- | Table goes here |
June 13th 05 06:34 PM
by Peter Jamieson Go to last post
1 790
Mail Merge Field Order by KTJ
Hi all, im having problems with mail merge and access DB's. I want to connect to an access table to create mailing letters. It works fine apart from the fact that in the 'edit recipients' dialogue box, the fields are in a different order to how they are in the access table. Now this is a...
June 13th 05 06:09 PM
by Peter Jamieson Go to last post
1 1,019
how do i conditionally format in a mail merge document by Karen K
I am working on what should be a relatively simple task of a mail merge to create labels. The trick is if the value of field "c" is = to EA, then I would the first line to print with a blue background. The if then statement will not allow formatting so I am guess I will need to key a string...
June 13th 05 03:46 PM
by Karen K Go to last post
2 924
Time Format by Andy
Hi; Have been searching for a way to format time in a mail merge. The data source comes from Access 2k. It now displays 09:05:00AM, need it to display 9:05am. Can this be done?
June 13th 05 12:34 PM
by Andy Go to last post
2 610
Mail Merge fields "Ken Washington" by Problem with formatting merged fields
I am using MS Word 2003. I am using mail merge. I am trying to format a field with 2 decimal places and a "$" sign. The MS instructions say to "On the Data tab or the General tab in the Control Properties dialog box, click Format". I am unable to find the Data tab, the General tab or the...
June 13th 05 10:06 AM
by Cindy M -WordMVP- Go to last post
2 623
mailmerge preview does not update includetext data by robrachlin
One of my associates is using XP and Word 2003. She's using includetext to bring the right version of a table into a form letter. The data updates correctly when she runs the merge, but when she previews the letters, sh sees the same table in all of them, even thoguh the other data updates...
June 12th 05 10:58 AM
by Cindy M -WordMVP- Go to last post
3 1,474
Merge problems by James42
I have an excel sheet with 246 columns with a header row and one row of data. Each field contains text data varying in length. Some fields are empty. I have tried to merge directly to Word but get the error "can't open the data source". When I save the sheet to a txt file and merge to word it...
June 12th 05 10:58 AM
by Cindy M -WordMVP- Go to last post
1 692
Add fields to an envolope by Garyberk
When addressing an envolope in word (using the outloook contacts database) I need to add "fields" (title, company, etc.) to the address that automatically comes up. Any ideas?
June 11th 05 05:02 PM
by Graham Mayor Go to last post
1 835
Date Format Not Working by Andy
Hi; Been working on this for a few hours and getting nowhere fast. Using Access 2k as the data source for a mail merge to Word 2k. Have read the posts, have read Microsoft's KBs and also have read Cindy Meister web site Date format. {MERGEFIELD StartDate \@ MMMM,yyyy}
June 11th 05 04:59 PM
by Graham Mayor Go to last post
1 818
Mail merge from Access, with hyperlink field by troubadour
I try to mail merge a Word document, from an Access database query, containing an hyperlink field (file://) I obtain in Word the adress of the field, what i wished would have been its content. Is it better to try solution 1 ou 2 ? 1 : trying to do so that Access exports the content of the hyperlink...
June 11th 05 04:44 PM
by Cindy M -WordMVP- Go to last post
4 1,560
can't move inserted images or pasted spreadsheet in word by Pete P
I am no longer able to move my inserted pictures or spread sheet in word documents
June 11th 05 04:44 PM
by Cindy M -WordMVP- Go to last post
3 3,409
Merged fields not printing by Tina L.
I am trying to print out barcodes, to label warehoused boxes. I have an excel spreadsheet with one column, and a word document, which takes the information from the excel spreadsheet. When I merge the document, I can see the correct information on screen, however when I submit a print preview, or...
June 11th 05 04:44 PM
by Cindy M -WordMVP- Go to last post
5 2,816
How to create a data file with addresses to merge form letter docu by GTDriver
I'm trying to create a data file of addresses so I can then merge this file into a form letter. This letter will include the name and address information from this data file. I'm using Microsoft Word 2002 Office. I'm unable to find how to create this data file. Can someone help me? Also, how can I...
June 11th 05 04:00 AM
by Graham Mayor Go to last post
2 1,230
creating labels, not addresses, from an Excel file by some_guy79
I have excel files that I would like to extract information from and put it onto labels. I've tried to use the Mail Merge function in Word to do this, but have had no luck. Right now when I preview or print labels I get a sheet full of labels with "Next Record" printed on each label. The label...
June 11th 05 03:54 AM
by Graham Mayor Go to last post
1 1,067
Add 30 days to Date by [email protected]
I need to add 30 or 45 days to the current date. I've followed a few links, that for example add 301 days to a date I get the wrong date but it's not so noticable, it's off by a month or so, and if I add 30 days I get exactly 90 days out! Trying different inputs I get similar wrong dates. So,...
June 10th 05 10:49 PM
by Peter Jamieson Go to last post
5 5,845
View Merged Data button not working by AlanMagpie
Sorted! The required setting is: Tools, Options, View and to uncheck the View Field Codes check box. -- AlanMagpie
June 10th 05 10:02 PM
by AlanMagpie Go to last post
0 1,000
Post New Thread


Display Options
Showing threads 10121 to 10140 of 12024
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:29 AM.


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