Solved

Acccess 2003: Automating Mail merge (question 2)

Posted on 2012-04-09
8
374 Views
Last Modified: 2012-04-09
Hi EE,

My colleague gave me a word doc that he used in his mail merge.

However, i needed to change the field names in his doc, to reflect the field names
of my excel data source.

When my vba runs the merge, the word doc STILL is looking for the old fields in the template.

i checked the template, and i do not see them there, however word is looking for them
as in the screen shot below.

do you have any ideas, how to find these fields?

tx, sandra

scrn
0
Comment
Question by:mytfein
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
  • 2
8 Comments
 
LVL 10

Expert Comment

by:plummet
ID: 37824804
Hi Sandra

What happens if you select a field from the list that's shown ("...valid merge field from the data source...")? That list should be based on your excel source, or is it showing the old fields from your colleague?

Regards
John
0
 

Author Comment

by:mytfein
ID: 37824817
Hi John,

tx for writing....

the tool bar buttons are mostly greyed out, so cannot attempt your idea

any way to use the tool bar?

tx, s
0
 
LVL 76

Expert Comment

by:GrahamSkan
ID: 37824861
It may be that the MergeField is nested in another field, such an IF field, so won't be visible.

Try using the Alt+F9 toggle to show the field codes instead of the field results.


Remember that the correct use of a Template (after it has been designed) should not involve changing it.  It is used used to create (e.g. by File/New) a Document that is based on it and which has access to that Template's facilities such as the macro code and styles.

Incidentally, although not formally a Template in the Word sense, a mail merge main Document is also not changed during the execution of a mail merge, so is a template (with a small 't') in effect.
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

Author Comment

by:mytfein
ID: 37824901
Hi John,

so i went to template and manually set the data source

my header in excel do not have hyphens, but when i insert the field into document

it comes along with hyphens for the spaces.... is that valid to happen?

Also, now i can view the toolbar, and if i click on field list, the fields are what i want with

embedded spaces as in the excel spreadsheet....

so i do not understand why when i import the spreadsheet, the spaces are being replaced with hyphens

and the field list does not show the fields that word says are in the document....

sigh....tx...s
0
 
LVL 10

Expert Comment

by:plummet
ID: 37824929
I wonder if you're now seeing 'codes' where the spaces are, that's possible if you have toggled field codes on. How about trying to print a page to see if it looks OK? Also, is the merged data what you actually want, in the right place?

You''ll get there!

John
0
 
LVL 76

Accepted Solution

by:
GrahamSkan earned 500 total points
ID: 37824989
If your datasource field names contain spaces (legal), they will be replaces by underscores because a merge field name cannot contain spaces.
0
 

Author Comment

by:mytfein
ID: 37825001
hi John,

u know what's weird:

if i copy <<clerkship title 1>> to another place and modify the 1 to a 2,

it does not bring in <<clerkship title 2>>, but clerkship title 1 again,

so i create a brand new doc, and am using the field list to insert

ist that the way it works, that i cannot copy and past and modify the pasted fields

name?
0
 

Author Comment

by:mytfein
ID: 37825098
Hi Graham,

do u have any thoughts on copy/pasting a merge field and then modifying the name of the copied field.... it seems that it did "no take" and i hot to copy it from the clicking the field
list icon

also can u pls check out another new merge question that i posted.... tx, s
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question