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
How do I format a phone number in a mail merge field? by Halley
I tried the following, and it did nothing. I tried a few other variations, but they all gave me errors. { MERGEFIELD "PHONE" \"(###) ###-####"}
(Multi-page thread 1 2)
September 17th 20 11:50 AM
by henryjones147 Go to last post
11 14,504
Manually Inputting Mail Merge Links by CidtheSquid
Hi everyone! I have lots of similar excel documents and happily mail merge to Word using the mail merge wizard successfully. My problem is I want to create one Word document (like a template) that can be used with all the Excel documents, this would work for the generic columns/fields. BUT......
June 30th 20 04:25 PM
by CidtheSquid Go to last post
0 643
Adding in names across 8 document templates by joxner
I assist in drafting Estate Documents for people and families that want an estate plan, but do not have much to leave. We typically draft about 8 documents from Word templates for each person. At present, we send out an estate planning questionnaire to our clients. Once we receive their...
June 27th 20 05:49 AM
by joxner Go to last post
0 218
Editing header/footer in merged doc by libFL
I have a long merged document that contains a header and footer. I am trying to delete the header/footer in the merged doc but it will only change the first page. Is there a way to do this, or do i have to change it in the source document and remerge?
May 29th 20 08:02 PM
by Budy Go to last post
2 2,591
Can I do mail merge using more fields than whats on mail merge wizard by shreked
Hi I know how to use mail merge wizard but that only merges names and addresses. What Im trying to do is put other data in and it merges into a document. I.E with ref to your application no (no from mail merge data) I am writing Is there anyway i can do this?
May 20th 20 01:50 PM
by shreked Go to last post
0 392
SKIP IF Duplicate by istate2009
Hello! I am trying to pull data from a source that has some duplicate entries (records) and I want to skip any records if a field value already appears in the previous records Data Source AC01 | Red | Blue | Green AC01 | Blue | Yellow - Red AC02 | Green | Blue | Green AC02 | Blue | Red | Green
February 27th 20 06:30 PM
by istate2009 Go to last post
0 594
How can I use internat fax as default fax from Word 2007? by Lindsay McGibbon
I have Office 2007 and due to problems with my fax modem and WinFax (not fully compatible with Vista) have purchased internet fax software and license which allows me to send any document as an attachment via the internet. I can receive faxes the same way, via an email. At present this...
February 1st 20 09:38 AM
by Budy Go to last post
7 1,425
Dynamic Index for Mergefields by M. Hummel
In a mail merge, I need to create an index based on a Mergefield. When I try this, I get an index with every page listed and the MERGEFIED rather than the field contents which generated in the mail merge. Is there a way to create an index based on a mail merge field rather than static text? I have...
October 25th 19 01:14 PM
by M. Hummel Go to last post
0 846
Merge Field String Match Filtering by ken b
Very frustrated as can not make MERGEFIELDs work as every Help message I can find seems to indicate they should. I'm producing a directory but some people do not want their phone numbers or email info included, so in the directory, Excel DB, I included a field mask called "Hide" with the form...
September 24th 19 08:40 AM
by MichaelCPurvis Go to last post
1 2,505
Add a clickable image with a specific link for each recipient in mail merge by P-Lab
I have been trying to figure this out with no positive outcome. Anyone with an idea or a solution, please share. P-Lab
August 7th 19 03:04 PM
by P-Lab Go to last post
0 1,069
Retain / Reformat negative time from Excel to Word by Warrick
Hi There, Really need some advice here after cracking my head and searching for a long time. I have a negative time displayed in my excel sheet (e.g -01:22 mm:ss) which I would like to retain the format when I do a mail merge on MS word. However, the time gets converted to 01:22. I have tried to...
May 30th 19 10:46 AM
by neiljohanson Go to last post
1 1,695
If Then Else = Fail by MP1985
Never had this big a struggle with if then, but then I've never introduced a second variable. This works fine and dandy: { IF { MERGEFIELD f3 } = "Y" "{ MERGEFIELD f18 }" "{ MERGEFIELD f2 } (If party is a child, insert this name, if not insert that name). It's when I go for two conditions to...
May 30th 19 10:41 AM
by neiljohanson Go to last post
5 2,336
samsung printer error code u1-2320 by rosest962500
I want to share issues related to Samsung printer. Sometimes the issue may occur while printing important emails. Recover the issue with just one click, follow this quick fix guide samsung printer error code u1-2320. I had personally checked and had applied the steps to recover Samsung printer and...
May 18th 19 02:18 PM
by chothueaidaicuoi205 Go to last post
4 1,412
Formatting a field from a source with numbers and a sometimes a letter by shsnan08
Hi In my excel-sheet (source document) I have a column with ssnr in looking like "########-####" and some with "########-T###". The format in the column in excel is Custom "########-####". How can I merge this numbers in to my word document? Right now I have "{MERGEFIELD ssnr \#...
May 10th 19 12:21 PM
by shsnan08 Go to last post
0 1,031
Word Labels, No Paragraph Break if Field is Empty by Jarrett
I have been trying to create some labels and some of my fields are empty. The fields that may be empty a Address_2 ; Address_3 ; Address_4 and County This is what my default MailMerge looks like at the moment: «Title» «Last_Name» «Company» «Address_1» «Address_2»
April 13th 19 07:32 AM
by Nayna Go to last post
3 2,332
Selecting which sheet to use from Excel VBA by BAC
XP pro, Office 2003 pro I am trying to automate a mailing from multiple Excel workbooks. Even though I have only 1 worksheet in each book, my routine still pauses waiting for me to select the worksheet before completing the merge, How do i tell Word to continue, using the only worksheet there,...
April 11th 19 12:43 PM
by Nayna Go to last post
7 4,206
Mail Merge pick up 2nd row containing Titles from Excel Worksheet by [email protected]
This is a simple question but I can't remember how to do this. First of all I am using Microsoft Word 2003. What I am trying to do is a mail merge from an excel worksheet. Normally I have no problems doing this but unfortunately the worksheet I was given does not have the Title row as the first...
April 9th 19 02:18 PM
by Sheri Wood Go to last post
7 5,715
Include a list of hyperlinks from excel in one mail merge document by ashelton1
I have a spreadsheet with a list of Salesforce reports (column A), URLs to those reports (Column B), and the names of the report owners (Column C). I want to send the report owners an email that shows a list of reports, each on its own line and each one hyperlinked to the report in Salesforce. Some...
April 5th 19 08:43 PM
by ashelton1 Go to last post
0 1,021
1 Attachment(s) Mail Merge Multiple data from Excel...Help!!!!!! by nicole327
Ok, so I am trying to send out letters to students showing them how many missing assignments they have. I want to transfer this information using a mail merge. Is this possible? Some students have 2 some have 4 or 5. I want to transfer what assignments they are missing and then have it move on to...
February 9th 19 12:23 PM
by mikkelkasper Go to last post
1 1,751
sdc-3100 3-part multipurpose labels by Martha Holmes
I have lots of Stamps.com 3-part multi-purpose labels and would like to use them. Does anyone have a templat for them for use in mailing?
June 20th 18 08:47 PM
by Carroll Hanks Go to last post
2 4,614
Post New Thread

Display Options
Showing threads 1 to 20 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 08:08 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.