Using background in mailmerge?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Rachael - 12 Jun 2006 18:43 GMT

I want to create a simple mailmerge for our company. We use timesheets to
record time spent on files, one per week.

At the beginning of each 2 week pay perior our receptionist has to MANUALLY
write everone's name on their own sheet, as well as the dates of the week,
and other simple data.

I was wondering if there is a way to use the scanned document (which I
already scanned) and use it as a background, and create mailmerge fields
where I could create a database of all the employees, so that each one
doesn't need to be written by hand (about 50 + per week).

Thanks.

Reply to this Message

Doug Robbins - Word MVP - 13 Jun 2006 04:47 GMT

Mailmerge can certainly be used to populate the time cards. Using the
scanned document as background can be done, but it may be better to
reconstruct the form as a Word document.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

>I want to create a simple mailmerge for our company. We use timesheets to
> record time spent on files, one per week.
[quoted text clipped - 10 lines]
>
> Thanks.

Reply to this Message

Rachael - 13 Jun 2006 14:48 GMT

That's what I was thinking, but management has specifically asked that NO
changes be made and I MUST use a scanned copy of the form if I am going to do
this.

I am using Office 97, if that helps.

My problem is that when I insert the scanned copy as a background, it is
portrait, but I need it landscape. Because it is a background, for some
reason, the view defaults to "online view" and I can't get it to view
landscape. Therefore, I can't enter in fields or data.

Any ideas?

> Mailmerge can certainly be used to populate the time cards. Using the
> scanned document as background can be done, but it may be better to
[quoted text clipped - 14 lines]
> >
> > Thanks.

Reply to this Message

Rachael - 13 Jun 2006 17:01 GMT

Wait. never mind. I figured it out. I used Insert Picture and did it that
way, instead of a background and it worked.

> That's what I was thinking, but management has specifically asked that NO
> changes be made and I MUST use a scanned copy of the form if I am going to do
[quoted text clipped - 27 lines]
> > >
> > > Thanks.

Reply to this Message

Doug Robbins - Word MVP - 13 Jun 2006 19:43 GMT

You will probably need to rotate the image in some graphics software and
then insert it into a Word document and format it so that it si behind the
text. You would then position the text that you want to insert in the
appropriate places, probably using a table with fixed cell dimensions so
that things to not move around.

Signature

Hope this helps.

Please reply to the newsgroup unless you wish to avail yourself of my
services on a paid consulting basis.

Doug Robbins - Word MVP

> That's what I was thinking, but management has specifically asked that NO
> changes be made and I MUST use a scanned copy of the form if I am going to
[quoted text clipped - 31 lines]
>> >
>> > Thanks.

Reply to this Message