Customized strings in mass-emails with Access VBA

Vote count: 0

I'm trying to put together a tool to send mass emails to a query of users from a database table. I'm using the SendObject method and it works well enough.

SendObject(ObjectType, ObjectName, OutputFormat, To, Cc, Bcc, Subject, MessageText, EditMessage, TemplateFile)

I'm using vbNewLine to denote line breaks in the MessageText string field currently but I want to create some kind prompt that would ask the user to type in their message and automatically format it with line breaks when the macro is ran so I can ship the macro off to my coworkers. The emails I want to send are newsletters several paragraphs long tailored to each individual recipient (ie: John Doe = Dear John Doe, Gary Stu = Dear Gary Stu)

Is what I'm looking to do possible? SendObject can be set to prompt the user with an option to edit the outlook email before sending it but each of the modifications is unique to each individual email.

asked 15 secs ago

enmasse

Let's block ads! (Why?)

Customized strings in mass-emails with Access VBA