[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 336
  • Last Modified:

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.
0
gudii9
Asked:
gudii9
  • 2
1 Solution
 
Jeffrey CoachmanMIS LiasonCommented:
What has this to do with MS Access?
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:
http://www.experts-exchange.com/searchResults.jsp?searchTerms=automate+Mail+mergs%2C+MS+Access&componentHtmlId=basicSearch&searchType=10

JeffCoachman
0
 
gudii9Author Commented:
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
0
 
Jeffrey CoachmanMIS LiasonCommented:
<Microsoft word Ribbon has the merge option right. Not sure how to use that.>
Then learning the subtleties of Mail Merge should be your first priority here, not "automation" (VBA/macros) or "emailing"...
make sense?
http://www.youtube.com/watch?v=_Lrn3tgwR08
http://office.microsoft.com/en-us/word-help/mail-merge-i-use-mail-merge-for-mass-mailings-RZ010277841.aspx
http://www.youtube.com/watch?v=_9ExKwXQ3KQ
...et al

<Not sure how to use that.>
Can you try?
It is fairly straightforward, ...(if you have everything set up already)

Again, do you really *Need* a macro...?
<But if there is a easy way to do it >
If you are not Good at VBA, then nothing in VBA will be "easy"
;-)

Also the Email portion of this complicates this even more...

Again, familiarize yourself with Mail Merge First.
Then decide if you need this "Automated".
If you do need the automation, then you will have to also learn VBA...
:-O
So then you can investigate the links I posted

...Emailing the Merged data is another topic altogether...

In other words, there are no easy answers here if you are new to mail merge.
:-(

JeffCoachman
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now