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
Drawing a circle or box with merge data by aplarsen
At my school, we merge in a bunch of data to create a snapshot of each student for scheduling purposes. We call it the scheduling rubric. An example is attached below: http://img222.imageshack.us/img222/1952/screencapformessageboar.png Uploaded with ImageShack.us Each student receives a score...
April 5th 11 04:12 PM
by Big_Al Go to last post
1 4,044
Word Doesn't Save Database Location by Joycrcc
Has Word changed the way it does mail merges? I have many templates set up and was used to opening them and having the database already connected and my sort preferences saved. Now it will NOT save the connection to the database. I have to do the whole pointing to the database and telling it...
January 27th 11 08:37 PM
by Joycrcc Go to last post
0 1,807
Exclamation
Multiple Document Merge Word 2007 by TDHarris
I'm having issues creating a main document that references multiple letters and receipt types, but utilizes the same datasource. I need to be able to create the appropriate letter, envelope,receipt merge based on letter type code in the data source. Is the best option merge fields? Macros?...
January 26th 11 03:23 PM
by TDHarris Go to last post
0 2,244
(If Statement) Making Address Look Pretty by NYCNAS
«FAREG» «FACUADD» «FACUCITY», «FACUSTATE» «FACUPSTCDE»-«FACUPSTEXT» JOHN DOE & JANE; SMITH JT TEN; 1000 SPRINGFIELD AVE; PHILADELPHIA, PA 19152-1204 What I am trying to do is have an if statement for when the character ";" is found within the FAREG field, it will create a line break. For the...
January 21st 11 06:35 PM
by NYCNAS Go to last post
0 1,924
Merging Excel 2007 into Word - need number to appear as percentage by J.A.Hamilton2011
Is there a switch I can add to a merge field that will format a number (pulled from Excel spreadsheet) into a percentage? I successfully used the switch to format a number into dollars (thank you Connie Miller) but now need to format one number as a percentage. When it pulls from Excel I'm...
January 13th 11 10:11 PM
by J.A.Hamilton2011 Go to last post
0 2,263
Question
insert photo in mail merge by dynomite
I am currently trying to create photo id cards and every time I insert the photo the merge fields don't work
January 13th 11 11:44 AM
by Ivo Go to last post
1 4,524
Set Up Digital Signature Setup with Mail Merge by Ivo
Hi All, To get a statement from multiple users, I want to use a template with a customized digital signature field. I'm looking for a way to mailmerge the digital signature setup in the mailing. E.g. the suggested signer in letter 1 should be "Ivo" and the suggested signer in letter 2 should be...
January 13th 11 10:44 AM
by Ivo Go to last post
0 2,664
Edit Recipient List doesn't exclude any records by littlepetel
We have recently upgraded Office to 2007. I have a Word 2007 mailmerge document which works fine, linked to an Excel 2007 spreadsheet. My problems occur when I try to edit the Recipient List. First, in the "Mail Merge Recipients" box, a date column in the spreadsheet formatted in dd/mm/yyyy (UK...
January 11th 11 04:28 AM
by littlepetel Go to last post
0 1,936
parse the output of mailmerge by Andy DePauw
I am doing a mailmerge using data from a sql database. the merged email address output is emailaddress plus #mailto:emailaddress# is there a switch or something to parse the merged results to remove the #mailto:emailaddress# so my output is just the email address thanks for any suggestions
January 7th 11 01:56 AM
by Andy DePauw Go to last post
0 1,775
Mail merge code not working properly by jgomez
Okay what I'm doing is sending out several demands to customers and I wrote this code: { MERGEFIELD Send_to_Full_Name \* Caps \b "and" } But when I'm on step 5 (preview of letters) it has: Ex. And JANE Doe I would like it to show:
December 29th 10 07:58 PM
by jgomez Go to last post
0 1,932
Red face
MailMerge changes some text to 0 by valerie-s
I am using an Office 2007, .xlxs file and .docx. I took an Excel file I used last year without issue, did a save as to update the year in the filename, and that was the only change I made. When I went to merge, it's changing the data in a column (when there is data present) to 0 (zero). If there's...
December 27th 10 10:09 PM
by valerie-s Go to last post
0 1,918
ASK function - how to avoid changing default after merging by BrendonJohnson
I am using the ASK function for a mail merge, which includes default text in the REF fields in the template. After I perform a mail merge, the text at each REF field changes to the answers I indicated in the ASK prompts when merging IN MY TEMPLATE. The ASK fields still indicate my original default...
December 22nd 10 04:33 PM
by BrendonJohnson Go to last post
0 1,496
Supressing Company Name If Home is Mailing Address by mikes8500
Hi I'm doing a mail merge from Outlook, and I'm trying to figure out how I could supress the company name if the mailing address is set for a home address. Many thanks Mike
December 10th 10 05:15 PM
by mikes8500 Go to last post
0 1,287
Preview Losing Code by Dennis Mueller
I'm trying to set up an example of conditional printing of fields for a friend. Basically using the If Mergefield.... It works fine but when I click on Preview I can walk thru the data to make sure it working. However, I can't return to the view of the document where it shows the coding that I...
December 4th 10 04:24 AM
by Dennis Mueller Go to last post
0 1,202
Smile
how to merge excel sheet with decimal numbers to word document by nalinda
here it is very simple for me what i do is select and copy the excel data base to a word document.(excel data base containing with headers ). paste on word doc will paste data base as table .Then save the word doc with suitable name in a suitable place . Use this word doc as existing data base...
November 29th 10 02:21 PM
by nalinda Go to last post
0 1,734
In need of Mail Merge help by YellowMnM
I am attempting to mail merge a 5 page Word document using data I input into an Excel spreadsheet. The problem I am running into is the spreadsheet contains information for multiple employers, which is fine; however, within each employer there are multiple employees that I am attempting to list...
November 22nd 10 08:50 PM
by YellowMnM Go to last post
0 1,488
Document unique numbering by JamesF
I urgently need to achieve the following: 1. A document with "some kind of field" in the Header into which a unique number could be entered (either manually or by Mail Merge) - an example of the number format would be QCMR-10-1234, with the last 4 digits being the unique part. 2. This number...
November 22nd 10 10:50 AM
by JamesF Go to last post
0 1,862
Add text to every 50:th page? by Nystrom
I use a fixed letter template with merge fields that merge names and addresses from a .txt file. When a large number of documents are printed I want a mark added (an X at the corner of the page) to every 50:th page. This is to easier sort the documents when sorting the printed pages. Anyone knows...
November 19th 10 09:11 PM
by Nystrom Go to last post
0 1,439
Can you force labels to print vertically instead of horizontally? by TechnoMom
I am using Word Mail Merge to print labels for use as a school directory. The data is being selected out of an Excel spreadsheet. Each page has 2 columns of name/address information. I would like the labels to print vertically, like this: Student A Student D Student B Student...
November 18th 10 06:26 PM
by ErikaC Go to last post
2 5,901
mailmerge by Smurf
Since 2007 version of Word mailmerge has become more complicated rather than less so. this is mainly because of the fields that are automatically given to the address block, which are American. To by pass these can be complicated and requires trial and error. Also if you put in a field at a...
November 17th 10 10:08 AM
by aleshaabbot Go to last post
2 1,497
Post New Thread


Display Options
Showing threads 181 to 200 of 12026
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 07:43 PM.


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.