Reply
 
Thread Tools Display Modes
  #1   Report Post  
Posted to microsoft.public.word.newusers
User[_2_] User[_2_] is offline
external usenet poster
 
Posts: 2
Default MailMerge and VBA

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
  #2   Report Post  
Posted to microsoft.public.word.newusers
macropod macropod is offline
external usenet poster
 
Posts: 1,002
Default MailMerge and VBA

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" wrote in message ...
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


  #3   Report Post  
Posted to microsoft.public.word.newusers
User[_2_] User[_2_] is offline
external usenet poster
 
Posts: 2
Default MailMerge and VBA

Thanks for your reply.

Although you could use vba to create/insert the fields

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" napisał w wiadomości ...
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" wrote in message ...
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



  #4   Report Post  
Posted to microsoft.public.word.newusers
macropod macropod is offline
external usenet poster
 
Posts: 1,002
Default MailMerge and VBA

Hi User,

Check out the Add method in the VBE help files.

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

"User" wrote in message ...
Thanks for your reply.

Although you could use vba to create/insert the fields

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" napisał w wiadomości ...
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" wrote in message ...
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




Reply
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
mailmerge cookie Mailmerge 8 September 25th 07 06:46 PM
Mailmerge Waldo Mailmerge 1 November 20th 06 07:28 PM
Using mailmerge in XP? kmcmahon Mailmerge 1 September 6th 06 11:00 PM
mailmerge chuckz Mailmerge 1 July 20th 05 10:47 AM
mailmerge Sean Murdoch Mailmerge 1 February 24th 05 06:04 AM


All times are GMT +1. The time now is 06:58 PM.

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"