Hello World! : )

[MickC]

Hi guys and girls

I am an Access enthusiast but still struggle to get my head round VBA as my business means constant interruptions if I do get the time to try and study. I am quite proficient at the basic stuff but am always coming up against the odd issue or two!

I have a database for my business (B & B) for recording details of guests and their details, from which I send all my regular emails as a report in PDF format exported to Outlook. The title and message fields are populated and the process is automated using queries and a set of command buttons on my parameter form.

What I would ideally like to do is pass the email address contained in the parameter form to the exported report, rather than having to copy and paste it as I currently do, thereby automating the process a little more. I think I saw something in a related thread which seemed to indicate this can only be done by coding Outlook.

Does anyone know if there's a way of doing so using the Expression Builder?

It would be mighty helpful if you do, thanks.

Mick

 

[pbaldy]

Welcome Mick! I moved your thread out of introductions since it included a question. You should be able to include a reference to the form control in the email code/macro.

 

[MickC]

Hi Paul

Thanks on both counts.

I'll see how I can get on with the email.

Regards
Mick

 

[MickC]

Hi Paul

I got it working fine in the end. In the "To" filed of the email output dialog I typed "=" which invoked the expression builder, I then selected the Email field from there. Hey presto it works absolutely fine now!

Regards
Mick

 

[pbaldy]

Great Mick, glad you got it working!