Email Message

G

Guest

I have a macro the fires out a snap shot of a report based on a record. Each
record has a unique number - how do i get this number to appear in either the
subject line or the message body of the email ?

Thanks for any help
 
G

Guest

Thanks Steve, much appreciated

Steve Schapel said:
Andy,

Something like this...
="Blabla " & [UniqueNumber] & " bla"

--
Steve Schapel, Microsoft Access MVP

Andy said:
I have a macro the fires out a snap shot of a report based on a record. Each
record has a unique number - how do i get this number to appear in either the
subject line or the message body of the email ?

Thanks for any help
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Access to generate email 3
Outlook Looking for macro to save multiple emails as .msg to folder and extracting the invoice ref. from the email body as the filename 4
search button 1
Access Automatically Send a notification email once a record is added 0
Send a single report 8
Find, Copy, Sort, Forward, Add Text - COMPLICATED! 1
macro - repeat - gotorecord - next 6
Set a macro to send an email 2

Top