mail merge by email hyperlink

[Mary10k]

Is there a way to do a mass mail merge via hyperlinks in a table? I have hundreds of accounts with an email address and I would like to send out mailings via email.
Thank you

 

[Robbo1974]

You can use the Word mail merge feature - there is an option to 'merge to email' in the mail merge dialog. You can send as text or as an attachment.

I only know how to do it manually, but give me a shout if you need more help.
Robbo ;-)

 

[BoxHead]

You could also use the sendobject method. instead of hard-coding the "To" parameter, you can refer to a variable.

Let's say you had a list box with your contacts names in it and you'll double click on a name to move it into an unbound textbox (txtOnList) and include it in the mailing.

On the double-click event,

    txtOnList = txtOnList & "; " & ListBoxSelection

Your variable would then refer to the string you built with the listbox minus the extra semicolon at the end:

    MyMailList = Left(txtOnList, Len(txtOnList) - 2)

HTH
John

Use what you have,
Learn what you can,
Create what you need.