MailMerge and VBA

  • Thread starter Thread starter User
  • Start date Start date
U

User

Hi All,

When I prepare a MailMerge in Word97 and record a macro
during such preparing I can get a VBA code in the Visual
Basic Editor for the whole preparation. Then I can save
it as a .bas file.
The question is : if I have already done MailMerge files
(with << ... >>), is there any method to get the VBA code
automatically, i.e. without repeating the process of
recording a macro?
I can use a newer version of MS Word.

Please tell me how to do it if you know.

Regards
User
 
Hi User,

The <...> fields indicate that the mailmerge was done in the conventional way, via the creation/insertion of mailmerge fields, for
which vba is unnecessary. Although you could use vba to create/insert the fields, there is no vba code to get from them. If you want
to see the field coding, you can toggle it on/off via Alt-F9.

Cheers
 
Thanks for your reply.
Although you could use vba to create/insert the fields
Click to expand...
Could you tell me how to use vba to create/insert the fiels
or tell me where to find any description of doing it, please?

Regards
User

U¿ytkownik "macropod said:
Hi User,

The <...> fields indicate that the mailmerge was done in the conventional way, via the creation/insertion of mailmerge fields, for
which vba is unnecessary. Although you could use vba to create/insert the fields, there is no vba code to get from them. If you
want to see the field coding, you can toggle it on/off via Alt-F9.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

User said:
Hi All,

When I prepare a MailMerge in Word97 and record a macro
during such preparing I can get a VBA code in the Visual
Basic Editor for the whole preparation. Then I can save
it as a .bas file.
The question is : if I have already done MailMerge files
(with << ... >>), is there any method to get the VBA code
automatically, i.e. without repeating the process of
recording a macro?
I can use a newer version of MS Word.

Please tell me how to do it if you know.

Regards
User
Click to expand...
Click to expand...
 
Hi User,

Check out the Add method in the VBE help files.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

User said:
Thanks for your reply.
Although you could use vba to create/insert the fields
Click to expand...
Could you tell me how to use vba to create/insert the fiels
or tell me where to find any description of doing it, please?

Regards
User

U¿ytkownik "macropod said:
Hi User,

The <...> fields indicate that the mailmerge was done in the conventional way, via the creation/insertion of mailmerge fields,
for which vba is unnecessary. Although you could use vba to create/insert the fields, there is no vba code to get from them. If
you want to see the field coding, you can toggle it on/off via Alt-F9.

Cheers
--
macropod
[MVP - Microsoft Word]
-------------------------

User said:
Hi All,

When I prepare a MailMerge in Word97 and record a macro
during such preparing I can get a VBA code in the Visual
Basic Editor for the whole preparation. Then I can save
it as a .bas file.
The question is : if I have already done MailMerge files
(with << ... >>), is there any method to get the VBA code
automatically, i.e. without repeating the process of
recording a macro?
I can use a newer version of MS Word.

Please tell me how to do it if you know.

Regards
User
Click to expand...
Click to expand...
Click to expand...
 
Back
Top