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
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,231
(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,909
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,250
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,499
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,653
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,928
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,764
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,923
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,908
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,488
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,279
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,192
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,726
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,479
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,853
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,430
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,882
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,488
Help With Word Macro by compusheaf
I have created mailmerge. My data has a heading and a paragraph. I want to copy all the headings and paste them at the top page. Secondly the headings pasted at the top should have a hyperlink, when clicked it should take us to the corresponding paragraph below.
November 17th 10 10:05 AM
by aleshaabbot Go to last post
1 1,192
Red face
solution needed to prevent empty merged cells showing on document as a zero by peter Smith
I use word 2003 and I am merging from Excel I am making a lease, the excel documents allows up to 12 people on the lease if there are only 6 or 8 I have many entries on Word that just show up as lower case zeros. this is also true if the person...
November 16th 10 03:14 PM
by peter Smith Go to last post
0 1,323
Post New Thread


Display Options
Showing threads 181 to 200 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 06:13 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.