gudii9
asked on
Microsoft word mail merger with word 2007 to send personal email using macro or VB
Dear Praveen,
Microsoft word says that we should be able to do a Mail merge with Word 2007. Need to write a macro or VB code whichever is easy/faster. We have to send an urgent email to all members of say XYZ team with a more personal note like say Dear Abraham(i.e first name).
Dear Firstname,
<content of the letter>
Sincerely,
XYZ Team.
Please let us know how can we do it. Any ideas, resources, sample code highly appreciated. Thanks in advance.
Microsoft word says that we should be able to do a Mail merge with Word 2007. Need to write a macro or VB code whichever is easy/faster. We have to send an urgent email to all members of say XYZ team with a more personal note like say Dear Abraham(i.e first name).
Dear Firstname,
<content of the letter>
Sincerely,
XYZ Team.
Please let us know how can we do it. Any ideas, resources, sample code highly appreciated. Thanks in advance.
ASKER
Microsoft word Ribbon has the merge option right. Not sure how to use that.
>>so are you quite sure you need a Custom Macro or VBA to do this...
I am not good in VBA/Macros, But if there is a easy way to do it .Please advise
>>so are you quite sure you need a Custom Macro or VBA to do this...
I am not good in VBA/Macros, But if there is a easy way to do it .Please advise
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If your merge data in Access?
<Microsoft word says that we should be able to do a Mail merge with Word 2007.>
Sure, just use the Mail Merge Wizard:
Mailings-->Start Mail Merge-->Start Mail Merge-->Step by step mail merge wizard...
<Need to write a macro or VB code whichever is easy/faster.>
Once the mail Merge wizard is run once, all you have to do is Merge the document for any other Mailings, so are you quite sure you need a Custom Macro or VBA to do this...
How good are you with VBA/Macros?
See here for links to threads on this here:
https://www.experts-exchange.com/searchResults.jsp?searchTerms=automate+Mail+mergs%2C+MS+Access&componentHtmlId=basicSearch&searchType=10
JeffCoachman