Hi all,
Is it possible, just like you would do on a mail merge in Word, to have a report that is predominantly text, but that has inserts which refers to the results of a query.
For example, a query may return the result of a persons name and address, and I would need this to form part of the report not just in an address format, but also in the body of the letter. What would be the best way to do this?
E.G.
[Title] [Forename] [Surname}
[Add 1]
[Add 2]
[Add 3]
[Add 4]
[Add 5]
[Date]
Dear [Title] [Surname],
With reference to your [Account Type] membership with us, we would like to invite you and a guest to a banquet celebrating our 10th Anniversary. The invite is strictly for yourself [Forename] as we are keen to only have account holders at the event.
Don't take the above example literally as I wouldn't be using access for something like this!
Thanks
Rob
Is it possible, just like you would do on a mail merge in Word, to have a report that is predominantly text, but that has inserts which refers to the results of a query.
For example, a query may return the result of a persons name and address, and I would need this to form part of the report not just in an address format, but also in the body of the letter. What would be the best way to do this?
E.G.
[Title] [Forename] [Surname}
[Add 1]
[Add 2]
[Add 3]
[Add 4]
[Add 5]
[Date]
Dear [Title] [Surname],
With reference to your [Account Type] membership with us, we would like to invite you and a guest to a banquet celebrating our 10th Anniversary. The invite is strictly for yourself [Forename] as we are keen to only have account holders at the event.
Don't take the above example literally as I wouldn't be using access for something like this!
Thanks
Rob