Dynamic Change Merge Fields - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Dynamic Change Merge Fields

Tom Mura

10 months ago

I want to be able to assign a Merge field on the form so that I don't have to change the vba each time I want to merge something different. I've tried this code:

mBody = Replace(mBody, Forms!EmailBulkF!ChangeFromTxt, Nz(rs(Forms!EmailBulkF!ChangeToTxt), ""))

The text in the "ChangeFromTxt" unbound text box is *Jersey* and the text in the "ChangeToText" unbound text box is JerseyStyle. I've confirmed that there is a field in the record set called JerseyStyle. I've tried a number of different field names, including ones that are in the vba code like *FirstName*:
mBody = Replace(mBody, "*FirstName*", Nz(rs!FirstName, ""))

Any help would be appreciated.

Thanks,

Tom

	Tom Mura OP @Reply 10 months ago
I should have given the result of my code. It just shows Jersey in the body of the email rather than the merged data from the RS.

Donald Blackwell @Reply

10 months ago

Hi Tom,

I threw a quick form/table together and used the code you provided and it replaces the *Jersey* as you would expect. So if it's not working for you, I would try the basics first such as:

Save, close, open
Save, Debug, Compile
etc.

If still not seeing expected results, then I would look at the code before what you've provided, i.e. the code forming your recordset, and, what or how many records it is pulling. does it need to loop through results, or what lookups you're doing to narrow it down to just one result, etc. or even a simple typo in the open recordset, etc.

To help you any more would need more of your code, screenshots of table(s), form(s), etc.

	Tom Mura OP @Reply 10 months ago
Thanks, I'll try that.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View