|
|
I am doing a small mail merge using a word doc and an excel spreadsheet as my
data source. The first and last names are separate columns in the
spreadsheet. When I create the address block, it properly aligns the first
and last name. When I try to to the greeting line, I specify the foramt as
Dear Mr. 'Lastname' but word refuses to just use the last name. It will
constantly overwrite it with first and last name. I don't understand why
when the data fields for first and last name are separate. Any help please?
|
|
If you press Alt+F9 to toggle on the display of the field codes in the
mailmerge main document, what do you see?
--
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
"brodiemac" <brodiemac[ at ]discussions.microsoft.com> wrote in message
news:01BDB757-0E2F-419D-9437-3EF22A3F7831[ at ]microsoft.com...
[Quoted Text] >I am doing a small mail merge using a word doc and an excel spreadsheet as
>my
> data source. The first and last names are separate columns in the
> spreadsheet. When I create the address block, it properly aligns the
> first
> and last name. When I try to to the greeting line, I specify the foramt
> as
> Dear Mr. 'Lastname' but word refuses to just use the last name. It will
> constantly overwrite it with first and last name. I don't understand why
> when the data fields for first and last name are separate. Any help
> please?
|
|
{GREETINGLINE\f"<<BEFORE_Dear>><<TITLE0_>><<_LAST_>> <<_AFTER_,>>"\1 1033 \e
Dear Sir or Madam,"}
I would assume I just remove the <<_LAST_>> to fix it? Question is, why is
it putting it in there in the first place. Also, when I choose to use just
the last name and not the first, it works fine. I think maybe something that
needs to be fixed by MS?
"Doug Robbins - Word MVP" wrote:
[Quoted Text] > If you press Alt+F9 to toggle on the display of the field codes in the
> mailmerge main document, what do you see?
>
> --
> 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
>
> "brodiemac" <brodiemac[ at ]discussions.microsoft.com> wrote in message
> news:01BDB757-0E2F-419D-9437-3EF22A3F7831[ at ]microsoft.com...
> >I am doing a small mail merge using a word doc and an excel spreadsheet as
> >my
> > data source. The first and last names are separate columns in the
> > spreadsheet. When I create the address block, it properly aligns the
> > first
> > and last name. When I try to to the greeting line, I specify the foramt
> > as
> > Dear Mr. 'Lastname' but word refuses to just use the last name. It will
> > constantly overwrite it with first and last name. I don't understand why
> > when the data fields for first and last name are separate. Any help
> > please?
>
>
>
|
|
Strike my comment about remove the "<<_LAST_>>" from there.
"brodiemac" wrote:
[Quoted Text] > {GREETINGLINE\f"<<BEFORE_Dear>><<TITLE0_>><<_LAST_>> <<_AFTER_,>>"\1 1033 \e
> Dear Sir or Madam,"}
>
> I would assume I just remove the <<_LAST_>> to fix it? Question is, why is
> it putting it in there in the first place. Also, when I choose to use just
> the last name and not the first, it works fine. I think maybe something that
> needs to be fixed by MS?
>
> "Doug Robbins - Word MVP" wrote:
>
> > If you press Alt+F9 to toggle on the display of the field codes in the
> > mailmerge main document, what do you see?
> >
> > --
> > 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
> >
> > "brodiemac" <brodiemac[ at ]discussions.microsoft.com> wrote in message
> > news:01BDB757-0E2F-419D-9437-3EF22A3F7831[ at ]microsoft.com...
> > >I am doing a small mail merge using a word doc and an excel spreadsheet as
> > >my
> > > data source. The first and last names are separate columns in the
> > > spreadsheet. When I create the address block, it properly aligns the
> > > first
> > > and last name. When I try to to the greeting line, I specify the foramt
> > > as
> > > Dear Mr. 'Lastname' but word refuses to just use the last name. It will
> > > constantly overwrite it with first and last name. I don't understand why
> > > when the data fields for first and last name are separate. Any help
> > > please?
> >
> >
> >
|
|
Don't use the GREETING LINE thing, or the ADDRESSBLOCK for that matter.
Just insert the merge fields that YOU want in the configuration that YOU
want them.
--
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
"brodiemac" <brodiemac[ at ]discussions.microsoft.com> wrote in message
news:ACFF0BB9-AE01-4860-8B67-24CA37C74886[ at ]microsoft.com...
[Quoted Text] > Strike my comment about remove the "<<_LAST_>>" from there.
>
> "brodiemac" wrote:
>
>> {GREETINGLINE\f"<<BEFORE_Dear>><<TITLE0_>><<_LAST_>> <<_AFTER_,>>"\1 1033
>> \e
>> Dear Sir or Madam,"}
>>
>> I would assume I just remove the <<_LAST_>> to fix it? Question is, why
>> is
>> it putting it in there in the first place. Also, when I choose to use
>> just
>> the last name and not the first, it works fine. I think maybe something
>> that
>> needs to be fixed by MS?
>>
>> "Doug Robbins - Word MVP" wrote:
>>
>> > If you press Alt+F9 to toggle on the display of the field codes in the
>> > mailmerge main document, what do you see?
>> >
>> > --
>> > 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
>> >
>> > "brodiemac" <brodiemac[ at ]discussions.microsoft.com> wrote in message
>> > news:01BDB757-0E2F-419D-9437-3EF22A3F7831[ at ]microsoft.com...
>> > >I am doing a small mail merge using a word doc and an excel
>> > >spreadsheet as
>> > >my
>> > > data source. The first and last names are separate columns in the
>> > > spreadsheet. When I create the address block, it properly aligns the
>> > > first
>> > > and last name. When I try to to the greeting line, I specify the
>> > > foramt
>> > > as
>> > > Dear Mr. 'Lastname' but word refuses to just use the last name. It
>> > > will
>> > > constantly overwrite it with first and last name. I don't understand
>> > > why
>> > > when the data fields for first and last name are separate. Any help
>> > > please?
>> >
>> >
>> >
|
|
Doesn't make much sense not to use a feature Microsoft inteneded to make life
easier but anyway....
The reason why it is not working is because word had no way of determining
if the addressee was a Mr. or a Mrs. Once I added a field for Gender and
matched it to the Courtesy Title, it worked just fine. Thanks for the help!
"Doug Robbins - Word MVP" wrote:
[Quoted Text] > Don't use the GREETING LINE thing, or the ADDRESSBLOCK for that matter.
> Just insert the merge fields that YOU want in the configuration that YOU
> want them.
>
> --
> 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
>
> "brodiemac" <brodiemac[ at ]discussions.microsoft.com> wrote in message
> news:ACFF0BB9-AE01-4860-8B67-24CA37C74886[ at ]microsoft.com...
> > Strike my comment about remove the "<<_LAST_>>" from there.
> >
> > "brodiemac" wrote:
> >
> >> {GREETINGLINE\f"<<BEFORE_Dear>><<TITLE0_>><<_LAST_>> <<_AFTER_,>>"\1 1033
> >> \e
> >> Dear Sir or Madam,"}
> >>
> >> I would assume I just remove the <<_LAST_>> to fix it? Question is, why
> >> is
> >> it putting it in there in the first place. Also, when I choose to use
> >> just
> >> the last name and not the first, it works fine. I think maybe something
> >> that
> >> needs to be fixed by MS?
> >>
> >> "Doug Robbins - Word MVP" wrote:
> >>
> >> > If you press Alt+F9 to toggle on the display of the field codes in the
> >> > mailmerge main document, what do you see?
> >> >
> >> > --
> >> > 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
> >> >
> >> > "brodiemac" <brodiemac[ at ]discussions.microsoft.com> wrote in message
> >> > news:01BDB757-0E2F-419D-9437-3EF22A3F7831[ at ]microsoft.com...
> >> > >I am doing a small mail merge using a word doc and an excel
> >> > >spreadsheet as
> >> > >my
> >> > > data source. The first and last names are separate columns in the
> >> > > spreadsheet. When I create the address block, it properly aligns the
> >> > > first
> >> > > and last name. When I try to to the greeting line, I specify the
> >> > > foramt
> >> > > as
> >> > > Dear Mr. 'Lastname' but word refuses to just use the last name. It
> >> > > will
> >> > > constantly overwrite it with first and last name. I don't understand
> >> > > why
> >> > > when the data fields for first and last name are separate. Any help
> >> > > please?
> >> >
> >> >
> >> >
>
>
>
|
|
You will find the recommendation not to use the AddressBlock is given very
frequently in this newsgroup.
--
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
"brodiemac" <brodiemac[ at ]discussions.microsoft.com> wrote in message
news:0D7AF66C-F4D3-4FE5-AB7C-99D94EE33488[ at ]microsoft.com...
[Quoted Text] > Doesn't make much sense not to use a feature Microsoft inteneded to make
> life
> easier but anyway....
>
> The reason why it is not working is because word had no way of determining
> if the addressee was a Mr. or a Mrs. Once I added a field for Gender and
> matched it to the Courtesy Title, it worked just fine. Thanks for the
> help!
>
> "Doug Robbins - Word MVP" wrote:
>
>> Don't use the GREETING LINE thing, or the ADDRESSBLOCK for that matter.
>> Just insert the merge fields that YOU want in the configuration that YOU
>> want them.
>>
>> --
>> 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
>>
>> "brodiemac" <brodiemac[ at ]discussions.microsoft.com> wrote in message
>> news:ACFF0BB9-AE01-4860-8B67-24CA37C74886[ at ]microsoft.com...
>> > Strike my comment about remove the "<<_LAST_>>" from there.
>> >
>> > "brodiemac" wrote:
>> >
>> >> {GREETINGLINE\f"<<BEFORE_Dear>><<TITLE0_>><<_LAST_>> <<_AFTER_,>>"\1
>> >> 1033
>> >> \e
>> >> Dear Sir or Madam,"}
>> >>
>> >> I would assume I just remove the <<_LAST_>> to fix it? Question is,
>> >> why
>> >> is
>> >> it putting it in there in the first place. Also, when I choose to use
>> >> just
>> >> the last name and not the first, it works fine. I think maybe
>> >> something
>> >> that
>> >> needs to be fixed by MS?
>> >>
>> >> "Doug Robbins - Word MVP" wrote:
>> >>
>> >> > If you press Alt+F9 to toggle on the display of the field codes in
>> >> > the
>> >> > mailmerge main document, what do you see?
>> >> >
>> >> > --
>> >> > 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
>> >> >
>> >> > "brodiemac" <brodiemac[ at ]discussions.microsoft.com> wrote in message
>> >> > news:01BDB757-0E2F-419D-9437-3EF22A3F7831[ at ]microsoft.com...
>> >> > >I am doing a small mail merge using a word doc and an excel
>> >> > >spreadsheet as
>> >> > >my
>> >> > > data source. The first and last names are separate columns in the
>> >> > > spreadsheet. When I create the address block, it properly aligns
>> >> > > the
>> >> > > first
>> >> > > and last name. When I try to to the greeting line, I specify the
>> >> > > foramt
>> >> > > as
>> >> > > Dear Mr. 'Lastname' but word refuses to just use the last name.
>> >> > > It
>> >> > > will
>> >> > > constantly overwrite it with first and last name. I don't
>> >> > > understand
>> >> > > why
>> >> > > when the data fields for first and last name are separate. Any
>> >> > > help
>> >> > > please?
>> >> >
>> >> >
>> >> >
>>
>>
>>
|
|
|