Flexible field lengths

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I wish to create a form letter that draws information from my database. Using
the mailmerge option in Word has proved unwieldly, so I created a report in
Access. However, this report is replete with formatting errors, like this:

It was a pleasure seeing George in my office today. I look forward
to future visits.

Is it possible to insert a field in the middle of a paragraph, like so:

It was a pleasure seeing (StudentName) in my office today. I look forward to
future visits.

and have the spacing not get messed up as in the first sentence? If anyone
has suggestions, please let me know. Thanks!

MS Access 2003
 
Danny said:
I wish to create a form letter that draws information from my database. Using
the mailmerge option in Word has proved unwieldly, so I created a report in
Access. However, this report is replete with formatting errors, like this:

It was a pleasure seeing George in my office today. I look forward
to future visits.

Is it possible to insert a field in the middle of a paragraph, like so:

It was a pleasure seeing (StudentName) in my office today. I look forward to
future visits.

and have the spacing not get messed up as in the first sentence? If anyone
has suggestions, please let me know. Thanks!

MS Access 2003
Click to expand...

What was unwieldy about Word? I've generally found that an easier way
to do my mail merge. However, this can be done easily in Access.

Instead of labels and text boxes in your reports, use a single text box
per paragraph (as wide as you want the paragraph to be) Change Can
Grow to Yes

Then set Control Source to:
="It was a pleasure seeing " & [StudentName] & " in my office today. I
look forward to
future visits."

--Sarah Schreffler
 
It seems so easy now, thank you for your help.

As for the mailmerge option in word, I am looking for it to pull specific
records out of my database, rather than creating a mass-mailing, which seems
to be the default. Your suggestion should help obviate my need for that one.
Thanks

Sarah Schreffler said:
Danny said:
I wish to create a form letter that draws information from my database. Using
the mailmerge option in Word has proved unwieldly, so I created a report in
Access. However, this report is replete with formatting errors, like this:

It was a pleasure seeing George in my office today. I look forward
to future visits.

Is it possible to insert a field in the middle of a paragraph, like so:

It was a pleasure seeing (StudentName) in my office today. I look forward to
future visits.

and have the spacing not get messed up as in the first sentence? If anyone
has suggestions, please let me know. Thanks!

MS Access 2003
Click to expand...

What was unwieldy about Word? I've generally found that an easier way
to do my mail merge. However, this can be done easily in Access.

Instead of labels and text boxes in your reports, use a single text box
per paragraph (as wide as you want the paragraph to be) Change Can
Grow to Yes

Then set Control Source to:
="It was a pleasure seeing " & [StudentName] & " in my office today. I
look forward to
future visits."

--Sarah Schreffler
Click to expand...
 
Create a query in Access that brings up the records you want.
Then you can base the mail merge in Word on that query and get only the
info in those records.

Your welcome.
It seems so easy now, thank you for your help.

As for the mailmerge option in word, I am looking for it to pull specific
records out of my database, rather than creating a mass-mailing, which seems
to be the default. Your suggestion should help obviate my need for that one.
Thanks

Sarah Schreffler said:
Danny said:
I wish to create a form letter that draws information from my database. Using
the mailmerge option in Word has proved unwieldly, so I created a report in
Access. However, this report is replete with formatting errors, like this:

It was a pleasure seeing George in my office today. I look forward
to future visits.

Is it possible to insert a field in the middle of a paragraph, like so:

It was a pleasure seeing (StudentName) in my office today. I look forward to
future visits.

and have the spacing not get messed up as in the first sentence? If anyone
has suggestions, please let me know. Thanks!

MS Access 2003
Click to expand...

What was unwieldy about Word? I've generally found that an easier way
to do my mail merge. However, this can be done easily in Access.

Instead of labels and text boxes in your reports, use a single text box
per paragraph (as wide as you want the paragraph to be) Change Can
Grow to Yes

Then set Control Source to:
="It was a pleasure seeing " & [StudentName] & " in my office today. I
look forward to
future visits."

--Sarah Schreffler
Click to expand...
Click to expand...
 
Back
Top