• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA Marco

B

Bhargavasharma

New Member
Dear All,

I am preparing some set of certificates for my organization ( close to 450 certificates), in all the certificates they are some common places where I have to make the common changes like issuing authority, name of the bank and address etc.

In future I may need change those address and replace it with new ones.

Can some one please guide, if there is any way in VBA or macros, such I can prepare a table with all the updated information such that all the certificates should get updated in the relevant fields.


Request you to respond at the earliest.

With regards,
Bhargava Sharma V
 
I'd setup a certificate in Word
Then setup a table of Names, Positions etc in Excel
Then use Mail Merge within Word
 
Thanks a lot for the reply, but can you please provide an example of the same with the word and excel document.

Moreover can I do the mail merger for 400 certificates??
 
In Excel setup a single worksheet with all the fields you want as Columns
Make sure there are headers at the top of each field

In Word setup a document
Goto each field position
Use the Mail Merge Tab to insert fields in the appropriate positions
Do the Mail Merge

Yes, you can do 400 pages
You can do as many pages as your memory will allow

It is fairly straight forward

For more help try Google: How to Mail Merge in Word xxxx
 
You must log in or register to reply here.
Back
Top