Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Merge data from Access

Status
Not open for further replies.

cramd

Programmer
Mar 28, 2001
214
US
In MSWORD I have created a table two columns one row, within this table I want to place merged fields, in column 1, I want name, in column 2, I want fields address, city, and state. Now when I merge data from ACCESS into MSWORD it creates it's own table, a column for each field. I don't want that....I want to be able to place the fields in my table and create the merge, and for each record in Access, then add a row to my MSWORD table.....is this possible?
cramd
 
cramd,

I'm not sure that I understand.

You have inserted MERGEFIELDS for Name in one cell and Address[comma][space]City[comma][space]State in another cell.

Then when the MERGE is executed you get a COLUMN of Names and a THREE COLUMNS of Address, City, State? W

hat Document Type did you select when you set up the Mail Merge?

Skip,

[glasses] [red]Be advised:[/red] When transmitting sheet music...
If it ain't baroque, don't fax it! [tongue]
 
I just had a blank document open and began a mail merge. Followed the steps, pointed to my Access database and it brought over the data - each field in its own column. I haven't figured out how to do as you described: "You have inserted MERGEFIELDS for Name in one cell and Address[comma][space]City[comma][space]State in another cell"

Can I do that - and if so, what do I need? A predefined template?
cramd
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top