Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.word.mailmerge.fields
Jamie Steenberge Jamie Steenberge is offline
external usenet poster
 
Posts: 1
Default Access table to Mail Merge

I have a table with this information:

StudentID | LastName | FirstName | Grade | Subjects
103289 | Doe | Jane | 7 |
MathChr(9)43Chr(9)1,2,5Chr(13)Chr(10)ScienceChr(9) 61Chr(9)3,4
64897 | Does | John | 6 |
ArtChr(9)43Chr(9)1,2,5Chr(13)Chr(10)HistoryChr(9)6 1Chr(9)3EnglishChr(9)64Chr(9)4,8
54678 | Doer | Jill | 8 |
EnglishChr(9)38Chr(9)1

I need to know two things.

1 - Each row should be on it's own page

2 - The Subjects column is tab delimited, and if there are multiple records
there are return characters at the end of the preceding lines. I could make
it whatever for the delimiters though. I need to be able to place the
Subjects column in a table on the report.

How can this be done?

Thanks in advance,

Jamie


 
Thread Tools
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mail Merge does not include all records from list or Access table Paul Fahey Mailmerge 0 March 27th 06 12:08 AM
Mail Merge does not include all records from list or Access table Doug Robbins - Word MVP Mailmerge 0 March 26th 06 11:54 PM
Mail Merge from an Access Database table iholder Mailmerge 1 March 18th 06 11:57 AM
Can Word 2003 mail merge an Access value from a look-up table? Marge Mailmerge 1 January 17th 06 04:59 AM
Access to Word Table Mail Merge Tammi Mailmerge 6 November 7th 05 06:40 PM


All times are GMT +1. The time now is 10:01 AM.

Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 Microsoft Office Word Forum - WordBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Word"